Microsoft SQL Server Error:53

Question

Hello I am facing while connecting to SQL Server 2012 Express like

"A Network-related or instance-specific error occured while establishing a connection to SQL Server. The server was not found or was not accessible.Verfy the instance name is correct and the SQL Server is configured to allow remote connection. (provider: Named Pipes provider:40-could not open a connection to SQL Server) (Microsoft SQL Server, Error:53) ".

How to resolve it ?

Attachment: error 53 in sql server2012.rar

Khan Abrar Ahmed · Answer

Hi can you check in the sql server configuration did u enable TCP IP port. 1. Open the SQL server configuration Manager. 2. select the SQL server network configuration. 3. Click on protocols 4. enable the TCP/IP and Named pipes settings.

D Dasawari · Answer

Thanks to you both. My problem is resolved after putting ip address and port number instead of putting any name in server name

Manoj Bhoir · Answer

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 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

D Dasawari · Answer

Not solved. same error like earlier .

Rajeesh Menoth · Answer

Hi Problem Solved ?

D Dasawari · Answer

I already enabled TCP IP port but still facing same