Post reply

Unable to access the database

  • May 13, 2010 at 1:57 am

    #222502

    Hi all,

    I have Sql Server 2008 sp1 enterprise edition

    When i connect to the local instance using windows authentication mode. I am able to login but unable to access the database.

    The error it throws is "The database is not accessible (object explorer)"

    I dont have privileges to login through sql server authentication

    Dear frnds please help me resolve this issue

  • May 13, 2010 at 2:28 am

    #1166698

    What's the state of the database? Query sys.databases (a view) and check the value of the status_desc column.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • May 13, 2010 at 2:39 am

    #1166703

    Status is ONLINE

  • May 13, 2010 at 2:42 am

    #1166705

    One interesting thing is i cannot find my login ID in sysusers table whereas it is available in syslogins.

    Will this help in solving the issue.

  • May 13, 2010 at 2:57 am

    #1166717

    R u having sa pwd ?

  • May 13, 2010 at 5:21 am

    #1166770

    msalmaan (5/13/2010)

    One interesting thing is i cannot find my login ID in sysusers table whereas it is available in syslogins.

    Will this help in solving the issue.

    Do u have any server roles other than public??

    Most probably u dont have and u r not mapped to any database.

    Tell ur DBA to give access to database u want..

Viewing 6 posts - 1 through 5 (of 5 total)

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