Skip to content
By using AWS re:Post, you agree to the AWS re:Post Terms of Use
AWS re:Postre:Post
About re:Post

SQL Server on RDS

0

I accidently deleted the rds admin user on a database (not the server instance). If i issue USE [database_name] I get Msg 916, Level 14, State 2, Line 1 The server principal "rdsadmin user" is not able to access the database "database_name" under the current security context.

Now I can't delete or restore the database. How do I delete it? All other databases are running fine and the rds admin have access.

Topics
Database
Tags
Amazon RDS for SQL Server
Language
English

asked 2 years ago359 views

1 Answer
1
Accepted Answer

I think the procedure explained in this document article should fix the issue: https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/Appendix.SQLServer.CommonDBATasks.ResetPassword.html

EXPERT

answered 2 years ago

EXPERT

reviewed 2 years ago

EXPERT

reviewed 2 years ago

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Relevant content