November 16, 2001 at 10:48 am
newbie question.
I'm having a trouble trying to connect with Enterprise manager to a remote SQL server 2000, I con connect to the default instance using IP address (ths because SQL is in another subnet)but when I try to connect to IP_Address/Instance_name I've got back an error, that's works locally. Can you help me?
Thanks in adv.
November 16, 2001 at 10:58 am
Not 100% sure, but I think the port number won't be 1433. Have a look on the server to see what it's using.
Paul Ibison
Paul Ibison
Paul.Ibison@replicationanswers.com
November 16, 2001 at 11:02 am
Have just mimiced this on my work system, and found I needed to check Dynamically Determine Port - hope this helps.
Paul Ibison
Paul Ibison
Paul.Ibison@replicationanswers.com
November 16, 2001 at 12:33 pm
If you're using SQL7 EM, you'd have to set an alias I think. Also your workstations need ADO 2.6 to work with instances without using an alias.
Andy
November 19, 2001 at 7:43 pm
Viewing 5 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply