{"id":155,"date":"2026-05-27T23:17:29","date_gmt":"2026-05-28T06:17:29","guid":{"rendered":"https:\/\/hostandtech.com\/kb\/plesk-windows\/how-to-configure-mssql-database-in-plesk\/"},"modified":"2026-05-27T23:17:29","modified_gmt":"2026-05-28T06:17:29","slug":"how-to-configure-mssql-database-in-plesk","status":"publish","type":"post","link":"https:\/\/hostandtech.com\/kb\/plesk-windows\/how-to-configure-mssql-database-in-plesk\/","title":{"rendered":"How to Configure MSSQL Database in Plesk"},"content":{"rendered":"<h2>Overview<\/h2>\n<p>Plesk MSSQL support lets you create and manage Microsoft SQL Server databases directly from the Plesk control panel, without touching SQL Server Management Studio (SSMS) for day-to-day tasks. If you&#8217;re running a .NET application, an ASP.NET CMS, or any Windows-based web stack, you&#8217;ll almost certainly need this.<\/p>\n<p>Plesk doesn&#8217;t ship with SQL Server bundled in \u2014 it integrates with an existing SQL Server instance installed on the same machine or accessible over the network. That distinction matters. If you&#8217;ve just provisioned a new Windows VPS and you&#8217;re wondering why MSSQL options aren&#8217;t showing up in Plesk, it&#8217;s because SQL Server itself hasn&#8217;t been installed or registered yet. That&#8217;s the most common source of confusion and it&#8217;s not obvious from the Plesk UI.<\/p>\n<p>This article covers the full setup flow: registering a SQL Server instance in Plesk, creating a database and user, setting permissions, and resolving the errors users hit most often after setup.<\/p>\n<h2>Prerequisites<\/h2>\n<ul>\n<li>Plesk Obsidian 18.0 or later (Windows edition) installed and licensed<\/li>\n<li>Microsoft SQL Server 2019 or 2022 installed on the server \u2014 Express edition works for most small apps<\/li>\n<li>Administrator or root-level access to the Plesk panel<\/li>\n<li>SQL Server configured to allow SQL Server Authentication mode (Mixed Mode), not Windows Authentication only<\/li>\n<li>TCP\/IP protocol enabled in SQL Server Configuration Manager<\/li>\n<li>Port 1433 open in Windows Firewall if connecting remotely<\/li>\n<li>The <code class=\"\" data-line=\"\">sa<\/code> account password, or credentials for another SQL Server login with <code class=\"\" data-line=\"\">sysadmin<\/code> privileges<\/li>\n<\/ul>\n<h2>Step 1: Register the SQL Server Instance in Plesk<\/h2>\n<p>Before any subscription can use MSSQL, Plesk needs to know where SQL Server is running. This is a one-time admin task.<\/p>\n<ol>\n<li>Log in to Plesk as <strong>Administrator<\/strong>.<\/li>\n<li>Go to <strong>Tools &amp; Settings<\/strong> &gt; <strong>Database Servers<\/strong>.<\/li>\n<li>Click <strong>Add Database Server<\/strong>.<\/li>\n<li>Set <strong>Database server type<\/strong> to <strong>Microsoft SQL Server<\/strong>.<\/li>\n<li>In the <strong>Hostname<\/strong> field, enter <code class=\"\" data-line=\"\">localhost<\/code> if SQL Server is on the same machine. For a named instance (e.g. <code class=\"\" data-line=\"\">SQLEXPRESS<\/code>), use <code class=\"\" data-line=\"\">localhostSQLEXPRESS<\/code>.<\/li>\n<li>Enter port <code class=\"\" data-line=\"\">1433<\/code> (default). Named instances often use dynamic ports \u2014 check SQL Server Configuration Manager if you&#8217;re unsure.<\/li>\n<li>Enter the <strong>Administrator login<\/strong> (usually <code class=\"\" data-line=\"\">sa<\/code>) and its password.<\/li>\n<li>Click <strong>OK<\/strong>. Plesk will test the connection immediately.<\/li>\n<\/ol>\n<p>\ud83d\udcdd Note: If you&#8217;re on a <a href=\"https:\/\/www.hostandtech.com\/vps-ssd-servers\">VPS SSD Hosting<\/a> plan running Windows Server, SQL Server Express is free to install and more than adequate for most applications under 10 GB. Full SQL Server Standard or Enterprise is needed if you exceed Express edition limits.<\/p>\n<p>\u26a0 Warning: Do not use the <code class=\"\" data-line=\"\">sa<\/code> account as the ongoing application database user. Register it here for Plesk integration, then create a least-privilege user per application in the steps below.<\/p>\n<h2>Step 2: Create a New MSSQL Database<\/h2>\n<ol>\n<li>In Plesk, navigate to the subscription (domain) where you want the database.<\/li>\n<li>Click <strong>Databases<\/strong> in the subscription dashboard.<\/li>\n<li>Click <strong>Add Database<\/strong>.<\/li>\n<li>Enter a <strong>Database name<\/strong>. Plesk may prefix it with the subscription username automatically \u2014 this is normal behaviour and helps avoid naming collisions.<\/li>\n<li>Under <strong>Database server<\/strong>, select the MSSQL instance you registered in Step 1.<\/li>\n<li>Click <strong>OK<\/strong>.<\/li>\n<\/ol>\n<p>The database is created immediately. You&#8217;ll see it listed under the Databases tab with the server type shown as <strong>mssql<\/strong>.<\/p>\n<h2>Step 3: Create a Database User<\/h2>\n<ol>\n<li>From the Databases list, click the database name you just created.<\/li>\n<li>Click <strong>Add User<\/strong>.<\/li>\n<li>Enter a <strong>Database user name<\/strong> and a strong password. Passwords must meet SQL Server complexity requirements: at least 8 characters, mixed case, numbers, and a symbol.<\/li>\n<li>Click <strong>OK<\/strong>.<\/li>\n<\/ol>\n<p>Plesk creates a SQL Server login and maps it to the database as a user with <code class=\"\" data-line=\"\">db_owner<\/code> role by default. That&#8217;s appropriate for most web applications.<\/p>\n<p>\ud83d\udcdd Note: If your application only needs read access (e.g. a reporting front-end), you should manually assign a more restrictive role via SSMS or T-SQL after Plesk creates the user. Plesk doesn&#8217;t expose granular role assignment in the UI.<\/p>\n<p>To set a read-only role manually via T-SQL:<\/p>\n<div class=\"ht-code-snippet\"><button class=\"ht-code-snippet__copy\" type=\"button\" aria-label=\"Copy code\"><\/button><span class=\"ht-code-snippet__feedback\">Copied to clipboard<\/span><\/p>\n<pre class=\"ht-code-snippet__code\" id=\"code-block-1\"><code class=\"\" data-line=\"\">USE YourDatabaseName;\nALTER ROLE db_datareader ADD MEMBER YourUserName;\nALTER ROLE db_owner DROP MEMBER YourUserName;<\/code><\/pre>\n<\/div>\n<h2>Step 4: Connect Your Application to the Database<\/h2>\n<p>Your application needs a connection string. Here&#8217;s what a standard ASP.NET connection string looks like using SQL Server Authentication:<\/p>\n<div class=\"ht-code-snippet\"><button class=\"ht-code-snippet__copy\" type=\"button\" aria-label=\"Copy code\"><\/button><span class=\"ht-code-snippet__feedback\">Copied to clipboard<\/span><\/p>\n<pre class=\"ht-code-snippet__code\" id=\"code-block-2\"><code class=\"\" data-line=\"\">&lt;connectionStrings&gt;\n  &lt;add name=&quot;DefaultConnection&quot;\n       connectionString=&quot;Server=localhost;Database=YourDatabaseName;User Id=YourUserName;Password=YourPassword;TrustServerCertificate=True;&quot;\n       providerName=&quot;System.Data.SqlClient&quot; \/&gt;\n&lt;\/connectionStrings&gt;<\/code><\/pre>\n<\/div>\n<p>For .NET 6+ applications using <code class=\"\" data-line=\"\">appsettings.json<\/code>:<\/p>\n<div class=\"ht-code-snippet\"><button class=\"ht-code-snippet__copy\" type=\"button\" aria-label=\"Copy code\"><\/button><span class=\"ht-code-snippet__feedback\">Copied to clipboard<\/span><\/p>\n<pre class=\"ht-code-snippet__code\" id=\"code-block-3\"><code class=\"\" data-line=\"\">{\n  &quot;ConnectionStrings&quot;: {\n    &quot;DefaultConnection&quot;: &quot;Server=localhost;Database=YourDatabaseName;User Id=YourUserName;Password=YourPassword;TrustServerCertificate=True;&quot;\n  }\n}<\/code><\/pre>\n<\/div>\n<p>\u26a0 Warning: The <code class=\"\" data-line=\"\">TrustServerCertificate=True<\/code> flag is often needed on self-hosted SQL Server instances that don&#8217;t have a valid SSL certificate installed. Without it, .NET 4.8+ and .NET 6+ drivers will refuse the connection. Don&#8217;t use this flag against external or production databases where you can&#8217;t control the certificate chain.<\/p>\n<h2>Step 5: Access the Database via phpMyAdmin Alternative (Plesk DB WebAdmin)<\/h2>\n<p>Plesk includes a web-based database manager for MSSQL. From the Databases list, click <strong>WebAdmin<\/strong> next to your database. This opens a browser-based interface where you can run queries, browse tables, and import\/export data \u2014 no SSMS installation required.<\/p>\n<p>For bulk imports, use the <strong>Import<\/strong> tab to upload a <code class=\"\" data-line=\"\">.sql<\/code> or <code class=\"\" data-line=\"\">.bak<\/code>-derived script file. Large imports over 50 MB should be done via SSMS or the command line to avoid PHP timeout limits in the WebAdmin interface.<\/p>\n<p>To restore from a <code class=\"\" data-line=\"\">.bak<\/code> file via T-SQL (run in SSMS or <code class=\"\" data-line=\"\">sqlcmd<\/code>):<\/p>\n<div class=\"ht-code-snippet\"><button class=\"ht-code-snippet__copy\" type=\"button\" aria-label=\"Copy code\"><\/button><span class=\"ht-code-snippet__feedback\">Copied to clipboard<\/span><\/p>\n<pre class=\"ht-code-snippet__code\" id=\"code-block-4\"><code class=\"\" data-line=\"\">RESTORE DATABASE YourDatabaseName\nFROM DISK = &#039;C:BackupsYourBackupFile.bak&#039;\nWITH REPLACE,\n     MOVE &#039;YourDatabaseName&#039; TO &#039;C:Program FilesMicrosoft SQL ServerMSSQL16.MSSQLSERVERMSSQLDATAYourDatabaseName.mdf&#039;,\n     MOVE &#039;YourDatabaseName_log&#039; TO &#039;C:Program FilesMicrosoft SQL ServerMSSQL16.MSSQLSERVERMSSQLDATAYourDatabaseName_log.ldf&#039;;<\/code><\/pre>\n<\/div>\n<p>\ud83d\udcdd Note: The <code class=\"\" data-line=\"\">MSSQL16<\/code> folder name corresponds to SQL Server 2022. SQL Server 2019 uses <code class=\"\" data-line=\"\">MSSQL15<\/code>. Check your actual install path in Windows Explorer before running this.<\/p>\n<h2>Common Issues &amp; Troubleshooting<\/h2>\n<h3>&#8220;Cannot connect to database server&#8221; when registering in Plesk<\/h3>\n<p>This almost always means one of three things: TCP\/IP is disabled in SQL Server Configuration Manager, the SQL Server Browser service isn&#8217;t running (required for named instances), or Windows Firewall is blocking port 1433. Open <strong>SQL Server Configuration Manager<\/strong>, go to <strong>SQL Server Network Configuration &gt; Protocols for MSSQLSERVER<\/strong>, and confirm TCP\/IP is <strong>Enabled<\/strong>. Restart the SQL Server service after enabling it \u2014 changes don&#8217;t take effect until you do.<\/p>\n<h3>&#8220;Login failed for user&#8221; error in application logs<\/h3>\n<p>This usually means SQL Server is running in <strong>Windows Authentication Only<\/strong> mode instead of Mixed Mode. In SSMS, right-click the server, go to <strong>Properties &gt; Security<\/strong>, and switch to <strong>SQL Server and Windows Authentication mode<\/strong>. Then restart the SQL Server service. The <code class=\"\" data-line=\"\">sa<\/code> account is disabled by default in Windows Auth mode, so you&#8217;ll need to enable it explicitly:<\/p>\n<div class=\"ht-code-snippet\"><button class=\"ht-code-snippet__copy\" type=\"button\" aria-label=\"Copy code\"><\/button><span class=\"ht-code-snippet__feedback\">Copied to clipboard<\/span><\/p>\n<pre class=\"ht-code-snippet__code\" id=\"code-block-5\"><code class=\"\" data-line=\"\">ALTER LOGIN sa ENABLE;\nALTER LOGIN sa WITH PASSWORD = &#039;YourStrongPassword!&#039;;<\/code><\/pre>\n<\/div>\n<h3>MSSQL option not appearing in Plesk&#8217;s &#8220;Add Database&#8221; dropdown<\/h3>\n<p>If you don&#8217;t see Microsoft SQL Server as a database type option, no MSSQL server has been registered at the admin level. Log in as the Plesk Administrator (not a reseller or subscription user) and complete Step 1 above. Subscription-level users can&#8217;t register database servers themselves.<\/p>\n<h3>Database import times out or fails via WebAdmin<\/h3>\n<p>Plesk&#8217;s WebAdmin tool has a 30-second PHP execution limit for database operations. For scripts over a few megabytes, use <code class=\"\" data-line=\"\">sqlcmd<\/code> from the command line instead:<\/p>\n<div class=\"ht-code-snippet\"><button class=\"ht-code-snippet__copy\" type=\"button\" aria-label=\"Copy code\"><\/button><span class=\"ht-code-snippet__feedback\">Copied to clipboard<\/span><\/p>\n<pre class=\"ht-code-snippet__code\" id=\"code-block-6\"><code class=\"\" data-line=\"\">sqlcmd -S localhost -U YourUserName -P YourPassword -d YourDatabaseName -i C:pathtoscript.sql<\/code><\/pre>\n<\/div>\n<h3>&#8220;The database principal owns a schema&#8221; error when dropping a user<\/h3>\n<p>This happens when you try to remove a database user who owns the default <code class=\"\" data-line=\"\">dbo<\/code> schema or a custom schema. Transfer schema ownership first:<\/p>\n<div class=\"ht-code-snippet\"><button class=\"ht-code-snippet__copy\" type=\"button\" aria-label=\"Copy code\"><\/button><span class=\"ht-code-snippet__feedback\">Copied to clipboard<\/span><\/p>\n<pre class=\"ht-code-snippet__code\" id=\"code-block-7\"><code class=\"\" data-line=\"\">ALTER AUTHORIZATION ON SCHEMA::dbo TO dbo;\nDROP USER YourUserName;<\/code><\/pre>\n<\/div>\n<p>This error is annoyingly common and the SQL Server error message doesn&#8217;t make it obvious what you need to fix. Transferring the schema to the built-in <code class=\"\" data-line=\"\">dbo<\/code> principal resolves it cleanly.<\/p>\n<h2>FAQ<\/h2>\n<div class=\"ht-faq-section\">\n<h2>Frequently Asked Questions<\/h2>\n<div class=\"ht-faq-item\">\n<h3 class=\"ht-faq-question\">Can I use MSSQL with Plesk on Linux?<\/h3>\n<div class=\"ht-faq-answer\">\n<p>No. Plesk&#8217;s native MSSQL integration is only available on the Windows edition of Plesk. If you&#8217;re on a Linux server, you&#8217;d need to run SQL Server for Linux separately and connect to it manually via your application&#8217;s connection string \u2014 Plesk won&#8217;t manage it through the Databases panel.<\/p>\n<\/div>\n<\/div>\n<div class=\"ht-faq-item\">\n<h3 class=\"ht-faq-question\">What&#039;s the difference between MSSQL Express and full SQL Server in Plesk?<\/h3>\n<div class=\"ht-faq-answer\">\n<p>SQL Server Express is free and works fine for most small-to-medium web apps. The main limits are a 10 GB database size cap per database, no SQL Server Agent (so no scheduled jobs), and capped CPU and memory usage. If your application needs scheduled tasks, larger databases, or high concurrency, you&#8217;ll need SQL Server Standard or Developer edition.<\/p>\n<\/div>\n<\/div>\n<div class=\"ht-faq-item\">\n<h3 class=\"ht-faq-question\">How do I back up an MSSQL database in Plesk?<\/h3>\n<div class=\"ht-faq-answer\">\n<p>Plesk&#8217;s built-in backup tool can include MSSQL databases when you run a full subscription backup. Go to Websites &amp; Domains, click Backup Manager, and ensure the backup scope includes databases. For scheduled or more granular backups, I&#8217;d recommend setting up a SQL Server Agent job or using a Maintenance Plan directly in SSMS \u2014 Plesk&#8217;s backup covers the basics but doesn&#8217;t give you point-in-time recovery options.<\/p>\n<\/div>\n<\/div>\n<div class=\"ht-faq-item\">\n<h3 class=\"ht-faq-question\">Can multiple subscriptions share the same MSSQL database server in Plesk?<\/h3>\n<div class=\"ht-faq-answer\">\n<p>Yes. Once an MSSQL server is registered at the admin level, all subscriptions on that Plesk server can create databases on it. Each subscription&#8217;s databases are isolated by user permissions, but they all live on the same SQL Server instance. For production environments with strict isolation requirements, you&#8217;d want separate SQL Server instances per client.<\/p>\n<\/div>\n<\/div>\n<div class=\"ht-faq-item\">\n<h3 class=\"ht-faq-question\">Why is my MSSQL database user showing as &#039;orphaned&#039; after a restore?<\/h3>\n<div class=\"ht-faq-answer\">\n<p>Orphaned users happen when you restore a database from another server \u2014 the database user exists but its SQL Server login SID doesn&#8217;t match anything on the new server. Fix it by re-mapping the user to an existing login: run ALTER USER [YourUser] WITH LOGIN = [YourLogin]; in the context of that database. This is a very common issue when migrating databases between servers or environments.<\/p>\n<\/div>\n<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>Running MSSQL on a Plesk Windows server is straightforward once you know where the gotchas are. This guide walks you through creating databases, managing users, and fixing the connection issues that trip people up most often.<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"default","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","ast-disable-related-posts":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"categories":[66],"tags":[251,249,250,252,246,248,247,87],"class_list":["post-155","post","type-post","status-publish","format-standard","hentry","category-plesk-windows","tag-how-to-configure-mssql-database-in-plesk","tag-mssql-database","tag-plesk-database-management","tag-plesk-guide","tag-plesk-mssql","tag-plesk-windows","tag-sql-server","tag-windows-hosting"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.6 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>How to Configure MSSQL Database in Plesk<\/title>\n<meta name=\"description\" content=\"Learn how to configure a Plesk MSSQL database step by step \u2014 create databases, manage users, set permissions, and troubleshoot SQL Server connection errors.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/hostandtech.com\/kb\/plesk-windows\/how-to-configure-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 Configure MSSQL Database in Plesk\" \/>\n<meta property=\"og:description\" content=\"Learn how to configure a Plesk MSSQL database step by step \u2014 create databases, manage users, set permissions, and troubleshoot SQL Server connection errors.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/hostandtech.com\/kb\/plesk-windows\/how-to-configure-mssql-database-in-plesk\/\" \/>\n<meta property=\"og:site_name\" content=\"Host And Tech knowledge base\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/stshostandtech\" \/>\n<meta property=\"article:published_time\" content=\"2026-05-28T06:17:29+00:00\" \/>\n<meta name=\"author\" content=\"admin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@stshostandtech\" \/>\n<meta name=\"twitter:site\" content=\"@stshostandtech\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"admin\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"8 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/hostandtech.com\\\/kb\\\/plesk-windows\\\/how-to-configure-mssql-database-in-plesk\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/hostandtech.com\\\/kb\\\/plesk-windows\\\/how-to-configure-mssql-database-in-plesk\\\/\"},\"author\":{\"name\":\"admin\",\"@id\":\"https:\\\/\\\/hostandtech.com\\\/kb\\\/#\\\/schema\\\/person\\\/b6fa79c48ddaba71af32e395c5b017ee\"},\"headline\":\"How to Configure MSSQL Database in Plesk\",\"datePublished\":\"2026-05-28T06:17:29+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/hostandtech.com\\\/kb\\\/plesk-windows\\\/how-to-configure-mssql-database-in-plesk\\\/\"},\"wordCount\":1516,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/hostandtech.com\\\/kb\\\/#organization\"},\"keywords\":[\"How to Configure MSSQL Database in Plesk\",\"MSSQL database\",\"Plesk database management\",\"plesk guide\",\"Plesk MSSQL\",\"Plesk Windows\",\"SQL Server\",\"Windows hosting\"],\"articleSection\":[\"Plesk on Windows\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/hostandtech.com\\\/kb\\\/plesk-windows\\\/how-to-configure-mssql-database-in-plesk\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/hostandtech.com\\\/kb\\\/plesk-windows\\\/how-to-configure-mssql-database-in-plesk\\\/\",\"url\":\"https:\\\/\\\/hostandtech.com\\\/kb\\\/plesk-windows\\\/how-to-configure-mssql-database-in-plesk\\\/\",\"name\":\"How to Configure MSSQL Database in Plesk\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/hostandtech.com\\\/kb\\\/#website\"},\"datePublished\":\"2026-05-28T06:17:29+00:00\",\"description\":\"Learn how to configure a Plesk MSSQL database step by step \u2014 create databases, manage users, set permissions, and troubleshoot SQL Server connection errors.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/hostandtech.com\\\/kb\\\/plesk-windows\\\/how-to-configure-mssql-database-in-plesk\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/hostandtech.com\\\/kb\\\/plesk-windows\\\/how-to-configure-mssql-database-in-plesk\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/hostandtech.com\\\/kb\\\/plesk-windows\\\/how-to-configure-mssql-database-in-plesk\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/hostandtech.com\\\/kb\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to Configure MSSQL Database in Plesk\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/hostandtech.com\\\/kb\\\/#website\",\"url\":\"https:\\\/\\\/hostandtech.com\\\/kb\\\/\",\"name\":\"Host And Tech knowledge base\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\\\/\\\/hostandtech.com\\\/kb\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/hostandtech.com\\\/kb\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/hostandtech.com\\\/kb\\\/#organization\",\"name\":\"Host And Tech knowledge base\",\"url\":\"https:\\\/\\\/hostandtech.com\\\/kb\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/hostandtech.com\\\/kb\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/hostandtech.com\\\/kb\\\/wp-content\\\/uploads\\\/2026\\\/05\\\/logo-dark.png\",\"contentUrl\":\"https:\\\/\\\/hostandtech.com\\\/kb\\\/wp-content\\\/uploads\\\/2026\\\/05\\\/logo-dark.png\",\"width\":1134,\"height\":395,\"caption\":\"Host And Tech knowledge base\"},\"image\":{\"@id\":\"https:\\\/\\\/hostandtech.com\\\/kb\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/www.facebook.com\\\/stshostandtech\",\"https:\\\/\\\/x.com\\\/stshostandtech\"]},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/hostandtech.com\\\/kb\\\/#\\\/schema\\\/person\\\/b6fa79c48ddaba71af32e395c5b017ee\",\"name\":\"admin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/aa1edac8bbadb442e059a5b65ad45a3b2e3ce689202373b96e3e567517ae4b39?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/aa1edac8bbadb442e059a5b65ad45a3b2e3ce689202373b96e3e567517ae4b39?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/aa1edac8bbadb442e059a5b65ad45a3b2e3ce689202373b96e3e567517ae4b39?s=96&d=mm&r=g\",\"caption\":\"admin\"},\"sameAs\":[\"https:\\\/\\\/hostandtech.com\\\/kb\"],\"url\":\"https:\\\/\\\/hostandtech.com\\\/kb\\\/author\\\/admin_fjj7qydm\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How to Configure MSSQL Database in Plesk","description":"Learn how to configure a Plesk MSSQL database step by step \u2014 create databases, manage users, set permissions, and troubleshoot SQL Server connection errors.","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:\/\/hostandtech.com\/kb\/plesk-windows\/how-to-configure-mssql-database-in-plesk\/","og_locale":"en_US","og_type":"article","og_title":"How to Configure MSSQL Database in Plesk","og_description":"Learn how to configure a Plesk MSSQL database step by step \u2014 create databases, manage users, set permissions, and troubleshoot SQL Server connection errors.","og_url":"https:\/\/hostandtech.com\/kb\/plesk-windows\/how-to-configure-mssql-database-in-plesk\/","og_site_name":"Host And Tech knowledge base","article_publisher":"https:\/\/www.facebook.com\/stshostandtech","article_published_time":"2026-05-28T06:17:29+00:00","author":"admin","twitter_card":"summary_large_image","twitter_creator":"@stshostandtech","twitter_site":"@stshostandtech","twitter_misc":{"Written by":"admin","Est. reading time":"8 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/hostandtech.com\/kb\/plesk-windows\/how-to-configure-mssql-database-in-plesk\/#article","isPartOf":{"@id":"https:\/\/hostandtech.com\/kb\/plesk-windows\/how-to-configure-mssql-database-in-plesk\/"},"author":{"name":"admin","@id":"https:\/\/hostandtech.com\/kb\/#\/schema\/person\/b6fa79c48ddaba71af32e395c5b017ee"},"headline":"How to Configure MSSQL Database in Plesk","datePublished":"2026-05-28T06:17:29+00:00","mainEntityOfPage":{"@id":"https:\/\/hostandtech.com\/kb\/plesk-windows\/how-to-configure-mssql-database-in-plesk\/"},"wordCount":1516,"commentCount":0,"publisher":{"@id":"https:\/\/hostandtech.com\/kb\/#organization"},"keywords":["How to Configure MSSQL Database in Plesk","MSSQL database","Plesk database management","plesk guide","Plesk MSSQL","Plesk Windows","SQL Server","Windows hosting"],"articleSection":["Plesk on Windows"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/hostandtech.com\/kb\/plesk-windows\/how-to-configure-mssql-database-in-plesk\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/hostandtech.com\/kb\/plesk-windows\/how-to-configure-mssql-database-in-plesk\/","url":"https:\/\/hostandtech.com\/kb\/plesk-windows\/how-to-configure-mssql-database-in-plesk\/","name":"How to Configure MSSQL Database in Plesk","isPartOf":{"@id":"https:\/\/hostandtech.com\/kb\/#website"},"datePublished":"2026-05-28T06:17:29+00:00","description":"Learn how to configure a Plesk MSSQL database step by step \u2014 create databases, manage users, set permissions, and troubleshoot SQL Server connection errors.","breadcrumb":{"@id":"https:\/\/hostandtech.com\/kb\/plesk-windows\/how-to-configure-mssql-database-in-plesk\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/hostandtech.com\/kb\/plesk-windows\/how-to-configure-mssql-database-in-plesk\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/hostandtech.com\/kb\/plesk-windows\/how-to-configure-mssql-database-in-plesk\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/hostandtech.com\/kb\/"},{"@type":"ListItem","position":2,"name":"How to Configure MSSQL Database in Plesk"}]},{"@type":"WebSite","@id":"https:\/\/hostandtech.com\/kb\/#website","url":"https:\/\/hostandtech.com\/kb\/","name":"Host And Tech knowledge base","description":"","publisher":{"@id":"https:\/\/hostandtech.com\/kb\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/hostandtech.com\/kb\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/hostandtech.com\/kb\/#organization","name":"Host And Tech knowledge base","url":"https:\/\/hostandtech.com\/kb\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/hostandtech.com\/kb\/#\/schema\/logo\/image\/","url":"https:\/\/hostandtech.com\/kb\/wp-content\/uploads\/2026\/05\/logo-dark.png","contentUrl":"https:\/\/hostandtech.com\/kb\/wp-content\/uploads\/2026\/05\/logo-dark.png","width":1134,"height":395,"caption":"Host And Tech knowledge base"},"image":{"@id":"https:\/\/hostandtech.com\/kb\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/stshostandtech","https:\/\/x.com\/stshostandtech"]},{"@type":"Person","@id":"https:\/\/hostandtech.com\/kb\/#\/schema\/person\/b6fa79c48ddaba71af32e395c5b017ee","name":"admin","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/aa1edac8bbadb442e059a5b65ad45a3b2e3ce689202373b96e3e567517ae4b39?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/aa1edac8bbadb442e059a5b65ad45a3b2e3ce689202373b96e3e567517ae4b39?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/aa1edac8bbadb442e059a5b65ad45a3b2e3ce689202373b96e3e567517ae4b39?s=96&d=mm&r=g","caption":"admin"},"sameAs":["https:\/\/hostandtech.com\/kb"],"url":"https:\/\/hostandtech.com\/kb\/author\/admin_fjj7qydm\/"}]}},"_links":{"self":[{"href":"https:\/\/hostandtech.com\/kb\/wp-json\/wp\/v2\/posts\/155","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/hostandtech.com\/kb\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/hostandtech.com\/kb\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/hostandtech.com\/kb\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/hostandtech.com\/kb\/wp-json\/wp\/v2\/comments?post=155"}],"version-history":[{"count":0,"href":"https:\/\/hostandtech.com\/kb\/wp-json\/wp\/v2\/posts\/155\/revisions"}],"wp:attachment":[{"href":"https:\/\/hostandtech.com\/kb\/wp-json\/wp\/v2\/media?parent=155"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/hostandtech.com\/kb\/wp-json\/wp\/v2\/categories?post=155"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/hostandtech.com\/kb\/wp-json\/wp\/v2\/tags?post=155"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}