{"id":6114,"date":"2021-02-11T17:35:38","date_gmt":"2021-02-11T12:05:38","guid":{"rendered":"https:\/\/www.skynats.com\/?p=6114"},"modified":"2025-10-28T11:15:55","modified_gmt":"2025-10-28T05:45:55","slug":"enabling-remote-connection-to-mssql-server-on-plesk-server","status":"publish","type":"post","link":"https:\/\/www.skynats.com\/blog\/enabling-remote-connection-to-mssql-server-on-plesk-server\/","title":{"rendered":"Enabling remote connection to MSSQL server on Plesk server"},"content":{"rendered":"\n<p><strong>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <\/strong><\/p>\n\n\n\n<p>Usually, firewalls block all external remotes that are connected by default for security purposes. For instance, it requires a remote connection, for that you need to enable remote access by adding the IP address or subnet in the allowed list. Let&#8217;s peek at the blog to enable Plesk MSSQL remote connection and fix the error.<\/p>\n\n\n\n<p>We have come up with several Plesk-related queries as part of our <a href=\"https:\/\/www.skynats.com\/plesk-server-management\/ \">server management<\/a> plan. We would be delighted to assist you with any server issues with 24\/7 technical support in case you face any difficulties.<\/p>\n\n\n\n<p>The MSSQL remote connection is disabled by default.<\/p>\n\n\n\n<h2 class=\"wp-block-heading has-normal-font-size\" id=\"h-enabling-the-mssql-database-remote-connection-in-the-plesk\"><strong>Enabling the MSSQL database remote connection in the Plesk.<\/strong><\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li>First, log into the <a href=\"https:\/\/www.plesk.com\/\">Plesk<\/a> control panel then create the database to access it remotely.<\/li>\n\n\n\n<li>Click on the Database tab from left side and then click on the<strong>&nbsp;Add Database.<\/strong><\/li>\n\n\n\n<li>Then enter the&nbsp;<strong>Database name<\/strong>.<\/li>\n\n\n\n<li>After that click and select the Database server type &#8220;MSSQL&#8221; from the drop-down list.<\/li>\n\n\n\n<li>Check whether the create database user is ticked.<\/li>\n\n\n\n<li>Enter a Database user name.<\/li>\n\n\n\n<li>Enter and ensure the password.<\/li>\n\n\n\n<li>On the Remote access, click and choose the Allow remote connection from the option.<\/li>\n\n\n\n<li>Then enter the IP addresses or subnets that need to access the remote database access, at last click&nbsp;<strong>ok&nbsp;<\/strong>button.<\/li>\n<\/ul>\n\n\n\n<p>Recently, one of our clients faced a problem while connecting to the SQL remotely that is due to a remote network connection being disabled for the IP address. Our technical team has resolved the problem by enabling the remote connection for the corresponding IP address through the SQL server configuration.<\/p>\n\n\n\n<h2 class=\"wp-block-heading has-normal-font-size\" id=\"h-conclusion-nbsp\"><strong>Conclusion&nbsp;<\/strong><\/h2>\n\n\n\n<p>By this, I conclude that by following the instructions you can enable and fix the error. you can also take our technical team support for any assistance to resolve the error and fix it for them on behalf of you.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Usually, firewalls block all external remotes that are connected by default for security purposes. For instance, it requires a remote connection, for that you need to enable remote access by adding the IP address or subnet in the allowed list. Let&#8217;s peek at the blog to enable Plesk MSSQL remote connection and fix the [&hellip;]<\/p>\n","protected":false},"author":4,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[5,250,188,68],"tags":[25,251,193,72],"class_list":["post-6114","post","type-post","status-publish","format-standard","hentry","category-blog","category-mssql-server","category-plesk-server","category-server-management","tag-cloud-management","tag-mssql-server","tag-plesk-server-management","tag-server-management"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v25.9 (Yoast SEO v27.6) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>Plesk MSSQL Remote Connection: Enable Access to Your Server<\/title>\n<meta name=\"description\" content=\"Learn how to enable Plesk MSSQL remote connection on your Plesk server, allowing seamless access and management from remote locations.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.skynats.com\/blog\/enabling-remote-connection-to-mssql-server-on-plesk-server\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Enabling remote connection to MSSQL server on Plesk server\" \/>\n<meta property=\"og:description\" content=\"Learn how to enable Plesk MSSQL remote connection on your Plesk server, allowing seamless access and management from remote locations.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.skynats.com\/blog\/enabling-remote-connection-to-mssql-server-on-plesk-server\/\" \/>\n<meta property=\"og:site_name\" content=\"Server Management Services | Cloud Management | Skynats\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/skynats\" \/>\n<meta property=\"article:published_time\" content=\"2021-02-11T12:05:38+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-10-28T05:45:55+00:00\" \/>\n<meta name=\"author\" content=\"Pooja V\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@skynatstech\" \/>\n<meta name=\"twitter:site\" content=\"@skynatstech\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Pooja V\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.skynats.com\\\/blog\\\/enabling-remote-connection-to-mssql-server-on-plesk-server\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.skynats.com\\\/blog\\\/enabling-remote-connection-to-mssql-server-on-plesk-server\\\/\"},\"author\":{\"name\":\"Pooja V\",\"@id\":\"https:\\\/\\\/www.skynats.com\\\/blog\\\/#\\\/schema\\\/person\\\/030d5856dd5166055eecc07218d2455e\"},\"headline\":\"Enabling remote connection to MSSQL server on Plesk server\",\"datePublished\":\"2021-02-11T12:05:38+00:00\",\"dateModified\":\"2025-10-28T05:45:55+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.skynats.com\\\/blog\\\/enabling-remote-connection-to-mssql-server-on-plesk-server\\\/\"},\"wordCount\":323,\"publisher\":{\"@id\":\"https:\\\/\\\/www.skynats.com\\\/blog\\\/#organization\"},\"keywords\":[\"cloud management\",\"MSSQL server\",\"Plesk server management\",\"server management\"],\"articleSection\":[\"Blog\",\"MSSQL server\",\"Plesk server\",\"server management\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.skynats.com\\\/blog\\\/enabling-remote-connection-to-mssql-server-on-plesk-server\\\/\",\"url\":\"https:\\\/\\\/www.skynats.com\\\/blog\\\/enabling-remote-connection-to-mssql-server-on-plesk-server\\\/\",\"name\":\"Plesk MSSQL Remote Connection: Enable Access to Your Server\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.skynats.com\\\/blog\\\/#website\"},\"datePublished\":\"2021-02-11T12:05:38+00:00\",\"dateModified\":\"2025-10-28T05:45:55+00:00\",\"description\":\"Learn how to enable Plesk MSSQL remote connection on your Plesk server, allowing seamless access and management from remote locations.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.skynats.com\\\/blog\\\/enabling-remote-connection-to-mssql-server-on-plesk-server\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.skynats.com\\\/blog\\\/enabling-remote-connection-to-mssql-server-on-plesk-server\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.skynats.com\\\/blog\\\/enabling-remote-connection-to-mssql-server-on-plesk-server\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.skynats.com\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Enabling remote connection to MSSQL server on Plesk server\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.skynats.com\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/www.skynats.com\\\/blog\\\/\",\"name\":\"Server Management Services | Cloud Management | Skynats\",\"description\":\"Server Management and Cloud Management\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.skynats.com\\\/blog\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.skynats.com\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/www.skynats.com\\\/blog\\\/#organization\",\"name\":\"Skynats Technologies\",\"url\":\"https:\\\/\\\/www.skynats.com\\\/blog\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.skynats.com\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/www.skynats.com\\\/blog\\\/wp-content\\\/uploads\\\/2021\\\/08\\\/Sknats-Logo-New-whole.png\",\"contentUrl\":\"https:\\\/\\\/www.skynats.com\\\/blog\\\/wp-content\\\/uploads\\\/2021\\\/08\\\/Sknats-Logo-New-whole.png\",\"width\":989,\"height\":367,\"caption\":\"Skynats Technologies\"},\"image\":{\"@id\":\"https:\\\/\\\/www.skynats.com\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/www.facebook.com\\\/skynats\",\"https:\\\/\\\/x.com\\\/skynatstech\",\"https:\\\/\\\/www.instagram.com\\\/skynatstech\\\/\",\"https:\\\/\\\/www.linkedin.com\\\/company\\\/skynats-technologies\",\"https:\\\/\\\/www.youtube.com\\\/channel\\\/UCvTAjrFJ4_E2MJKwlDHomlg\"]},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.skynats.com\\\/blog\\\/#\\\/schema\\\/person\\\/030d5856dd5166055eecc07218d2455e\",\"name\":\"Pooja V\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/acf2642637f84bdab7ffece47787a6a4ee655dab6404beac2a1a33db563041c4?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/acf2642637f84bdab7ffece47787a6a4ee655dab6404beac2a1a33db563041c4?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/acf2642637f84bdab7ffece47787a6a4ee655dab6404beac2a1a33db563041c4?s=96&d=mm&r=g\",\"caption\":\"Pooja V\"}}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Plesk MSSQL Remote Connection: Enable Access to Your Server","description":"Learn how to enable Plesk MSSQL remote connection on your Plesk server, allowing seamless access and management from remote locations.","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:\/\/www.skynats.com\/blog\/enabling-remote-connection-to-mssql-server-on-plesk-server\/","og_locale":"en_US","og_type":"article","og_title":"Enabling remote connection to MSSQL server on Plesk server","og_description":"Learn how to enable Plesk MSSQL remote connection on your Plesk server, allowing seamless access and management from remote locations.","og_url":"https:\/\/www.skynats.com\/blog\/enabling-remote-connection-to-mssql-server-on-plesk-server\/","og_site_name":"Server Management Services | Cloud Management | Skynats","article_publisher":"https:\/\/www.facebook.com\/skynats","article_published_time":"2021-02-11T12:05:38+00:00","article_modified_time":"2025-10-28T05:45:55+00:00","author":"Pooja V","twitter_card":"summary_large_image","twitter_creator":"@skynatstech","twitter_site":"@skynatstech","twitter_misc":{"Written by":"Pooja V","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.skynats.com\/blog\/enabling-remote-connection-to-mssql-server-on-plesk-server\/#article","isPartOf":{"@id":"https:\/\/www.skynats.com\/blog\/enabling-remote-connection-to-mssql-server-on-plesk-server\/"},"author":{"name":"Pooja V","@id":"https:\/\/www.skynats.com\/blog\/#\/schema\/person\/030d5856dd5166055eecc07218d2455e"},"headline":"Enabling remote connection to MSSQL server on Plesk server","datePublished":"2021-02-11T12:05:38+00:00","dateModified":"2025-10-28T05:45:55+00:00","mainEntityOfPage":{"@id":"https:\/\/www.skynats.com\/blog\/enabling-remote-connection-to-mssql-server-on-plesk-server\/"},"wordCount":323,"publisher":{"@id":"https:\/\/www.skynats.com\/blog\/#organization"},"keywords":["cloud management","MSSQL server","Plesk server management","server management"],"articleSection":["Blog","MSSQL server","Plesk server","server management"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.skynats.com\/blog\/enabling-remote-connection-to-mssql-server-on-plesk-server\/","url":"https:\/\/www.skynats.com\/blog\/enabling-remote-connection-to-mssql-server-on-plesk-server\/","name":"Plesk MSSQL Remote Connection: Enable Access to Your Server","isPartOf":{"@id":"https:\/\/www.skynats.com\/blog\/#website"},"datePublished":"2021-02-11T12:05:38+00:00","dateModified":"2025-10-28T05:45:55+00:00","description":"Learn how to enable Plesk MSSQL remote connection on your Plesk server, allowing seamless access and management from remote locations.","breadcrumb":{"@id":"https:\/\/www.skynats.com\/blog\/enabling-remote-connection-to-mssql-server-on-plesk-server\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.skynats.com\/blog\/enabling-remote-connection-to-mssql-server-on-plesk-server\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.skynats.com\/blog\/enabling-remote-connection-to-mssql-server-on-plesk-server\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.skynats.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Enabling remote connection to MSSQL server on Plesk server"}]},{"@type":"WebSite","@id":"https:\/\/www.skynats.com\/blog\/#website","url":"https:\/\/www.skynats.com\/blog\/","name":"Server Management Services | Cloud Management | Skynats","description":"Server Management and Cloud Management","publisher":{"@id":"https:\/\/www.skynats.com\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.skynats.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.skynats.com\/blog\/#organization","name":"Skynats Technologies","url":"https:\/\/www.skynats.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.skynats.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.skynats.com\/blog\/wp-content\/uploads\/2021\/08\/Sknats-Logo-New-whole.png","contentUrl":"https:\/\/www.skynats.com\/blog\/wp-content\/uploads\/2021\/08\/Sknats-Logo-New-whole.png","width":989,"height":367,"caption":"Skynats Technologies"},"image":{"@id":"https:\/\/www.skynats.com\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/skynats","https:\/\/x.com\/skynatstech","https:\/\/www.instagram.com\/skynatstech\/","https:\/\/www.linkedin.com\/company\/skynats-technologies","https:\/\/www.youtube.com\/channel\/UCvTAjrFJ4_E2MJKwlDHomlg"]},{"@type":"Person","@id":"https:\/\/www.skynats.com\/blog\/#\/schema\/person\/030d5856dd5166055eecc07218d2455e","name":"Pooja V","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/acf2642637f84bdab7ffece47787a6a4ee655dab6404beac2a1a33db563041c4?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/acf2642637f84bdab7ffece47787a6a4ee655dab6404beac2a1a33db563041c4?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/acf2642637f84bdab7ffece47787a6a4ee655dab6404beac2a1a33db563041c4?s=96&d=mm&r=g","caption":"Pooja V"}}]}},"_links":{"self":[{"href":"https:\/\/www.skynats.com\/blog\/wp-json\/wp\/v2\/posts\/6114","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.skynats.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.skynats.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.skynats.com\/blog\/wp-json\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/www.skynats.com\/blog\/wp-json\/wp\/v2\/comments?post=6114"}],"version-history":[{"count":1,"href":"https:\/\/www.skynats.com\/blog\/wp-json\/wp\/v2\/posts\/6114\/revisions"}],"predecessor-version":[{"id":16380,"href":"https:\/\/www.skynats.com\/blog\/wp-json\/wp\/v2\/posts\/6114\/revisions\/16380"}],"wp:attachment":[{"href":"https:\/\/www.skynats.com\/blog\/wp-json\/wp\/v2\/media?parent=6114"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.skynats.com\/blog\/wp-json\/wp\/v2\/categories?post=6114"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.skynats.com\/blog\/wp-json\/wp\/v2\/tags?post=6114"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}