This guide explains how to create MS SQL databases and database users in Plesk. You'll learn how to configure database settings, create secure user credentials, and manage access permissions through Plesk's database management interface.

How to Do It

  1. Step 1: Access the Database Section

    Log in to Plesk and click on "Databases" in the main menu.

  2. Step 2: Start Creating a New Database

    Click "Add Database" to open the database creation window.

  3. Step 3: Configure Database Settings

    In the "Add a Database" window, enter the following information:

    • Enter your desired name in the "Database name" field
    • Choose an MS SQL database server from the "Database server" dropdown
    • Assign the database to a specific website by selecting it from the dropdown

  4. Step 4: Create Database User Credentials

    Input the username in the "Database username" field.

    For the password, you have two options:

    • Manual password: Type a password in the "Password" field. The password must be alphanumeric, including a combination of uppercase and lowercase letters, numbers, and special characters. Enter the same password in the "Confirm password" field.
    • Auto-generated password: Click "Generate" to automatically fill both password fields with a randomly generated password. Click "Show" to view the password, then copy and save it in a secure location for future reference. Click "Hide" to conceal the password again.

  5. Step 5: Configure User Access Permissions

    If you want to grant this user access to all databases created under this subscription, select the checkbox. It is recommended to keep it unchecked for security purposes.

    In the "Remote Access" section, the default setting is "Use the system firewall rules." If you choose "Allow remote connections from," you can specify IP addresses that are permitted to access the database on behalf of this user. It is recommended to use the default option, which allows connections based on the system firewall rules.

  6. Step 6: Finalize and Verify

    Click "OK" to create the database and database user.

    You will receive a success message, and your new database user will appear in User Management. You can click on the username at any time to modify its settings.