{"id":1045,"date":"2012-09-26T06:58:05","date_gmt":"2012-09-26T06:58:05","guid":{"rendered":"http:\/\/techsupport.relyonsoft.in\/?p=1045"},"modified":"2014-04-23T10:00:41","modified_gmt":"2014-04-23T10:00:41","slug":"error-0-an-error-has-occurred-while-establishing-a-connection-to-the-server-when-connecting-to-sql-server-2005-the-failure-may-be-caused-by-the-fact-that-under-the-default-settings-sql-server-does","status":"publish","type":"post","link":"https:\/\/relyonsoft.in\/techsupport\/error-0-an-error-has-occurred-while-establishing-a-connection-to-the-server-when-connecting-to-sql-server-2005-the-failure-may-be-caused-by-the-fact-that-under-the-default-settings-sql-server-does\/","title":{"rendered":"Error 0: An error has occurred while establishing a connection to the server. When connecting to Sql Server 2005, the failure may be caused by the fact that under the default settings Sql server does not allow remote connections."},"content":{"rendered":"

Error:<\/strong><\/p>\n

An error has occurred while establishing a connection to the server. When connecting to Sql Server 2005, the failure may be caused by the fact that under the default settings Sql server does not allow remote connections. (Provider: TCP Provider, Error: 0 – A connection attempt failed because the connected party did not properly respond after a \u00a0period of time, or established connection failed because connected host has failed to respond.)<\/p>\n

Snapshot<\/strong>:<\/strong><\/p>\n

\"\"<\/a><\/p>\n

Causes:<\/strong><\/p>\n

Server side:<\/strong><\/p>\n

Make sure that you have enabled remote connections on the instance<\/p>\n

Make sure that firewall is OFF.<\/p>\n

Create an exception for SqlBrowser and SqlServer in server computer.<\/p>\n

Client side:<\/strong><\/p>\n

Make sure that you have typed correct server computer name and instance name<\/p>\n

Make sure that server machine is reachable. Check you are able to ping the server.<\/p>\n

Make sure that you are able to access the shared folder of remote server.<\/p>\n

Make sure that you are able to connect SQL Server using the Telnet command.<\/p>\n

Workaround 1:<\/strong><\/p>\n

Enable Using both TCP\/IP and Named Pipes:<\/p>\n

All programs | Microsoft SQL Server 2005| Configuration Tools | SQL Server Surface Area Configuration | Configuration for Services and Connections | Remote Connections, choose Local and Remote Connections |Select Using both TCP\/IP and Named Pipes | Click Apply<\/p>\n

Restart SQL Server RELYONDB & SQL Server Browser service.<\/p>\n

Workaround 2:<\/strong><\/p>\n

Enable Using both TCP\/IP and Named Pipes:<\/p>\n

All programs | Microsoft SQL Server 2005| Configuration Tools | SQL Server Configuration Manager| SQL Server Network configuration| Right Click “Named Pipes” & Click Enable > Right Click “TCP\\IP” & Click Enable<\/p>\n

Restart SQL Server RELYONDB and SQL Server Browser service.<\/p>\n

Workaround 3:<\/strong><\/p>\n

Click Start | Run | type firewall.cpl | Switch Off | Click OK.<\/p>\n

or<\/p>\n

Create an exception in windows firewall.<\/p>\n

Add TCP port or sqlservr.exe to Firewall exception list, either add “..\\Binn\\sqlsevr.exe” or add port.<\/p>\n

Add Sql Browser service to Firewall exception list, you can either add program ” C:\\Program Files\\Microsoft SQL Server\\90\\Shared\\sqlbrowser.exe” or add UDP port 1434.<\/p>\n

Workaround 4: [Client side]<\/strong><\/p>\n

Check whether PINGing is happening in both client and server systems<\/p>\n

Click Start | Run | type cmd| Click OK<\/p>\n

Open command prompt as Run as Administrator | Type PING <ServerIPAddress><\/p>\n

Workaround 5: [Client side]<\/strong><\/p>\n

Resolve DNS cache:<\/p>\n

Click Start | Run | type cmd| Click OK<\/p>\n

Open command prompt as Run as Administrator |\u00a0 type ipconfig \/flushdns<\/p>\n

Workaround 6: [Client side]<\/strong><\/p>\n

Give server IP address in connection string instead of hostname.<\/p>\n","protected":false},"excerpt":{"rendered":"

Error: An error has occurred while establishing a connection to the server. When connecting to Sql Server 2005, the failure may be caused by the fact that under the default settings Sql server does not allow remote connections. (Provider: TCP Provider, Error: 0 – A connection attempt failed because the connected party did not properly […]<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":[],"categories":[4],"tags":[],"_links":{"self":[{"href":"https:\/\/relyonsoft.in\/techsupport\/wp-json\/wp\/v2\/posts\/1045"}],"collection":[{"href":"https:\/\/relyonsoft.in\/techsupport\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/relyonsoft.in\/techsupport\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/relyonsoft.in\/techsupport\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/relyonsoft.in\/techsupport\/wp-json\/wp\/v2\/comments?post=1045"}],"version-history":[{"count":0,"href":"https:\/\/relyonsoft.in\/techsupport\/wp-json\/wp\/v2\/posts\/1045\/revisions"}],"wp:attachment":[{"href":"https:\/\/relyonsoft.in\/techsupport\/wp-json\/wp\/v2\/media?parent=1045"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/relyonsoft.in\/techsupport\/wp-json\/wp\/v2\/categories?post=1045"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/relyonsoft.in\/techsupport\/wp-json\/wp\/v2\/tags?post=1045"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}