I receive permissions errors when attempting to access a database I created on an RDS SQL Server DB instance. In addition, the master user no longer has database owner privileges to the database, effectively blocking all access to the databases.

If a user inadvertently removes the master user and all SQL logins they have created from the db_owner role of their databases, accounts are unable to add any user to the db_owner role for the user's databases, effectively blocking all access to the user's databases.

If a SQL login other than the master user creates a database and the SQL login is subsequently deleted or disabled, all access to the database can be blocked because SQL Server does not add the master user to the db_owner role for databases created by other users. If another user was previously added to the db_owner role for databases created by the deleted or disabled SQL login then this user can grant appropriate access to other users.

Reset the master user password. This adds the master user to the db_owner role for all user databases on the RDS SQL Server DB instance.

When performing a reset of the master user password, it is not necessary to change the password; resetting the master user password updates user database permissions regardless of the password that is specified. For more information, see Resetting the db_owner Role Password.

Note
It may take a few minutes for the password reset process to take effect.

Amazon RDS, SQL Server instance, permissions, blocked access, db_owner role, master user, access denied


Did this page help you? Yes | No

Back to the AWS Support Knowledge Center

Need help? Visit the AWS Support Center.

Published: 2015-11-03
Updated: 2015-11-09