Cannot connect to remote SQL Database with SQL Server Management Console (Error 53)

Question

I have opened up port 1433 on my firewall, but every time I try and connect to my remote SQL Database with SQL Server Management Console I receive (Microsoft SQL Server, Error: 53)

Answer 1

https://social.technet.microsoft.com/wiki/contents/articles/2102.how-to-troubleshoot-connecting-to-the-sql-server-database-engine.aspx

http://blog.sqlauthority.com/2009/05/21/sql-server-fix-error-provider-named-pipes-provider-error-40-could-not-open-a-connection-to-sql-server-microsoft-sql-server-error/

http://blogs.msdn.com/b/walzenbach/archive/2010/04/14/how-to-enable-remote-connections-in-sql-server-2008.aspx

Enable remote connections for SQL Server Express 2012

Short Answer

• 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

Hail Mary Pass 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

Answer 2

What you need to do is go into SQL Server Configuration Manager where SQL Server is installed.

In the Start Menu, under the Microsoft SQL Server folder, open the Configuration Tools folder and select SQL Server Configuration Manager.

In the Config Manager, click the arrow next to SQL Server Network Configuration, then click on "Protocols for {Instance}". {Instance} will be your install, if it's the default instance it will be MSSQLSERVER.

On the right side, make sure that TCP/IP is "Enabled". Double click TCP/IP, in the window that opens, change the drop down to "Yes".