Plesk (windows) backup gives the error: Failed to connect to database: User ‘admin’ has exceeded the ‘max_user_connections’ resource (current value: 10)

Saturday, July 12th, 2008

when you try to backup the databases of the websites from Plesk Backup util and you get failure and the message “Failed to connect to database: User ‘admin’ has exceeded the ‘max_user_connections’ resource (current value: 10)” you have to change the mysql options

(more…)

Posted in Plesk, Windows | No Comments »

Plesk Mssql Delete database user failed: Timeout expired

Tuesday, June 17th, 2008

When you try to delete a domain from Plesk or delete straight the mssql database user from a plesk’s client, you may encounter the abover error:

Delete database user failed: Timeout expired

the workarround for this is :

(more…)

Posted in MSSQL, Plesk | No Comments »

How to change database collation in MSSQL

Tuesday, July 17th, 2007

To do it use the following query:

(more…)

Posted in MSSQL | No Comments »