Plesk Control Panel ERROR: PleskMainDBException

[md5sal]

Hi all,

My control Panel suddenly showing this error:

ERROR: PleskMainDBException
<b>Source:</b> Microsoft OLE DB Provider for SQL Server<br/><b>Description:</b> [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.

0: common_func.php3:600
db_mssql_connection()
1: common_func.php3:629
reconnect()
2: common_func.php3:590
db_connect()
3: auth.php3:87

After do some digging, in Event Viewer it show SQL evaluation period had expired. Already reinstall the MSSQL,
but same error still occurs. Any idea how to fix this issue? Thanks

 

[IgorG]

Do you have the same error about expiration after MSSQL reinstalling? Did you tried to check connection with

C:\Program Files (x86)\Parallels\Plesk\/admin/bin/mssqlmng --check --server=localhost --login=sa --password=XXXX

Are you sure that MSSQL password for 'sa' user is the same that in Plesk psa database?

 

[md5sal]

Able to found the solution by change the registry value at HKEY_LOCAL_MACHINE\SOFTWARE\PLESK\PSA Config\Config\MySQL_DB_HOST from localhost to .\SQLEXPRESS