How to add an existing MS SQL database server instance to Plesk?

Created:

2017-06-30 20:22:14 UTC

Modified:

2017-08-16 16:02:46 UTC

0

Was this article helpful?


Have more questions?

Submit a request

How to add an existing MS SQL database server instance to Plesk?

Applicable to:

  • Plesk for Windows

Question

How to add an existing MS SQL database server instance to Plesk?

Answer

Note: How to add a new instance of existing MS SQL database server to Plesk?

If an MS SQL server instance has been installed not via Plesk Installer, it needs additional configuration before it could be added to Plesk:

  1. Download and install SQL Server Management Studio
  2. Open SQL Server Management Studio :
    • Select a required database server instance as a Server name
    • Select Windows Authentication as an Authentication
  3. Under the database server instance name, expand Security > Logins , right click on sa > Properties and set the required password - it will be needed to connect an instance to Plesk
  4. On the same window, click Status and apply the following changes:
    • Permission to connect to database engine : Grant
    • Login : Enabled
  5. In SQL Server Management Studio , right click on the database server instance name > Properties > Security > select SQL Server and Windows Authentication mode and click OK
  6. Open SQL Server Configuration Manager > expand SQL Server Network Configuration > select the database server instance name and enable the following options:
    • Named Pipes
    • TCP/IP
  7. Restart the SQL Server service at SQL Server Services
  8. In Plesk , go to Tools & Settings > Database Servers and click Add Database Server
  9. Type in the following information:
    • Database server type : MS SQL
    • Host name or IP address : .\SQLEXPRESS
      • " .\ " is required before a host name
      • The correct host name is a server name from the Step 2
    • Administrator's username : sa
    • Administrator's password : the password from the step 3
  10. Click OK
Have more questions? Submit a request
Please sign in to leave a comment.