Creating SQL Server Databases in Plesk (Not Just MariaDB) Print

Creating SQL Server Databases in Plesk

Plesk supports both MariaDB/MySQL and SQL Server databases. Here's how to create each type correctly.

Database Server Types Available

Creating a SQL Server Database

1. Log into Plesk
2. Go to Websites & Domains
3. Click Databases
4. Click Add Database
5. Important: Look for the Database server dropdown
6. Select your SQL Server option (e.g., "MSSQLSERVER2022" or "MSSQLSERVER2019")
7. Enter database name
8. Create database user with strong password
9. Click OK

Why Can't I See SQL Server Option?

If you only see MariaDB options:

Check 1: Correct Hosting Plan

• SQL Server is only available on Windows/ASP.NET hosting plans
• Linux plans only offer MariaDB/MySQL
• Verify your plan type in your client area

Check 2: SQL Server Quota

• Some plans have limited SQL Server databases
• Check if you've reached your quota
• View quotas in Plesk under Statistics

Check 3: Subscription Settings

• SQL Server may need to be enabled for your subscription
• Contact support if the option doesn't appear

SQL Server Versions

You may see multiple SQL Server versions:

• SQL Server 2022 - Latest, recommended for .NET 8+
• SQL Server 2019 - Stable, widely supported
• SQL Server 2017 - Legacy support

Recommendation: Use SQL Server 2022 or 2019 for new projects.

Database Connection Information

After creating your database, find connection details:

1. Go to Databases
2. Click on your database name
3. View Connection Information:
   • Server name
   • Database name
   • Username
   • Port (if applicable)

Example Connection String:

Server=SQL2022-001.adaptivewebhosting.com;Database=DB_12345_myapp;User Id=DB_12345_myapp_admin;Password=YourPassword;TrustServerCertificate=True;

Using Multiple Databases

For applications requiring separate databases (e.g., app data + identity):

1. Create first database normally
2. Click Add Database again
3. Select same SQL Server
4. Use same or different user as needed

Multiple Connection Strings:

{
  "ConnectionStrings": {
    "DefaultConnection": "Server=...;Database=DB_12345_app;...",
    "IdentityConnection": "Server=...;Database=DB_12345_identity;..."
  }
}

Troubleshooting

Database creation failed:

• Database name may already exist
• Quota limit reached
• Invalid characters in name (use letters, numbers, underscores)

Cannot connect after creation:

• Wait 1-2 minutes for provisioning
• Verify username/password exactly as shown
• Check server name is complete (including instance)