{"id":1017,"date":"2012-09-25T05:02:15","date_gmt":"2012-09-25T05:02:15","guid":{"rendered":"http:\/\/techsupport.relyonsoft.in\/?p=1017"},"modified":"2014-04-23T10:04:45","modified_gmt":"2014-04-23T10:04:45","slug":"error-19-a-transport-level-error-has-occurred-when-sending-the-request-to-the-server-provider-session-provider-physical-connection-is-not-usable","status":"publish","type":"post","link":"https:\/\/relyonsoft.in\/techsupport\/error-19-a-transport-level-error-has-occurred-when-sending-the-request-to-the-server-provider-session-provider-physical-connection-is-not-usable\/","title":{"rendered":"Error 19: A transport-level error has occurred when sending the request to the server. (Provider: Session Provider, Physical connection is not usable)"},"content":{"rendered":"

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

A transport-level error has occurred when sending the request to the server. (Provider: Session Provider, error: 19 \u2013 Physical connection is not usable)<\/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 RELYONDB<\/p>\n

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

Create an exception for SqlBrowser.exe and SqlServer.exe 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

Enter correct system name and instance name.<\/p>\n

VIA protocol might be enabled and it may be using port 1433.<\/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 |Enable Using both TCP\/IP and Named Pipes.<\/p>\n

Restart SQL Server RELYONDB & SQL Server Browser service.<\/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 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<\/strong>\u00a03:\u00a0<\/strong><\/p>\n

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

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

Disable “VIA” protocol:<\/p>\n

Open SQL Server Configuration Manager as Run as Administrator<\/p>\n

All programs | Microsoft SQL Server 2005| Configuration Tools | SQL Server Configuration Manager | SQL Server Network configuration | Protocols for RELYONDB<\/p>\n

The status of “VIA” protocol should be disabled |<\/p>\n

Right click “VIA” | Properties | Default Port should be empty.<\/p>\n","protected":false},"excerpt":{"rendered":"

Error: A transport-level error has occurred when sending the request to the server. (Provider: Session Provider, error: 19 \u2013 Physical connection is not usable) Snapshot: Causes: Server side: Make sure that you have enabled remote connections on the instance RELYONDB Make sure that firewall is OFF. Create an exception for SqlBrowser.exe and SqlServer.exe in server […]<\/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\/1017"}],"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=1017"}],"version-history":[{"count":0,"href":"https:\/\/relyonsoft.in\/techsupport\/wp-json\/wp\/v2\/posts\/1017\/revisions"}],"wp:attachment":[{"href":"https:\/\/relyonsoft.in\/techsupport\/wp-json\/wp\/v2\/media?parent=1017"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/relyonsoft.in\/techsupport\/wp-json\/wp\/v2\/categories?post=1017"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/relyonsoft.in\/techsupport\/wp-json\/wp\/v2\/tags?post=1017"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}