• 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.
0
szadroga
Asked:
szadroga
1 Solution
 
Pawan KumarDatabase ExpertCommented:
Why dont we create logins which are not there as restore is not possible.
0
 
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.
0
 
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?
0
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

from-file.pdf


when i try to restore from database i get the following

from-db.pdf
0
 
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
0
 
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?
0
 
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
0
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