{"id":293,"date":"2024-04-10T11:02:49","date_gmt":"2024-04-10T11:02:49","guid":{"rendered":"https:\/\/249host.com\/tutorials\/?p=293"},"modified":"2024-04-10T11:03:54","modified_gmt":"2024-04-10T11:03:54","slug":"enabling-tcp-ip-in-the-sql-server","status":"publish","type":"post","link":"https:\/\/249host.com\/tutorials\/enabling-tcp-ip-in-the-sql-server\/","title":{"rendered":"Troubleshooting: Enabling TCP\/IP in the SQL Server"},"content":{"rendered":"\r\n<p>Enabling TCP\/IP in the SQL Server<\/p>\r\n\r\n\r\n\r\n<p>Enabling TCP\/IP in SQL Server allows clients to connect to the SQL Server instance using the TCP\/IP network protocol. This is a common requirement when connecting to SQL Server from remote locations or when using applications that rely on TCP\/IP connections.<\/p>\r\n\r\n\r\n\r\n<p>Windows server with plesk control panel users will face this issue, when they try to view data base server in plesk control panel the error will appear. And also client side SSSM unable to connect MSSQL server.<\/p>\r\n\r\n\r\n\r\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-298\" src=\"https:\/\/249host.com\/tutorials\/wp-content\/uploads\/2024\/04\/plesk-error-1024x326.png\" alt=\"Enabling TCP\/IP in the SQL Server\" width=\"1024\" height=\"326\" srcset=\"https:\/\/249host.com\/tutorials\/wp-content\/uploads\/2024\/04\/plesk-error-1024x326.png 1024w, https:\/\/249host.com\/tutorials\/wp-content\/uploads\/2024\/04\/plesk-error-300x95.png 300w, https:\/\/249host.com\/tutorials\/wp-content\/uploads\/2024\/04\/plesk-error-768x244.png 768w, https:\/\/249host.com\/tutorials\/wp-content\/uploads\/2024\/04\/plesk-error-1536x489.png 1536w, https:\/\/249host.com\/tutorials\/wp-content\/uploads\/2024\/04\/plesk-error.png 1907w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\r\n\r\n\r\n\r\n<h2 class=\"wp-block-heading\">Enabling TCP\/IP in the SQL Server<\/h2>\r\n\r\n\r\n\r\n<p>Here&#8217;s how you can enable TCP\/IP in SQL Server:<\/p>\r\n\r\n\r\n\r\n<p>1.Connect to the Plesk server via RDP.<\/p>\r\n\r\n\r\n\r\n<p class=\"wp-block-code\">2.Go to Start &gt; All Programs &gt; Microsoft SQL Server XXXX &gt; SQL Server XXXX Configuration Manager. Note: XXXX is a version of MS SQL Server from the error message.<\/p>\r\n<p class=\"wp-block-code\">3.Expand SQL Server Network Configuration and click Protocols for MSSQLSERVERXXXX.<\/p>\r\n<p class=\"wp-block-code\">4.Double-click on TCP\/IP:<\/p>\r\n<p class=\"wp-block-code\">4.1. On the Protocol tab, make sure that the TCP\/IP protocol is Enabled.<\/p>\r\n<p class=\"wp-block-code\">4.2. Switch to the IP Addresses tab and scroll down to the IPAll section. 4.3. Specify default MS SQL port number 1433 (or a custom port number if 1433 is already used by another MS SQL Server instance) in the TCP Port field<\/p>\r\n<p>&nbsp;<\/p>\r\n\r\n\r\n\r\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"542\" class=\"wp-image-294\" src=\"https:\/\/249host.com\/tutorials\/wp-content\/uploads\/2024\/04\/tcp-port-1433-1024x542.png\" alt=\"\" srcset=\"https:\/\/249host.com\/tutorials\/wp-content\/uploads\/2024\/04\/tcp-port-1433-1024x542.png 1024w, https:\/\/249host.com\/tutorials\/wp-content\/uploads\/2024\/04\/tcp-port-1433-300x159.png 300w, https:\/\/249host.com\/tutorials\/wp-content\/uploads\/2024\/04\/tcp-port-1433-768x407.png 768w, https:\/\/249host.com\/tutorials\/wp-content\/uploads\/2024\/04\/tcp-port-1433-1536x813.png 1536w, https:\/\/249host.com\/tutorials\/wp-content\/uploads\/2024\/04\/tcp-port-1433-720x380.png 720w, https:\/\/249host.com\/tutorials\/wp-content\/uploads\/2024\/04\/tcp-port-1433.png 1915w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\r\n\r\n\r\n\r\n<p>&nbsp;<\/p>\r\n\r\n\r\n\r\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-295\" src=\"https:\/\/249host.com\/tutorials\/wp-content\/uploads\/2024\/04\/2.png\" alt=\"Enabling TCP\/IP in the SQL Server\" width=\"412\" height=\"473\" srcset=\"https:\/\/249host.com\/tutorials\/wp-content\/uploads\/2024\/04\/2.png 412w, https:\/\/249host.com\/tutorials\/wp-content\/uploads\/2024\/04\/2-261x300.png 261w\" sizes=\"auto, (max-width: 412px) 100vw, 412px\" \/><\/figure>\r\n\r\n\r\n\r\n<p>Go to <strong>SQL Server Configuration Manager (Local)<\/strong> &gt; <strong>SQL Server Services<\/strong>,<\/p>\r\n\r\n\r\n\r\n<p>Right-click on <strong>SQL Server (MSSQLSERVERXXXX)<\/strong> and click <strong>Restart<\/strong> to apply the changes.<\/p>\r\n\r\n\r\n\r\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-296\" src=\"https:\/\/249host.com\/tutorials\/wp-content\/uploads\/2024\/04\/TCP14331-1024x559.png\" alt=\"Enabling TCP\/IP in the SQL Server\" width=\"1024\" height=\"559\" srcset=\"https:\/\/249host.com\/tutorials\/wp-content\/uploads\/2024\/04\/TCP14331-1024x559.png 1024w, https:\/\/249host.com\/tutorials\/wp-content\/uploads\/2024\/04\/TCP14331-300x164.png 300w, https:\/\/249host.com\/tutorials\/wp-content\/uploads\/2024\/04\/TCP14331-768x420.png 768w, https:\/\/249host.com\/tutorials\/wp-content\/uploads\/2024\/04\/TCP14331-1536x839.png 1536w, https:\/\/249host.com\/tutorials\/wp-content\/uploads\/2024\/04\/TCP14331.png 1898w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\r\n\r\n\r\n\r\n<p>Log in to <a href=\"https:\/\/www.plesk.com\" target=\"_blank\" rel=\"noopener\">Plesk.<\/a><\/p>\r\n\r\n\r\n\r\n<p>Go to <strong>Tools &amp; Settings<\/strong> &gt; <strong>Database Servers<\/strong> &gt; .<strong>MSSQLSERVERXXXX<\/strong> &gt; <strong>Settings<\/strong> and click <strong>OK<\/strong> to sync new settings with Plesk.<\/p>\r\n\r\n\r\n\r\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"484\" class=\"wp-image-300\" src=\"https:\/\/249host.com\/tutorials\/wp-content\/uploads\/2024\/04\/plesk-error-disappear-1024x484.png\" alt=\"\" srcset=\"https:\/\/249host.com\/tutorials\/wp-content\/uploads\/2024\/04\/plesk-error-disappear-1024x484.png 1024w, https:\/\/249host.com\/tutorials\/wp-content\/uploads\/2024\/04\/plesk-error-disappear-300x142.png 300w, https:\/\/249host.com\/tutorials\/wp-content\/uploads\/2024\/04\/plesk-error-disappear-768x363.png 768w, https:\/\/249host.com\/tutorials\/wp-content\/uploads\/2024\/04\/plesk-error-disappear-1536x727.png 1536w, https:\/\/249host.com\/tutorials\/wp-content\/uploads\/2024\/04\/plesk-error-disappear.png 1907w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\r\n\r\n\r\n\r\n<p>After sycn the <a href=\"https:\/\/www.249host.com\/\">server<\/a> , the error will disappear and able to access using client SSSM.<\/p>\r\n\r\n\r\n\r\n<p>&nbsp;<\/p>\r\n","protected":false},"excerpt":{"rendered":"<p>Enabling TCP\/IP in the SQL Server Enabling TCP\/IP in SQL Server allows clients to connect to the SQL Server instance using the TCP\/IP network protocol. This is a common requirement when connecting to SQL Server from remote locations or when using applications that rely on TCP\/IP connections. Windows server with plesk control panel users will [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[5,46],"tags":[48,37,47],"class_list":["post-293","post","type-post","status-publish","format-standard","hentry","category-control-panel","category-plesk","tag-network-configuration-manager","tag-port","tag-tcp"],"_links":{"self":[{"href":"https:\/\/249host.com\/tutorials\/wp-json\/wp\/v2\/posts\/293","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/249host.com\/tutorials\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/249host.com\/tutorials\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/249host.com\/tutorials\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/249host.com\/tutorials\/wp-json\/wp\/v2\/comments?post=293"}],"version-history":[{"count":9,"href":"https:\/\/249host.com\/tutorials\/wp-json\/wp\/v2\/posts\/293\/revisions"}],"predecessor-version":[{"id":309,"href":"https:\/\/249host.com\/tutorials\/wp-json\/wp\/v2\/posts\/293\/revisions\/309"}],"wp:attachment":[{"href":"https:\/\/249host.com\/tutorials\/wp-json\/wp\/v2\/media?parent=293"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/249host.com\/tutorials\/wp-json\/wp\/v2\/categories?post=293"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/249host.com\/tutorials\/wp-json\/wp\/v2\/tags?post=293"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}