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.
szadrogaAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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
Redefine Your Security with AI & Machine Learning

The implications of AI and machine learning in cyber security are massive and constantly growing, creating both efficiencies and new challenges across the board. Check out our on-demand webinar to learn more about how AI can help your organization!

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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
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
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
SQL

From novice to tech pro — start learning today.