Unable to Delete Database

[ballubro]

Hi,

We have created database in pleask. Now we wanted to delete that. We removed it from SQL server because we were unable to delete it from plesk. Now after deleting from sql server ,still we are unable to delete from Plesk.It Gives Following Error:

Delete database user failed: Could not locate entry in sysdatabases for database 'abc'. No entry found with that name. Make sure that the name is entered correctly.
---------------------- Debug Info -------------------------------
0: C:\Program Files\SWsoft\Plesk\admin\plib\DatabaseManagerMSSQL.php:52
DatabaseManagerMSSQL->dropUserImpl(string 'abc', string 'abc')
1: C:\Program Files\SWsoft\Plesk\admin\plib\DatabaseManager.php:175
DatabaseManager->deleteUser(object of type dbUser)
2: C:\Program Files\SWsoft\Plesk\admin\plib\class.DataBaseUsersList.php:126
DataBaseUsersList->remove(array)
3: C:\Program Files\SWsoft\Plesk\admin\htdocs\domains\databases\db_edit.php3:101

Since we are allowed to create only 4 database,whichwe have created and we want to delete 2 .But unable to do so.

 

[ally@]

in this case it is only possible to delete the entries from Plesk database

delete from data_bases where name= "databasename"
delete from db_users where db_id=X

where X is the id of the database in the table data_bases

 

[arisd]

Delete database...

ally was right - manualy delete databases from data folder and than go in plesk database and delete databasename in data_bases table - since user does not exist that's enough - but if user exists than also delete user from db_users.