Microsoft SQL Server, Error:53

Hi,

 

Problem Solved   ?

Hi,

• Check Firewall
• Check Service is Running
• Check TCP/IP is Enabled
• Check SQL Server Properties "Allow Remote Connections"
• Check if the SQL Server is on a restricted subnet

Then Run these if Those Do not Resolve

• Right-click on TCP/IP and select Properties.
• Verify that, under IP2, the IP Address is set to the computer's IP address on the local subnet.
• Scroll down to IPAll.
• Make sure that TCP Dynamic Ports is blank.
• Make sure that TCP Port is set to 1433.
• If you have a named instance then you must have the SQL Server Browser Service enabled
• The browser service runs on port UDP 1434 and this must be allowed through your firewall

If this is Still not Resolved

Go to the client machine, and run cliconfg.exe If named pipes is listed first, demote it, and promote TCP/IP.
check if the firewall is blocking the named pipes port, which usually is 445

 

Reference : http://stackoverflow.com/questions/16445243/cannot-connect-to-remote-sql-database-with-sql-server-management-console-error