| Author |
 Topic  |
|
|
ron2112
Starting Member
USA
44 Posts |
 Posted - 01/07/2010 : 15:39:52
|
Got a strange one here. Two WinXP client machines and a third machine running SQL Server Express 2005... Client A can connect to the SQL Server just fine, Client B can see the server instance in the browser but cannot connect (attempted using the sa account via SSMS). At this point, the error coming back was 26, "Error Locating Service/Instance Specified."
Since Client A can connect, we know that the SQL Server is running and is configured to accept remote connections. So we set up an alias on Client B. This did not resolve the situation, but it did change the error to 10061, "No connection could be made because the target machine actively refused it."
After this we tried the following:
> Confirmed TCP/IP is enabled on the server.
> Confirmed TCP/IP is using port 1433 and so is the alias on Client B.
> Tried using the server's IP address instead of the machine name.
And we're still stuck at error 10061 on Client B. I'm not sure what else there is to look at... anyone have any suggestions?
Thanks!
Ron Moses |
|
|
shan
Yak Posting Veteran
USA
79 Posts |
Posted - 01/07/2010 : 16:01:02
|
Try connecting with the IP Address, portnumber and see if it works.
-Shan |
 |
|
|
ron2112
Starting Member
USA
44 Posts |
Posted - 01/08/2010 : 08:31:44
|
quote:
Originally posted by shan
Try connecting with the IP Address, portnumber and see if it works.
Did that, same result. That's what I meant in my third bullet item, sorry if that was unclear.
Ron Moses |
|
|
|
russell
Pyro-ma-ni-yak
USA
5037 Posts |
|
|
ron2112
Starting Member
USA
44 Posts |
|
|
russell
Pyro-ma-ni-yak
USA
5037 Posts |
Posted - 01/08/2010 : 12:05:11
|
| you created an alias. is that alias using TCP/IP or Named Pipes? Make sure TCP/IP |
|
|
| |
Topic |
|
Error 10061, connection actively refused
