April 23, 2014 at 10:57 am
Hi
We have sql server2008r2 installed on a virtual server.
Our IT Admin has given me and my collegue access to the same instance of sql server Through remote desktop.
I upsized ms access data to sql server through the id of my collegue. Now there is a problem. When I access sql server from my id, I can see the database I uploaded from my collegue's id but its locked for me. I tried to give rights to my id throuhg collegue' id but I cant find my name. Please guide me how to do since I am new to sql server.
Thank you in advance.
Asif Iqbal
April 24, 2014 at 2:09 am
What is the exact error message that you're getting?
April 24, 2014 at 6:38 am
i can't see tables/views/stored procedures etc etc
April 24, 2014 at 6:58 am
This might help you, I scripted it out. Run it through the other account where you can see the DB.
USE [master]
GO
CREATE LOGIN [domain\your_domain_account] FROM WINDOWS WITH DEFAULT_DATABASE=[master]
GO
USE [your_DB]
GO
CREATE USER [domain\your_domain_account(or any user name you pick)] FOR LOGIN [domain\your_domain_account]
GO
USE [your_DB]
GO
ALTER ROLE [db_owner] ADD MEMBER [domain\your_domain_account(or any user name you pick)]
GO
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply