{"id":143,"date":"2012-08-21T12:17:21","date_gmt":"2012-08-21T12:17:21","guid":{"rendered":"http:\/\/techsupport.relyonsoft.in\/?p=143"},"modified":"2013-12-28T09:36:29","modified_gmt":"2013-12-28T09:36:29","slug":"error-0-a-connection-was-successfully-established-with-the-server-but-then-an-error-occurred-during-the-login-process","status":"publish","type":"post","link":"https:\/\/relyonsoft.in\/techsupport\/error-0-a-connection-was-successfully-established-with-the-server-but-then-an-error-occurred-during-the-login-process\/","title":{"rendered":"Error 0: A connection was successfully established with the server, but then an error occurred during the login process."},"content":{"rendered":"

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

A connection was successfully established with the server, but then an error occurred during the login process. (Provider: TCP Provider, error: 0 \u2013 The specified network name is no longer available.)<\/p>\n

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

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

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

    \n
  1. SQL Server [RELYONDB] service might be stopped.<\/li>\n
  2. SQL Browser service might be stopped.<\/li>\n
  3. Remote connections [TCP\/IP and Named Pipes] might be disabled.<\/li>\n
  4. Firewall on the server system may be refusing the connection.<\/li>\n
  5. Make sure that you have typed correct server computer name and instance name.<\/li>\n
  6. Make sure that server machine is reachable. Check you are able to ping the server.<\/li>\n<\/ol>\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 Configuration Manager| SQL Server Network configuration|\u00a0Right Click “Named Pipes” & Click Enable > Right Click “TCP\\IP” & Click Enable<\/p>\n

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

    Workaround<\/strong> 2:<\/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 |Enable Using both TCP\/IP and Named Pipes.<\/p>\n

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

    Workaround<\/strong> 3:\u00a0<\/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","protected":false},"excerpt":{"rendered":"

    Error: A connection was successfully established with the server, but then an error occurred during the login process. (Provider: TCP Provider, error: 0 \u2013 The specified network name is no longer available.) Error Message: Causes: SQL Server [RELYONDB] service might be stopped. SQL Browser service might be stopped. Remote connections [TCP\/IP and Named Pipes] might […]<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[4],"tags":[],"_links":{"self":[{"href":"https:\/\/relyonsoft.in\/techsupport\/wp-json\/wp\/v2\/posts\/143"}],"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=143"}],"version-history":[{"count":0,"href":"https:\/\/relyonsoft.in\/techsupport\/wp-json\/wp\/v2\/posts\/143\/revisions"}],"wp:attachment":[{"href":"https:\/\/relyonsoft.in\/techsupport\/wp-json\/wp\/v2\/media?parent=143"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/relyonsoft.in\/techsupport\/wp-json\/wp\/v2\/categories?post=143"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/relyonsoft.in\/techsupport\/wp-json\/wp\/v2\/tags?post=143"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}