Delete database user failed

[digiweb]

Hello folks,

I'm having a problema when I try to delete some SQL databases, thru the plesk painel interface. I can create SQL databases just fine, it always works. But when I try to delete some of them, I receive this message almost every time:

Delete database user failed: Timeout expired
---------------------- Debug Info -------------------------------
0: C:\Program Files\SWsoft\Plesk\admin\plib\DatabaseManagerMSSQL.php:52
DatabaseManagerMSSQL->dropUserImpl(string 'pedro', string 'pedro')
1: C:\Program Files\SWsoft\Plesk\admin\plib\DatabaseManager.php:87
DatabaseManager->deleteDatabase(object of type Database)
2: C:\Program Files\SWsoft\Plesk\admin\htdocs\server\db_server_databases.php:42

Sometimes if I try again it works, sometimes it doesn't. I have to delete the SQL user at Enterprise Manager, and then the DB delete is possible thru the Plesk CP.

Inside my Windows Server machine, I see this at plesk's event viewer:

Timeout expired
at (VADOConnection::execute line 90)
at execute console command --del-user(vconsoleapp::start line 128)
at execute "C:\Program Files\SWsoft\Plesk\admin\bin\mssqlmng.exe" --del-user "--server=localhost" "--login=sa" "--password=xxx" "--database=xxx" "--user-login=xxx"(vconsoleapp::run line 138)
Execute file name: C:\Program Files\SWsoft\Plesk\admin\bin\mssqlmng.exe

Can anybody help me?

 

[JackL]

Navigate to registry hive HKLM\Software\Plesk\PSAConfig\Config and increase values for 2 ADO bgining keys (try several values twice, thrice etc) and retry deletion
John S.G.

 

[digiweb]

new limits

Ok Jack,

I have increased ADO limits, this have solved the situation... thanks so much for the help...

But I have another doubt... with this new config we just gaved more time for plesk CP to do things...

Is there any other way to "boost", to speed up, deletions thru the plesk CP?

Thanks so much for the help!

 

[avsokolov]

Hello,
>Is there any other way to "boost", to speed up, deletions thru the plesk CP?
No, there is not. It depends on some things, like the domain size, number of log files, mail boxes etc.
I suppose you do not delete accounts so often