Sql Server 2008 R2 data base sharing issue

• asif iqbal-205136

  Grasshopper

  Points: 12

  More actions

  April 23, 2014 at 10:57 am

  #306902

  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

• Beatrix Kiddo

  SSC-Dedicated

  Points: 32407

  More actions

  April 24, 2014 at 2:09 am

  #1708342

  What is the exact error message that you're getting?

• asif iqbal-205136

  Grasshopper

  Points: 12

  More actions

  April 24, 2014 at 6:38 am

  #1708380

  i can't see tables/views/stored procedures etc etc

• deepforest

  SSCommitted

  Points: 1780

  More actions

  April 24, 2014 at 6:58 am

  #1708389

  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