October 31, 2008 at 10:20 am
On my XP Pro SP2 laptop, I have a default instance and 3 named instances of SQL2005, all set up (as best as I can tell) the same. I can connect to all of them from my own machine; however, I can connect to only the default instance from other machines on the network.
* In the SQL Svr Config Mgr, all instances have TCP\IP enabled.
* In the SQL Svr Surface Area Config tool, all instances have "Local and Remote Connections" enabled, "using TCP\IP only."
* In each case, I am connecting (or attempting to connect) as SA.
* No firewall.
Another XP Pro SP2 machine on the network with a named instance allows remote connections to that named instance, though it is the only instance on that machine. This named instance was created with the same script as one of the named instances on my laptop.
Why can I not connect to the named instances on my machine from other machines on the network?
October 31, 2008 at 12:12 pm
If you have multiple instances make sure SQL Browser Service is running as I believe it is required to access other instances than the default one. You should also verify the Instance name and port to make sure it matches. If that is all fine the test if you can telnet to the port from a remote machine? I know you said no firewall, but test and see if you can get a telnet on the port (1433 by default) to open to see if connectivity at the core is there.
October 31, 2008 at 8:02 pm
Yes, That is correct make sure your browser service is Running.
Start- run - services.msc , hit enter.
check for SQL Server Browser , if this is running or not. If not then start this service and you should be able to connect.
If this does not work, try disabling Windows firewall for a moment and then check if you can connect, If Windows firewall is the problem, then make exception for port 1433.
Hope this helps,
Imran Mohammed.
November 2, 2008 at 11:11 pm
have you checked the port?
I had the similar issue before, then found that it's the port number...
the named instance port is not like 1433, so I have to add Alias on the Client side..
November 3, 2008 at 6:44 am
Sure 'nuf, the browser was the difference. Thank you all for your help.
I'll be studying to get a better understanding of how the ports are used between instances as well. Thanks again to all of you.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply