Unable to remove MSSQL database from both Plesk and remote MSSQL server after migration of subscription to Plesk 12.0.18. Source and destination Plesk are connected to the same remote MSSQL server. Database is removed only from Plesk.
This issue has been considered as software issue #PPPM-3431 and will be fixed in future product updates. Please use provided ID to track maintanance in Plesk release notes.
Database can be correctly removed under
Plesk > Tools & Settings > Database Servers > click on the number of databases under Databases column > Remove
Create backup of
"%plesk_dir%\mysql\bin\mysqldump" -uadmin -p"*******" -P8306 psa > C:\psa.bk.sql
Login to psa database:
"%plesk_dir%\mysql\bin\mysql" -uadmin -p"*******" -P8306 psa
Find list of domains is that has
select d.id,d.name,dp.param,dp.val from domains as d, dom_param as dp where d.id=dp.dom_id and dp.param='disable_remote_db_remove' group by id;
psadatabase for all domains:
delete from dom_param where param='disable_remote_db_remove';