Trying to connect db server from another server

Category: sql server tools


Venkatesh.dba on Fri, 18 Apr 2014 22:04:59

Hello team,

Today i tried to connect db server(Named instance)  from another server and that was failed. im getting below error

any one help on this will be appreciated.

unable to check connection to the repository The Tcp/Ip connection to the host server, port 1433 has failed.
Error: "connection refused: connect. verify the connection properties. Make sure that an instance of sql server is running on the host and accepting Tcp/Ip connections at the port. make sure that Tcp connections to the port are not blocked bya firewall.


Sean Gallardy on Fri, 18 Apr 2014 22:33:04


Normally "Connection Refused" is caused by firewalls actively closing the requests. Also, please note that by default named instances use dynamic ports and do not listen on 1433. If you are using dynamic ports, make sure the browser service is started and that UDP 1434 is allowed for browser service communication.