{"id":6286,"date":"2021-03-24T13:01:40","date_gmt":"2021-03-24T07:31:40","guid":{"rendered":"https:\/\/www.skynats.com\/?p=6286"},"modified":"2024-12-11T17:46:01","modified_gmt":"2024-12-11T12:16:01","slug":"enable-the-mssql-database-in-plesk","status":"publish","type":"post","link":"https:\/\/www.skynats.com\/blog\/enable-the-mssql-database-in-plesk\/","title":{"rendered":"How to enable the MS SQL database in Plesk?"},"content":{"rendered":"\n<p>In MSSQL where the database is limited for the webspace, subscriptions.<\/p>\n\n\n\n<p>Here you come across with error and unable the MSSQL database in Plesk.<\/p>\n\n\n\n<p>Get assistance to resolve the error and to enable the MSSQL database in Plesk. As a part of our <a href=\"https:\/\/www.skynats.com\/linux-server-management\/\" target=\"_blank\" rel=\"noreferrer noopener\"><span style=\"color:#0273a4\" class=\"has-inline-color\">server management services<\/span><\/a> were glad to assist our client with queries and issues.<\/p>\n\n\n\n<p>Let&#8217;s have a glance at the issue and get it resolved.<\/p>\n\n\n\n<p>Enabling an MS SQL database to the Plesk<\/p>\n\n\n\n<p>Follow the steps to enable an MS SQL database to the Plesk panel.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>First, you need to log into Plesk Control Panel.<\/li>\n\n\n\n<li>a) In Plesk 12 choose the\u00a0Subscriptions\u00a0tab, click the<strong>\u00a0[domain]\u00a0<\/strong>and select the required one, then move towards the\u00a0<strong>Websites &amp; Domains<\/strong>\u00a0tab and select.<\/li>\n\n\n\n<li>Whereas in Plesk 11, choose the\u00a0<strong>My Subscriptions<\/strong>\u00a0section and select the<strong>\u00a0[domain]<\/strong>. Click on the\u00a0<strong>Websites &amp; Domains<\/strong>\u00a0tab.<\/li>\n\n\n\n<li>In Plesk 9, click on\u00a0<strong>Domains<\/strong>, then click on the<strong>\u00a0[domain]<\/strong>\u00a0needing a new database.<\/li>\n\n\n\n<li>Click on\u00a0<strong>Databases\u00a0<\/strong>and select the\u00a0<strong>Add New Database<\/strong>.<\/li>\n\n\n\n<li>Enter a name to use which is next to Database Name.\u00a0<\/li>\n\n\n\n<li>For Type, choose\u00a0<strong>Microsoft SQL Server<\/strong>\u00a0(DNN uses the Microsoft SQL Server)<\/li>\n\n\n\n<li>You can also create the user for Plesk 12 at this point.<\/li>\n\n\n\n<li>We may ignore the Restore Database from the backup file checkbox.<\/li>\n\n\n\n<li>Finally, click\u00a0<strong>OK<\/strong>.<\/li>\n<\/ul>\n\n\n\n<p>That this point we may not be able to select the MSSQL database under the subscription where it displays only MySQL database is available.<\/p>\n\n\n\n<p>Resolving the error<\/p>\n\n\n\n<p>Web Admin Edition:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Log in to\u00a0<strong>Plesk<\/strong>.<\/li>\n\n\n\n<li>Go to\u00a0<strong>Tools &amp; Settings > License Management<\/strong>\u00a0and check if Microsoft SQL Server support is enabled or not:<\/li>\n\n\n\n<li>If it is not available you need to purchase the MSSQL for the subscription.<\/li>\n\n\n\n<li>\u00a0The Power Pack and Developer Pack is included in MSSQL support.<\/li>\n\n\n\n<li>To get the current limit of MSSQL databases for the required webspace, Run the command.<\/li>\n<\/ul>\n\n\n\n<pre class=\"wp-block-code\"><code>C:\\&gt; plesk bin subscription_settings \u2013info example.com | findstr max_mssql_db\nmax_mssql_db 30 MS SQL databases<\/code><\/pre>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Later, as per the required webspace, you can increase the MSSQL databases.<\/li>\n<\/ul>\n\n\n\n<pre class=\"wp-block-code\"><code>C:\\&gt; plesk bin subscription_settings -u example.com -max_mssql_db 100\n\nplesk bin subscription_settings -u example.com -max_mssql_db -1<\/code><\/pre>\n\n\n\n<p>Web Pro and Web Host Editions:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Log in to\u00a0<strong>Plesk<\/strong>.<\/li>\n\n\n\n<li>Click\u00a0<strong>Subscriptions > example.com > Account > Resources<\/strong>.<\/li>\n\n\n\n<li>Find the MS SQL database number.<\/li>\n\n\n\n<li>You can increase the data limit by following the way.<\/li>\n\n\n\n<li>1.Click<strong>\u00a0Subscriptions > example.com > Customize > Resources<\/strong>\u00a0page and increase the MS SQL databases limit<\/li>\n\n\n\n<li>2. Choose and click\u00a0\u00a0<strong>Subscriptions > example.com > Service Plan: Default > Resources<\/strong>\u00a0page and increase the MS SQL databases limit.<\/li>\n\n\n\n<li>If it did not reach the limit, choose\u00a0<strong>Subscriptions > example.com > Subscriber> Provider.<\/strong><\/li>\n\n\n\n<li>Click the\u00a0<strong>Change Plan<\/strong>\u00a0button to increase the MS SQL databases.<\/li>\n\n\n\n<li>Click the\u00a0<strong>Customize<\/strong>\u00a0button to increase the MS SQL databases number only for this reseller.<\/li>\n\n\n\n<li>Find and choose the\u00a0<strong>MS SQL databases number<\/strong>\u00a0and increase it to the required value.<\/li>\n<\/ul>\n\n\n\n<p><strong>Conclusion<\/strong><\/p>\n\n\n\n<p>From this blog, you will get an apparent view on how to enable the database is limited for the webspace, subscriptions. For any queries, you can contact our <a href=\"https:\/\/www.skynats.com\/contact-us\/\" target=\"_blank\" rel=\"noreferrer noopener\"><span style=\"color:#026c9a\" class=\"has-inline-color\">technical team support<\/span><\/a> for any assistance.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>In MSSQL where the database is limited for the webspace, subscriptions. Here you come across with error and unable the MSSQL database in Plesk. Get assistance to resolve the error and to enable the MSSQL database in Plesk. As a part of our server management services were glad to assist our client with queries and [&hellip;]<\/p>\n","protected":false},"author":7,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[5,250,257,188,68],"tags":[522],"class_list":["post-6286","post","type-post","status-publish","format-standard","hentry","category-blog","category-mssql-server","category-mysql","category-plesk-server","category-server-management","tag-add-mssql-database-in-plesk"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v25.9 (Yoast SEO v27.5) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>How to enable the MSSQL database in Plesk<\/title>\n<meta name=\"description\" content=\"First, you need to log into Plesk Control Panel. In Plesk 12 choose the Subscriptions tab, click the [domain] and select the required one,\" \/>\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\/enable-the-mssql-database-in-plesk\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to enable the MS SQL database in Plesk?\" \/>\n<meta property=\"og:description\" content=\"First, you need to log into Plesk Control Panel. In Plesk 12 choose the Subscriptions tab, click the [domain] and select the required one,\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.skynats.com\/blog\/enable-the-mssql-database-in-plesk\/\" \/>\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-03-24T07:31:40+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-12-11T12:16:01+00:00\" \/>\n<meta name=\"author\" content=\"Nabeela\" \/>\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=\"Nabeela\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.skynats.com\\\/blog\\\/enable-the-mssql-database-in-plesk\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.skynats.com\\\/blog\\\/enable-the-mssql-database-in-plesk\\\/\"},\"author\":{\"name\":\"Nabeela\",\"@id\":\"https:\\\/\\\/www.skynats.com\\\/blog\\\/#\\\/schema\\\/person\\\/2968118a72bea0868796abf1237ab3e0\"},\"headline\":\"How to enable the MS SQL database in Plesk?\",\"datePublished\":\"2021-03-24T07:31:40+00:00\",\"dateModified\":\"2024-12-11T12:16:01+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.skynats.com\\\/blog\\\/enable-the-mssql-database-in-plesk\\\/\"},\"wordCount\":479,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/www.skynats.com\\\/blog\\\/#organization\"},\"keywords\":[\"add mssql database in plesk\"],\"articleSection\":[\"Blog\",\"MSSQL server\",\"MySQL\",\"Plesk server\",\"server management\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.skynats.com\\\/blog\\\/enable-the-mssql-database-in-plesk\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.skynats.com\\\/blog\\\/enable-the-mssql-database-in-plesk\\\/\",\"url\":\"https:\\\/\\\/www.skynats.com\\\/blog\\\/enable-the-mssql-database-in-plesk\\\/\",\"name\":\"How to enable the MSSQL database in Plesk\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.skynats.com\\\/blog\\\/#website\"},\"datePublished\":\"2021-03-24T07:31:40+00:00\",\"dateModified\":\"2024-12-11T12:16:01+00:00\",\"description\":\"First, you need to log into Plesk Control Panel. In Plesk 12 choose the Subscriptions tab, click the [domain] and select the required one,\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.skynats.com\\\/blog\\\/enable-the-mssql-database-in-plesk\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.skynats.com\\\/blog\\\/enable-the-mssql-database-in-plesk\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.skynats.com\\\/blog\\\/enable-the-mssql-database-in-plesk\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.skynats.com\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to enable the MS SQL database in Plesk?\"}]},{\"@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\\\/2968118a72bea0868796abf1237ab3e0\",\"name\":\"Nabeela\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/12a999d0e3cd16cf2383c5551b39d00d6ddc2d035a2581ce5d85fce0762d0372?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/12a999d0e3cd16cf2383c5551b39d00d6ddc2d035a2581ce5d85fce0762d0372?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/12a999d0e3cd16cf2383c5551b39d00d6ddc2d035a2581ce5d85fce0762d0372?s=96&d=mm&r=g\",\"caption\":\"Nabeela\"}}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"How to enable the MSSQL database in Plesk","description":"First, you need to log into Plesk Control Panel. In Plesk 12 choose the Subscriptions tab, click the [domain] and select the required one,","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\/enable-the-mssql-database-in-plesk\/","og_locale":"en_US","og_type":"article","og_title":"How to enable the MS SQL database in Plesk?","og_description":"First, you need to log into Plesk Control Panel. In Plesk 12 choose the Subscriptions tab, click the [domain] and select the required one,","og_url":"https:\/\/www.skynats.com\/blog\/enable-the-mssql-database-in-plesk\/","og_site_name":"Server Management Services | Cloud Management | Skynats","article_publisher":"https:\/\/www.facebook.com\/skynats","article_published_time":"2021-03-24T07:31:40+00:00","article_modified_time":"2024-12-11T12:16:01+00:00","author":"Nabeela","twitter_card":"summary_large_image","twitter_creator":"@skynatstech","twitter_site":"@skynatstech","twitter_misc":{"Written by":"Nabeela","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.skynats.com\/blog\/enable-the-mssql-database-in-plesk\/#article","isPartOf":{"@id":"https:\/\/www.skynats.com\/blog\/enable-the-mssql-database-in-plesk\/"},"author":{"name":"Nabeela","@id":"https:\/\/www.skynats.com\/blog\/#\/schema\/person\/2968118a72bea0868796abf1237ab3e0"},"headline":"How to enable the MS SQL database in Plesk?","datePublished":"2021-03-24T07:31:40+00:00","dateModified":"2024-12-11T12:16:01+00:00","mainEntityOfPage":{"@id":"https:\/\/www.skynats.com\/blog\/enable-the-mssql-database-in-plesk\/"},"wordCount":479,"commentCount":0,"publisher":{"@id":"https:\/\/www.skynats.com\/blog\/#organization"},"keywords":["add mssql database in plesk"],"articleSection":["Blog","MSSQL server","MySQL","Plesk server","server management"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.skynats.com\/blog\/enable-the-mssql-database-in-plesk\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.skynats.com\/blog\/enable-the-mssql-database-in-plesk\/","url":"https:\/\/www.skynats.com\/blog\/enable-the-mssql-database-in-plesk\/","name":"How to enable the MSSQL database in Plesk","isPartOf":{"@id":"https:\/\/www.skynats.com\/blog\/#website"},"datePublished":"2021-03-24T07:31:40+00:00","dateModified":"2024-12-11T12:16:01+00:00","description":"First, you need to log into Plesk Control Panel. In Plesk 12 choose the Subscriptions tab, click the [domain] and select the required one,","breadcrumb":{"@id":"https:\/\/www.skynats.com\/blog\/enable-the-mssql-database-in-plesk\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.skynats.com\/blog\/enable-the-mssql-database-in-plesk\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.skynats.com\/blog\/enable-the-mssql-database-in-plesk\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.skynats.com\/blog\/"},{"@type":"ListItem","position":2,"name":"How to enable the MS SQL database in Plesk?"}]},{"@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\/2968118a72bea0868796abf1237ab3e0","name":"Nabeela","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/12a999d0e3cd16cf2383c5551b39d00d6ddc2d035a2581ce5d85fce0762d0372?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/12a999d0e3cd16cf2383c5551b39d00d6ddc2d035a2581ce5d85fce0762d0372?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/12a999d0e3cd16cf2383c5551b39d00d6ddc2d035a2581ce5d85fce0762d0372?s=96&d=mm&r=g","caption":"Nabeela"}}]}},"_links":{"self":[{"href":"https:\/\/www.skynats.com\/blog\/wp-json\/wp\/v2\/posts\/6286","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\/7"}],"replies":[{"embeddable":true,"href":"https:\/\/www.skynats.com\/blog\/wp-json\/wp\/v2\/comments?post=6286"}],"version-history":[{"count":0,"href":"https:\/\/www.skynats.com\/blog\/wp-json\/wp\/v2\/posts\/6286\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.skynats.com\/blog\/wp-json\/wp\/v2\/media?parent=6286"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.skynats.com\/blog\/wp-json\/wp\/v2\/categories?post=6286"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.skynats.com\/blog\/wp-json\/wp\/v2\/tags?post=6286"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}