{"id":251,"date":"2012-06-27T10:48:31","date_gmt":"2012-06-27T10:48:31","guid":{"rendered":"https:\/\/sqlserverlearner.azurewebsites.net\/2012\/06\/27\/msg-10054-level-20-state-0-line-0\/"},"modified":"2012-06-27T10:48:31","modified_gmt":"2012-06-27T10:48:31","slug":"msg-10054-level-20-state-0-line-0","status":"publish","type":"post","link":"https:\/\/sqlserverlearner.com\/2012\/06\/27\/msg-10054-level-20-state-0-line-0\/","title":{"rendered":"Msg 10054, Level 20, State 0, Line 0"},"content":{"rendered":"<p><strong>Error Message:<\/strong><br \/>\n<font color=\"red\"><br \/>\n.Net SqlClient Data Provider: Msg 10054, Level 20, State 0, Line 0<br \/>\nA transport-level error has occurred when sending the request to the server. (provider: TCP Provider, error: 0 &#8211; An existing connection was forcibly closed by the remote host.)<br \/>\n<\/font><\/p>\n<p>This error Occurs when the connection is forcibly closed by SQL Server.<\/p>\n<p><strong>Possible Reasons:<\/strong><br \/>\n&#8211; When the connection was IDLE for a long time<br \/>\n&#8211; SQL Server Service is restarted \/ Stopped<br \/>\n&#8211; The database to which the connection is connected to is restored<br \/>\n&#8211; KILL Command is issued by any other user.<\/p>\n<p><strong>Resolution\/fix:<\/strong><br \/>\nTry to reconnect to the server<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Error Message: .Net SqlClient Data Provider: Msg 10054, Level 20, State 0, Line 0 A transport-level error has occurred when sending the request to the server. (provider: TCP Provider, error: 0 &#8211; An existing connection was forcibly closed by the remote host.) This error Occurs when the connection is forcibly closed by SQL Server. Possible&hellip;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2157],"tags":[2158,2159,2160,2161,2162,2163],"class_list":["post-251","post","type-post","status-publish","format-standard","hentry","category-msg-10054","tag-net-sqlclient-data-provider-msg-10054-level-20-state-0-line-0","tag-a-transport-level-error-has-occurred-when-sending-the-request-to-the-server","tag-msg-10054","tag-msg-10054-level-20","tag-msg-10054-transport-level-error","tag-provider-tcp-provider-error-0-an-existing-connection-was-forcibly-closed-by-the-remote-host"],"_links":{"self":[{"href":"https:\/\/sqlserverlearner.com\/wp-json\/wp\/v2\/posts\/251","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/sqlserverlearner.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/sqlserverlearner.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/sqlserverlearner.com\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/sqlserverlearner.com\/wp-json\/wp\/v2\/comments?post=251"}],"version-history":[{"count":0,"href":"https:\/\/sqlserverlearner.com\/wp-json\/wp\/v2\/posts\/251\/revisions"}],"wp:attachment":[{"href":"https:\/\/sqlserverlearner.com\/wp-json\/wp\/v2\/media?parent=251"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sqlserverlearner.com\/wp-json\/wp\/v2\/categories?post=251"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sqlserverlearner.com\/wp-json\/wp\/v2\/tags?post=251"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}