{"id":9584,"date":"2019-02-17T11:32:58","date_gmt":"2019-02-17T11:32:58","guid":{"rendered":"https:\/\/dbtut.com\/?p=9584"},"modified":"2019-02-17T11:32:58","modified_gmt":"2019-02-17T11:32:58","slug":"server-tcp-provider-failed-to-listen-on-any-1433-tcp-port-is-already-in-use","status":"publish","type":"post","link":"https:\/\/dbtut.com\/index.php\/2019\/02\/17\/server-tcp-provider-failed-to-listen-on-any-1433-tcp-port-is-already-in-use\/","title":{"rendered":"Server TCP provider failed to listen on [ ‘any’ 1433]. Tcp port is already in use."},"content":{"rendered":"

 <\/p>\n

You may receive an error as follows when you want to start SQL Server Service. You need to look at the event viewer.\u00a0 Write “event viewer” on the winows search and run event viewe as Administrator.<\/p>\n

\"\"<\/p>\n

The request failed or the service didnt respond in a timely fashion. Consult the event log or other applicable error logs for details.<\/em><\/span><\/p>\n

\"\"<\/p>\n

When the event viewer is opened, if you see the following error when you click the Application tab from the Windows Log section, this means that you have set the same port for two instances on the same server. You should change the instance port that you want to start.<\/p>\n

You can find out how to set the default ports for SQL Server Instance and other configuration settings in my article “SQL Server Configuration Manager Settings<\/a>“.<\/p>\n

Server TCP provider failed to listen on [ ‘any’ <ipv6> 1433]. Tcp port is already in use.<\/em><\/span><\/p>\n

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

<\/div>\n

<\/path><\/svg><\/i> \"Loading\"<\/p>\n

<\/div>\n","protected":false},"excerpt":{"rendered":"

  You may receive an error as follows when you want to start SQL Server Service. You need to look at the event viewer.\u00a0 Write “event viewer” on the winows search and run event viewe as Administrator. The request failed or the service didnt respond in a timely fashion. Consult the event log or other …<\/p>\n

<\/div>\n

<\/path><\/svg><\/i> \"Loading\"<\/p>\n

<\/div>\n","protected":false},"author":1,"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":[2048,2049,2050],"class_list":["post-9584","post","type-post","status-publish","format-standard","","category-mssql","tag-change-sql-server-port","tag-sql-server-service-is-not-starting","tag-the-request-failed-or-the-service-didnt-respond-in-a-timely-fashion"],"aioseo_notices":[],"yoast_head":"\nServer TCP provider failed to listen on [ 'any' 1433]. Tcp port is already in use. - Database Tutorials<\/title>\n<meta name=\"description\" content=\"Server TCP provider failed to listen on [ 'any' 1433]. Tcp port is already in use.\" \/>\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\/2019\/02\/17\/server-tcp-provider-failed-to-listen-on-any-1433-tcp-port-is-already-in-use\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Server TCP provider failed to listen on [ 'any' 1433]. Tcp port is already in use. - Database Tutorials\" \/>\n<meta property=\"og:description\" content=\"Server TCP provider failed to listen on [ 'any' 1433]. Tcp port is already in use.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/dbtut.com\/index.php\/2019\/02\/17\/server-tcp-provider-failed-to-listen-on-any-1433-tcp-port-is-already-in-use\/\" \/>\n<meta property=\"og:site_name\" content=\"Database Tutorials\" \/>\n<meta property=\"article:published_time\" content=\"2019-02-17T11:32:58+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/02\/img_5c6944bbd48f2.png\" \/>\n<meta name=\"author\" content=\"dbtut\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"dbtut\" \/>\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\/2019\/02\/17\/server-tcp-provider-failed-to-listen-on-any-1433-tcp-port-is-already-in-use\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/02\/17\/server-tcp-provider-failed-to-listen-on-any-1433-tcp-port-is-already-in-use\/\"},\"author\":{\"name\":\"dbtut\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408\"},\"headline\":\"Server TCP provider failed to listen on [ ‘any’ 1433]. Tcp port is already in use.\",\"datePublished\":\"2019-02-17T11:32:58+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/02\/17\/server-tcp-provider-failed-to-listen-on-any-1433-tcp-port-is-already-in-use\/\"},\"wordCount\":170,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/02\/17\/server-tcp-provider-failed-to-listen-on-any-1433-tcp-port-is-already-in-use\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/02\/img_5c6944bbd48f2.png\",\"keywords\":[\"Change SQL Server port\",\"SQL Server service is not starting\",\"The request failed or the service didnt respond in a timely fashion.\"],\"articleSection\":[\"MSSQL\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2019\/02\/17\/server-tcp-provider-failed-to-listen-on-any-1433-tcp-port-is-already-in-use\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/02\/17\/server-tcp-provider-failed-to-listen-on-any-1433-tcp-port-is-already-in-use\/\",\"url\":\"https:\/\/dbtut.com\/index.php\/2019\/02\/17\/server-tcp-provider-failed-to-listen-on-any-1433-tcp-port-is-already-in-use\/\",\"name\":\"Server TCP provider failed to listen on [ 'any' 1433]. Tcp port is already in use. - Database Tutorials\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/02\/17\/server-tcp-provider-failed-to-listen-on-any-1433-tcp-port-is-already-in-use\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/02\/17\/server-tcp-provider-failed-to-listen-on-any-1433-tcp-port-is-already-in-use\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/02\/img_5c6944bbd48f2.png\",\"datePublished\":\"2019-02-17T11:32:58+00:00\",\"description\":\"Server TCP provider failed to listen on [ 'any' 1433]. Tcp port is already in use.\",\"breadcrumb\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/02\/17\/server-tcp-provider-failed-to-listen-on-any-1433-tcp-port-is-already-in-use\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2019\/02\/17\/server-tcp-provider-failed-to-listen-on-any-1433-tcp-port-is-already-in-use\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/02\/17\/server-tcp-provider-failed-to-listen-on-any-1433-tcp-port-is-already-in-use\/#primaryimage\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/02\/img_5c6944bbd48f2.png\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/02\/img_5c6944bbd48f2.png\",\"width\":501,\"height\":550},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/02\/17\/server-tcp-provider-failed-to-listen-on-any-1433-tcp-port-is-already-in-use\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/dbtut.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Server TCP provider failed to listen on [ ‘any’ 1433]. Tcp port is already in use.\"}]},{\"@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\/fc047c39e1e53dce28fc4253529ea408\",\"name\":\"dbtut\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/c322c32021bf651d9e103b183963c479a9c9791ead0715f4348203496c39aa54?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/c322c32021bf651d9e103b183963c479a9c9791ead0715f4348203496c39aa54?s=96&d=mm&r=g\",\"caption\":\"dbtut\"},\"description\":\"We are a team with over 10 years of database management and BI experience. Our Expertises: Oracle, SQL Server, PostgreSQL, MySQL, MongoDB, Elasticsearch, Kibana, Grafana.\",\"sameAs\":[\"http:\/\/NurullahCAKIR\"],\"url\":\"https:\/\/dbtut.com\/index.php\/author\/dbtut\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Server TCP provider failed to listen on [ 'any' 1433]. Tcp port is already in use. - Database Tutorials","description":"Server TCP provider failed to listen on [ 'any' 1433]. Tcp port is already in use.","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\/2019\/02\/17\/server-tcp-provider-failed-to-listen-on-any-1433-tcp-port-is-already-in-use\/","og_locale":"en_US","og_type":"article","og_title":"Server TCP provider failed to listen on [ 'any' 1433]. Tcp port is already in use. - Database Tutorials","og_description":"Server TCP provider failed to listen on [ 'any' 1433]. Tcp port is already in use.","og_url":"https:\/\/dbtut.com\/index.php\/2019\/02\/17\/server-tcp-provider-failed-to-listen-on-any-1433-tcp-port-is-already-in-use\/","og_site_name":"Database Tutorials","article_published_time":"2019-02-17T11:32:58+00:00","og_image":[{"url":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/02\/img_5c6944bbd48f2.png","type":"","width":"","height":""}],"author":"dbtut","twitter_card":"summary_large_image","twitter_misc":{"Written by":"dbtut","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/dbtut.com\/index.php\/2019\/02\/17\/server-tcp-provider-failed-to-listen-on-any-1433-tcp-port-is-already-in-use\/#article","isPartOf":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/02\/17\/server-tcp-provider-failed-to-listen-on-any-1433-tcp-port-is-already-in-use\/"},"author":{"name":"dbtut","@id":"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408"},"headline":"Server TCP provider failed to listen on [ ‘any’ 1433]. Tcp port is already in use.","datePublished":"2019-02-17T11:32:58+00:00","mainEntityOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/02\/17\/server-tcp-provider-failed-to-listen-on-any-1433-tcp-port-is-already-in-use\/"},"wordCount":170,"commentCount":0,"publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/02\/17\/server-tcp-provider-failed-to-listen-on-any-1433-tcp-port-is-already-in-use\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/02\/img_5c6944bbd48f2.png","keywords":["Change SQL Server port","SQL Server service is not starting","The request failed or the service didnt respond in a timely fashion."],"articleSection":["MSSQL"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/dbtut.com\/index.php\/2019\/02\/17\/server-tcp-provider-failed-to-listen-on-any-1433-tcp-port-is-already-in-use\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/dbtut.com\/index.php\/2019\/02\/17\/server-tcp-provider-failed-to-listen-on-any-1433-tcp-port-is-already-in-use\/","url":"https:\/\/dbtut.com\/index.php\/2019\/02\/17\/server-tcp-provider-failed-to-listen-on-any-1433-tcp-port-is-already-in-use\/","name":"Server TCP provider failed to listen on [ 'any' 1433]. Tcp port is already in use. - Database Tutorials","isPartOf":{"@id":"https:\/\/dbtut.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/02\/17\/server-tcp-provider-failed-to-listen-on-any-1433-tcp-port-is-already-in-use\/#primaryimage"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/02\/17\/server-tcp-provider-failed-to-listen-on-any-1433-tcp-port-is-already-in-use\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/02\/img_5c6944bbd48f2.png","datePublished":"2019-02-17T11:32:58+00:00","description":"Server TCP provider failed to listen on [ 'any' 1433]. Tcp port is already in use.","breadcrumb":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/02\/17\/server-tcp-provider-failed-to-listen-on-any-1433-tcp-port-is-already-in-use\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/dbtut.com\/index.php\/2019\/02\/17\/server-tcp-provider-failed-to-listen-on-any-1433-tcp-port-is-already-in-use\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/index.php\/2019\/02\/17\/server-tcp-provider-failed-to-listen-on-any-1433-tcp-port-is-already-in-use\/#primaryimage","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/02\/img_5c6944bbd48f2.png","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/02\/img_5c6944bbd48f2.png","width":501,"height":550},{"@type":"BreadcrumbList","@id":"https:\/\/dbtut.com\/index.php\/2019\/02\/17\/server-tcp-provider-failed-to-listen-on-any-1433-tcp-port-is-already-in-use\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/dbtut.com\/"},{"@type":"ListItem","position":2,"name":"Server TCP provider failed to listen on [ ‘any’ 1433]. Tcp port is already in use."}]},{"@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\/fc047c39e1e53dce28fc4253529ea408","name":"dbtut","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/c322c32021bf651d9e103b183963c479a9c9791ead0715f4348203496c39aa54?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/c322c32021bf651d9e103b183963c479a9c9791ead0715f4348203496c39aa54?s=96&d=mm&r=g","caption":"dbtut"},"description":"We are a team with over 10 years of database management and BI experience. Our Expertises: Oracle, SQL Server, PostgreSQL, MySQL, MongoDB, Elasticsearch, Kibana, Grafana.","sameAs":["http:\/\/NurullahCAKIR"],"url":"https:\/\/dbtut.com\/index.php\/author\/dbtut\/"}]}},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/9584","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\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/comments?post=9584"}],"version-history":[{"count":0,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/9584\/revisions"}],"wp:attachment":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media?parent=9584"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/categories?post=9584"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/tags?post=9584"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}