Plesk 8.4 > 8.6 MSSQL psa database error

[VisualNetworks]

Hi, just updated Plesk 8.4 to 8.6 and MS SQL Server 2005 is giving me login error to psa database, and user databases also. Please help!


ERROR: PleskMainDBException
<b>Source:</b> Microsoft OLE DB Provider for SQL Server<br/><b>Description:</b> Cannot open database "psa" requested by the login. The login failed.

0: plib\common_func.php3:624
db_mssql_connection()
1: plib\common_func.php3:653
reconnect()
2: plib\common_func.php3:614
db_connect()
3: auto_prepend\auth.php3:80

 

[jamin]

We are havign same issue, has anyone found a fix???

 

[glennexpert]

Open SQL Server management studio express. If you don't have it, you can download it from the microsoft site.
Look under security -- logins for admin and reset the password to the one you use to login on plesk control panel