Article ID: 122882, created on Sep 13, 2014, last review on Sep 13, 2014

  • Applies to:
  • Plesk 12.0 for Windows


Plesk was upgraded to 12 version. Database server settings "Grant the ALTER DATABASE permission to all Microsoft SQL Server database users" and "Assign db_backup_operator role to users" were changed, however the changes are applied only to newly created users.

How does administrator apply these settings to users that were created before the upgrade?


Plesk 12 provides the following command line option for 'mssqlmng' utility that apply users settings as per the options configured in Plesk:

"%plesk_cli%\repair.exe" --update-mssql-users-permissions

Search Words

Grant the ALTER DATABASE permission


ed7be2b984f9c27de1d2dc349dc19c6d 56797cefb1efc9130f7c48a7d1db0f0c a914db3fdc7a53ddcfd1b2db8f5a1b9c 85a92ca67f2200d36506862eaa6ed6b8 a766cea0c28e23e978fa78ef81918ab8

Email subscription for changes to this article
Save as PDF