Symptoms
Copying a MSSQL database in Domains > example.com > Databases > example_db > Copy fails:
Unable to clone database.
The following error is logged into the file
%plesk_dir%adminlogsphp_error.log:ERR [panel] Task failed: id=1615, pid=25416, type=db-clone, error=dbbackup failed: Unable to copy database 'example_db' to database 'example_db_clone''
Script transfer failed.
Script failed for Server '.MSSQLSERVER2014'.
Property TextHeader is not available for StoredProcedure '[dbo].[stored_procedure_name]'. This property may not exist for this object, or may not be retrievable due to insufficient access rights. The text is encrypted.(Error code 23)
After the backup process, the following error is shown in Tools & Settings > Backup Manager :
Warning:domain "example.com" Unable to backup database content. Database example_db. Db server .MSSQLSERVER2014:[Cannot open database "example_db" requested by the login. The login failed. Login failed for user 'NT AUTHORITYSYSTEM'.]
Cause
The database contains encrypted procedures, which are not supported by Plesk.
This has been reported as bug ID PPPM-5693.
Resolution
Currently, the only solution is to avoid using encrypted procedures in the MSSQL databases.
