- Plesk 12.0 for Windows
- Plesk 12.5 for Windows
After migration to Plesk 12, the access rights to databases have changed: a newly created user does not have
Since Plesk version 12 MSSQL users created through Plesk interface are not provided with
role for security reasons.
Use either of the following methods to resolve the issue:
Go to Tools & Settings > Database Servers > Settings and enable
Grant the ALTER DATABASE permission to all Microsoft SQL Server database usersoption.
%plesk_dir%\\bin\\server_pref.exe --update -grant-alter-database-to-mssql-users true
Note: to fix permissions and roles of all MS SQL users, run the following command: