“An error has occurred while establishing a connection to the server. When connecting to SQL Server 20xx, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: TCP Provider, error: 0 – No connection could be made because the target machine actively refused it.) (Microsoft SQL Server, Error: 10061)”<\/p>\n
You receive this error if the SQL Server service that you are trying to connect to is not running.<\/p>\n
Make sure that your SQL Server service is running. For this:<\/p>\n
Run SQL Server Configuration Manager and check that the SQL Server service that belongs to Instance is running from the “SQL Server Services” tab.<\/p>\n
or you can do it from service.msc.\u00a0You can find the SQL Service by typing Services.msc in Windows and you can do the necessary check in here.<\/p>\n\n
<\/div>\n
<\/path><\/svg><\/i> <\/div>\n","protected":false},"excerpt":{"rendered":"
ERROR MESAGGE: “An error has occurred while establishing a connection to the server. When connecting to SQL Server 20xx, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: TCP Provider, error: 0 – No connection could be made because the target machine …<\/p>\n
<\/div>\n
<\/path><\/svg><\/i> <\/div>\n","protected":false},"author":423,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"_uf_show_specific_survey":0,"_uf_disable_surveys":false,"footnotes":""},"categories":[3],"tags":[],"class_list":["post-6484","post","type-post","status-publish","format-standard","","category-mssql"],"aioseo_notices":[],"yoast_head":"\n
An error has occurred while establishing a connection to the server...No connection could be made because the target machine actively refused it - Database Tutorials<\/title>\n<meta name=\"description\" content=\"An error has occurred while establishing a connection to the server. When connecting to SQL Server 20xx, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: TCP Provider, error: 0 - No connection could be made because the target machine actively refused it.) (Microsoft SQL Server, Error: 10061)\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/dbtut.com\/index.php\/2018\/12\/11\/an-error-has-occurred-while-establishing-a-connection-to-the-server-no-connection-could-be-made-because-the-target-machine-actively-refused-it\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"An error has occurred while establishing a connection to the server...No connection could be made because the target machine actively refused it - Database Tutorials\" \/>\n<meta property=\"og:description\" content=\"An error has occurred while establishing a connection to the server. When connecting to SQL Server 20xx, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: TCP Provider, error: 0 - No connection could be made because the target machine actively refused it.) (Microsoft SQL Server, Error: 10061)\" \/>\n<meta property=\"og:url\" content=\"https:\/\/dbtut.com\/index.php\/2018\/12\/11\/an-error-has-occurred-while-establishing-a-connection-to-the-server-no-connection-could-be-made-because-the-target-machine-actively-refused-it\/\" \/>\n<meta property=\"og:site_name\" content=\"Database Tutorials\" \/>\n<meta property=\"article:published_time\" content=\"2018-12-11T11:52:29+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2018-12-21T13:17:13+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/12\/226.png\" \/>\n<meta name=\"author\" content=\"Ekrem \u00d6nsoy\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Ekrem \u00d6nsoy\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/12\/11\/an-error-has-occurred-while-establishing-a-connection-to-the-server-no-connection-could-be-made-because-the-target-machine-actively-refused-it\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/12\/11\/an-error-has-occurred-while-establishing-a-connection-to-the-server-no-connection-could-be-made-because-the-target-machine-actively-refused-it\/\"},\"author\":{\"name\":\"Ekrem \u00d6nsoy\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/42a3e874ed0bf8053fa123a3a1f6ee46\"},\"headline\":\"An error has occurred while establishing a connection to the server…No connection could be made because the target machine actively refused it\",\"datePublished\":\"2018-12-11T11:52:29+00:00\",\"dateModified\":\"2018-12-21T13:17:13+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/12\/11\/an-error-has-occurred-while-establishing-a-connection-to-the-server-no-connection-could-be-made-because-the-target-machine-actively-refused-it\/\"},\"wordCount\":173,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/12\/11\/an-error-has-occurred-while-establishing-a-connection-to-the-server-no-connection-could-be-made-because-the-target-machine-actively-refused-it\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/12\/226.png\",\"articleSection\":[\"MSSQL\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2018\/12\/11\/an-error-has-occurred-while-establishing-a-connection-to-the-server-no-connection-could-be-made-because-the-target-machine-actively-refused-it\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/12\/11\/an-error-has-occurred-while-establishing-a-connection-to-the-server-no-connection-could-be-made-because-the-target-machine-actively-refused-it\/\",\"url\":\"https:\/\/dbtut.com\/index.php\/2018\/12\/11\/an-error-has-occurred-while-establishing-a-connection-to-the-server-no-connection-could-be-made-because-the-target-machine-actively-refused-it\/\",\"name\":\"An error has occurred while establishing a connection to the server...No connection could be made because the target machine actively refused it - Database Tutorials\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/12\/11\/an-error-has-occurred-while-establishing-a-connection-to-the-server-no-connection-could-be-made-because-the-target-machine-actively-refused-it\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/12\/11\/an-error-has-occurred-while-establishing-a-connection-to-the-server-no-connection-could-be-made-because-the-target-machine-actively-refused-it\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/12\/226.png\",\"datePublished\":\"2018-12-11T11:52:29+00:00\",\"dateModified\":\"2018-12-21T13:17:13+00:00\",\"description\":\"An error has occurred while establishing a connection to the server. When connecting to SQL Server 20xx, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: TCP Provider, error: 0 - No connection could be made because the target machine actively refused it.) (Microsoft SQL Server, Error: 10061)\",\"breadcrumb\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/12\/11\/an-error-has-occurred-while-establishing-a-connection-to-the-server-no-connection-could-be-made-because-the-target-machine-actively-refused-it\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2018\/12\/11\/an-error-has-occurred-while-establishing-a-connection-to-the-server-no-connection-could-be-made-because-the-target-machine-actively-refused-it\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/12\/11\/an-error-has-occurred-while-establishing-a-connection-to-the-server-no-connection-could-be-made-because-the-target-machine-actively-refused-it\/#primaryimage\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/12\/226.png\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/12\/226.png\",\"width\":1695,\"height\":573},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/12\/11\/an-error-has-occurred-while-establishing-a-connection-to-the-server-no-connection-could-be-made-because-the-target-machine-actively-refused-it\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/dbtut.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"An error has occurred while establishing a connection to the server…No connection could be made because the target machine actively refused it\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/dbtut.com\/#website\",\"url\":\"https:\/\/dbtut.com\/\",\"name\":\"Database Tutorials\",\"description\":\"MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux\",\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/dbtut.com\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/dbtut.com\/#organization\",\"name\":\"dbtut\",\"url\":\"https:\/\/dbtut.com\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg\",\"width\":223,\"height\":36,\"caption\":\"dbtut\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/42a3e874ed0bf8053fa123a3a1f6ee46\",\"name\":\"Ekrem \u00d6nsoy\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/478b3dc5048390d7312367b30eee5be99c346dbd83706e82e0dd4e9678b77c94?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/478b3dc5048390d7312367b30eee5be99c346dbd83706e82e0dd4e9678b77c94?s=96&d=mm&r=g\",\"caption\":\"Ekrem \u00d6nsoy\"},\"description\":\"The original article was written in Turkish by Ekrem \u00d6nsoy and translated to English by dbtut with the consent of the author. The copyright of the article belongs to the author. The author shall not be liable in any way for any defect caused by translation.\",\"url\":\"https:\/\/dbtut.com\/index.php\/author\/ekremonsoy\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"An error has occurred while establishing a connection to the server...No connection could be made because the target machine actively refused it - Database Tutorials","description":"An error has occurred while establishing a connection to the server. When connecting to SQL Server 20xx, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: TCP Provider, error: 0 - No connection could be made because the target machine actively refused it.) (Microsoft SQL Server, Error: 10061)","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/dbtut.com\/index.php\/2018\/12\/11\/an-error-has-occurred-while-establishing-a-connection-to-the-server-no-connection-could-be-made-because-the-target-machine-actively-refused-it\/","og_locale":"en_US","og_type":"article","og_title":"An error has occurred while establishing a connection to the server...No connection could be made because the target machine actively refused it - Database Tutorials","og_description":"An error has occurred while establishing a connection to the server. When connecting to SQL Server 20xx, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: TCP Provider, error: 0 - No connection could be made because the target machine actively refused it.) (Microsoft SQL Server, Error: 10061)","og_url":"https:\/\/dbtut.com\/index.php\/2018\/12\/11\/an-error-has-occurred-while-establishing-a-connection-to-the-server-no-connection-could-be-made-because-the-target-machine-actively-refused-it\/","og_site_name":"Database Tutorials","article_published_time":"2018-12-11T11:52:29+00:00","article_modified_time":"2018-12-21T13:17:13+00:00","og_image":[{"url":"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/12\/226.png","type":"","width":"","height":""}],"author":"Ekrem \u00d6nsoy","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Ekrem \u00d6nsoy","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/dbtut.com\/index.php\/2018\/12\/11\/an-error-has-occurred-while-establishing-a-connection-to-the-server-no-connection-could-be-made-because-the-target-machine-actively-refused-it\/#article","isPartOf":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/12\/11\/an-error-has-occurred-while-establishing-a-connection-to-the-server-no-connection-could-be-made-because-the-target-machine-actively-refused-it\/"},"author":{"name":"Ekrem \u00d6nsoy","@id":"https:\/\/dbtut.com\/#\/schema\/person\/42a3e874ed0bf8053fa123a3a1f6ee46"},"headline":"An error has occurred while establishing a connection to the server…No connection could be made because the target machine actively refused it","datePublished":"2018-12-11T11:52:29+00:00","dateModified":"2018-12-21T13:17:13+00:00","mainEntityOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/12\/11\/an-error-has-occurred-while-establishing-a-connection-to-the-server-no-connection-could-be-made-because-the-target-machine-actively-refused-it\/"},"wordCount":173,"commentCount":0,"publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/12\/11\/an-error-has-occurred-while-establishing-a-connection-to-the-server-no-connection-could-be-made-because-the-target-machine-actively-refused-it\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/12\/226.png","articleSection":["MSSQL"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/dbtut.com\/index.php\/2018\/12\/11\/an-error-has-occurred-while-establishing-a-connection-to-the-server-no-connection-could-be-made-because-the-target-machine-actively-refused-it\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/dbtut.com\/index.php\/2018\/12\/11\/an-error-has-occurred-while-establishing-a-connection-to-the-server-no-connection-could-be-made-because-the-target-machine-actively-refused-it\/","url":"https:\/\/dbtut.com\/index.php\/2018\/12\/11\/an-error-has-occurred-while-establishing-a-connection-to-the-server-no-connection-could-be-made-because-the-target-machine-actively-refused-it\/","name":"An error has occurred while establishing a connection to the server...No connection could be made because the target machine actively refused it - Database Tutorials","isPartOf":{"@id":"https:\/\/dbtut.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/12\/11\/an-error-has-occurred-while-establishing-a-connection-to-the-server-no-connection-could-be-made-because-the-target-machine-actively-refused-it\/#primaryimage"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/12\/11\/an-error-has-occurred-while-establishing-a-connection-to-the-server-no-connection-could-be-made-because-the-target-machine-actively-refused-it\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/12\/226.png","datePublished":"2018-12-11T11:52:29+00:00","dateModified":"2018-12-21T13:17:13+00:00","description":"An error has occurred while establishing a connection to the server. When connecting to SQL Server 20xx, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: TCP Provider, error: 0 - No connection could be made because the target machine actively refused it.) (Microsoft SQL Server, Error: 10061)","breadcrumb":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/12\/11\/an-error-has-occurred-while-establishing-a-connection-to-the-server-no-connection-could-be-made-because-the-target-machine-actively-refused-it\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/dbtut.com\/index.php\/2018\/12\/11\/an-error-has-occurred-while-establishing-a-connection-to-the-server-no-connection-could-be-made-because-the-target-machine-actively-refused-it\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/index.php\/2018\/12\/11\/an-error-has-occurred-while-establishing-a-connection-to-the-server-no-connection-could-be-made-because-the-target-machine-actively-refused-it\/#primaryimage","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/12\/226.png","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/12\/226.png","width":1695,"height":573},{"@type":"BreadcrumbList","@id":"https:\/\/dbtut.com\/index.php\/2018\/12\/11\/an-error-has-occurred-while-establishing-a-connection-to-the-server-no-connection-could-be-made-because-the-target-machine-actively-refused-it\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/dbtut.com\/"},{"@type":"ListItem","position":2,"name":"An error has occurred while establishing a connection to the server…No connection could be made because the target machine actively refused it"}]},{"@type":"WebSite","@id":"https:\/\/dbtut.com\/#website","url":"https:\/\/dbtut.com\/","name":"Database Tutorials","description":"MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux","publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/dbtut.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/dbtut.com\/#organization","name":"dbtut","url":"https:\/\/dbtut.com\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/#\/schema\/logo\/image\/","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg","width":223,"height":36,"caption":"dbtut"},"image":{"@id":"https:\/\/dbtut.com\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/dbtut.com\/#\/schema\/person\/42a3e874ed0bf8053fa123a3a1f6ee46","name":"Ekrem \u00d6nsoy","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/478b3dc5048390d7312367b30eee5be99c346dbd83706e82e0dd4e9678b77c94?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/478b3dc5048390d7312367b30eee5be99c346dbd83706e82e0dd4e9678b77c94?s=96&d=mm&r=g","caption":"Ekrem \u00d6nsoy"},"description":"The original article was written in Turkish by Ekrem \u00d6nsoy and translated to English by dbtut with the consent of the author. The copyright of the article belongs to the author. The author shall not be liable in any way for any defect caused by translation.","url":"https:\/\/dbtut.com\/index.php\/author\/ekremonsoy\/"}]}},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/6484","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/users\/423"}],"replies":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/comments?post=6484"}],"version-history":[{"count":0,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/6484\/revisions"}],"wp:attachment":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media?parent=6484"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/categories?post=6484"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/tags?post=6484"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
![](\"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/12\/226.png\")
<\/p>\n