{"id":1273,"date":"2013-03-25T11:25:54","date_gmt":"2013-03-25T11:25:54","guid":{"rendered":"http:\/\/techsupport.relyonsoft.in\/?p=1273"},"modified":"2014-04-23T09:39:43","modified_gmt":"2014-04-23T09:39:43","slug":"a-connection-was-successfully-established-with-the-server-but-then-an-error-occurred-during-the-pre-login-handshake","status":"publish","type":"post","link":"https:\/\/relyonsoft.in\/techsupport\/a-connection-was-successfully-established-with-the-server-but-then-an-error-occurred-during-the-pre-login-handshake\/","title":{"rendered":"A connection was successfully established with the server, but then an error occurred during the pre-login handshake."},"content":{"rendered":"<p><strong>Error:<\/strong><\/p>\n<p style=\"text-align: justify;\">A connection was successfully established with the server, but then an error occurred during the pre-login handshake. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (<strong>Provider: Named Pipes Provider, error: 0<\/strong>\u00a0&#8211; No process is on the other end of the pipe.)<\/p>\n<p><strong><strong>Snapshot<\/strong>:<\/strong><\/p>\n<p><a href=\"http:\/\/techsupport.relyonsoft.in\/wp-content\/uploads\/2013\/03\/SQL-Error-0.jpg\"><img loading=\"lazy\" class=\"alignnone size-full wp-image-1275\" title=\"SQL Error 0\" src=\"http:\/\/techsupport.relyonsoft.in\/wp-content\/uploads\/2013\/03\/SQL-Error-0.jpg\" alt=\"\" width=\"404\" height=\"129\" srcset=\"https:\/\/relyonsoft.in\/techsupport\/wp-content\/uploads\/2013\/03\/SQL-Error-0.jpg 404w, https:\/\/relyonsoft.in\/techsupport\/wp-content\/uploads\/2013\/03\/SQL-Error-0-300x95.jpg 300w\" sizes=\"(max-width: 404px) 100vw, 404px\" \/><\/a><\/p>\n<p><strong>Workaround 1:<\/strong><\/p>\n<p>Instead of machine name use IP address<\/p>\n<p>&lt;ipaddress\\instancename&gt;<\/p>\n<p><strong>Workaround 2:<\/strong><\/p>\n<p>Enable Using both TCP\/IP and Named Pipes:<\/p>\n<p style=\"text-align: justify;\">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<p>Restart SQL Server RELYONDB &amp; SQL Server Browser service.<\/p>\n<p><strong>Workaround 3:<\/strong><\/p>\n<p>Enable Using both TCP\/IP and Named Pipes:<\/p>\n<p>All programs | Microsoft SQL Server 2005| Configuration Tools | SQL Server Configuration Manager| SQL Server Network configuration| Right Click &#8220;Named Pipes&#8221; &amp; Click Enable &gt; Right Click &#8220;TCP\\IP&#8221; &amp; Click Enable<\/p>\n<p>Restart SQL Server RELYONDB and SQL Server Browser service.<\/p>\n<p><strong>Workaround 4:<\/strong><\/p>\n<p>Click Start | Run | type firewall.cpl | Switch Off | Click OK.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Error: A connection was successfully established with the server, but then an error occurred during the pre-login handshake. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (Provider: Named Pipes Provider, error: 0\u00a0&#8211; No process is on the [&hellip;]<\/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\/1273"}],"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=1273"}],"version-history":[{"count":0,"href":"https:\/\/relyonsoft.in\/techsupport\/wp-json\/wp\/v2\/posts\/1273\/revisions"}],"wp:attachment":[{"href":"https:\/\/relyonsoft.in\/techsupport\/wp-json\/wp\/v2\/media?parent=1273"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/relyonsoft.in\/techsupport\/wp-json\/wp\/v2\/categories?post=1273"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/relyonsoft.in\/techsupport\/wp-json\/wp\/v2\/tags?post=1273"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}