Symptoms
Unable to create a database remote Microsoft SQL Server at Plesk > Tools & Settings > Database Servers with the following error:
PLESK_ERROR: Error: The test connection to the database server has failed because of ntwork problems:
mssqlmng failed: Login failed for user ‘jdoe‘ at (VADOConnection::open line 48) at Unable to ADO conect with connection string: Provider=SQLNCLI11;Initial Catalog=master;Data Source=(VADODatabaseProvider::connect line 182) at execute console command –create-database(vconsoleapp::start line 93) at execute “C:Program Files (x86)ParallelsPleskadminbinmssqlmng” –check “server= 203.0.113.2” “–login=jdoe “–password=*'(vconsoleap::run line 110)
Cause
MSSQL user specified does not have sysadmin role in MSSQL Server.
Resolution
One of the following solutions can be applied:
Add the database by using the “sa” user
- Log into Plesk
- Go to Tools & Settings > Database Servers > Add new database and specify the “sa” user instead
Add the “sysadmin” role for the necessary user
-
Connect to the MSSQL using SQL Management Studio
-
Go to Security > Logins > right-click jdoe > Properties > Server Roles
-
Grant the sysadmin role:
-
Click the OK button
-
Go to Tools & Settings > Database Servers > Add new database and specifify the necessary MSSQL user