my host has moved my sql database to another server. They gave me a new IP address, but they said that I have to connect through a certain port through enterprise manager. That port is 1042 not the default 1433.
So, I created a new sql server registration using the ip address. it didnt connect, of course. I went ahead and told EM to keep the registration even though it wasnt completed. I heard that you can right click on the node on the left and choose properties to change the port number. Well every time that I right click on the bugger, it tries to connect to the sql database, not give me a choice of properties to change.
I also highlighted the thing and chose properties from the toolbar at the top. Still nothing. The only thing I do get is an option to type in the username/password. There is NO PLACE to change the port.
I even tried going into the registry and changing the default port of 1433 to 1042. NOTHING. EM still craps out and tells me the connection failed due to the db not being there or the connection was refused.
How do I get this thing to connect to the sql server?
Also, is there another program that will do what Entreprise Manager does, but isn't such a piece of.....?Have you tried registering the SQL Server with the syntax
<IP Address>:<port>
eg
192.168.1.1:1042
No comments:
Post a Comment