Post reply

Sql Server 2008 R2 data base sharing issue

  • 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

  • April 24, 2014 at 2:09 am

    #1708342

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

  • April 24, 2014 at 6:38 am

    #1708380

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

  • 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

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply