- Plesk for Windows
Server's IP address was changed recently from 203.0.113.2 to 203.0.113.3. Some issues may have appeared during IP address switching.
Local MS SQL database server cannot be activated in Plesk > Tools & Settings > Database Servers with the error:
PLESK_ERROR: Error: The test connection to the database server has failed because of network problems:
mssqlmng failed: Login failed for user 'sa'.
at (VADOConnection::open line 48)
at Unable to ADO conect with connection string: Provider=SQLOLEDB.1;Initial Catalog=master;Data Source=203.0.113.2(VADODatabaseProvider::connect line 182)
at execute console command --check(vconsoleapp::start line 122)
at execute "C:\Program Files (x86)\Plesk\admin\bin\mssqlmng.exe" --check "--server=203.0.113.2" "--login=sa" "--password=*"(vconsoleapp::run line 139)
(Error code 1)
The MS SQL server in Plesk is still configured to use the old IP address.
The MS SQL server contains user's databases.
MS SQL server is configured to use a wrong IP address.
There is no possibility to change the IP address of already configured database server in Plesk. To fix the issue, set a new IP address in
Connect to the server via RDP.
Create a backup of psa database via command line:
C:\> plesk db dump > C:\psa.dump.sql
C:\> plesk db
Update IP address:
MYSQL_WIN: mysql> update databaseservers set host="203.0.113.3" where host="203.0.113.2";
where 203.0.113.2 - an old server's IP address;
203.0.113.3 - a new server's IP address.