Link to home
Create AccountLog in
Avatar of szadroga
szadrogaFlag for United States of America

asked on

restore a sql database from .bak file but don't have permissions

The db users/logins were deleted from a db living on a SQL AWS RDS instance, so I can no longer access this db.  I wanted to restore this db from a .bak file which would bring back the users/logins.  I can't restore because I lack permissions.

I have admin access to the RDS instance, i need to create a login on a specific db so I can perform functions.
Avatar of Pawan Kumar
Pawan Kumar
Flag of India image

Why dont we create logins which are not there as restore is not possible.
Avatar of szadroga

ASKER

I can create logins, but that specific db is not listed so I cant grant permissions against that db.  I am using SSMS, and the login I use did have admin permissions to that db, but the login got deleted.
Avatar of Dustin Saunders
Do you have the exact error or a screenshot of the error that you are getting trying to do the restore?

Is your Instance in mixed mode?
when I try to restore from a file (.bak) I get the following

from-file.pdf


when i try to restore from database i get the following

from-db.pdf
ASKER CERTIFIED SOLUTION
Avatar of Mark Wills
Mark Wills
Flag of Australia image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
its fine if I cant restore from .bak file but do you know how to, at the very least add a login to this db?
Not really... In SQL Server parlance, You add logins to access the server, you add users to access the DB. I am pretty sure AWS / RDS has its own procedures. It has been ages since I played with RDS.

Read up on RDS at : http://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/UsingWithRDS.IAM.html goto security...
AWS Documentation » Amazon Relational Database Service (RDS) » User Guide » Security in Amazon RDS » Authentication and Access Control for Amazon RDS