MS SQL server is missing from Plesk

Created:

2016-11-16 13:18:27 UTC

Modified:

2017-04-24 11:23:04 UTC

0

Was this article helpful?


Have more questions?

Submit a request

MS SQL server is missing from Plesk

Applicable to:

  • Plesk 11.5 for Windows
  • Plesk 12.5 for Windows

Symptoms

Unable to connect to a newly installed MS SQL server from Plesk.

Cause

MS SQL server is not registered in Plesk.

Resolution

  1. Open MS SQL server properties in MS SQL Server Management Studio (it can be downloaded from here ).
  2. Go to 'security' .
  3. Set authentication mode to 'sql and windows (both)' .
  4. Update password for the ' sa ' user.
  5. Register SQL Server in Plesk with ' sa ' user credentials : Home > Tools&Settings > Database Server > Add Database Server .
Have more questions? Submit a request
Please sign in to leave a comment.