• Status: Solved
  • Priority: High
  • Security: Public
  • Views: 84
  • Last Modified:

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.
1 Solution
Pawan KumarDatabase ExpertCommented:
Why dont we create logins which are not there as restore is not possible.
szadrogaAuthor Commented:
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.
Dustin SaundersDirector of OperationsCommented:
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?
Protect Your Employees from Wi-Fi Threats

As Wi-Fi growth and popularity continues to climb, not everyone understands the risks that come with connecting to public Wi-Fi or even offering Wi-Fi to employees, visitors and guests. Download the resource kit to make sure your safe wherever business takes you!

szadrogaAuthor Commented:
when I try to restore from a file (.bak) I get the following


when i try to restore from database i get the following

Mark WillsTopic AdvisorCommented:
Well, you will have problems... Due to RDS security model implementation you will not be able to restore a database from a .bak file

See : http://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/SQLServer.Procedural.Importing.html

And read the experience : https://forums.aws.amazon.com/thread.jspa?threadID=99974 you might need AWS support.

Not the answer you were hoping for but does explain the errors. You will need  to restore into an Amazon RDS DB instance
szadrogaAuthor Commented:
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?
Mark WillsTopic AdvisorCommented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Network Scalability - Handle Complex Environments

Monitor your entire network from a single platform. Free 30 Day Trial Now!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now