"The Database <DatabseName> is not accessible. (Object explorer)" Error Message

  • Hi

    I have Db1 On my server Which has a user : User1

    When I login with this user to ssms , And Click to Database , This error message raised :

    "The Database Db1 is not accessible. (Object explorer)"

    These are my tries and All info :

    1- From This login, Is created a user to another databases , And all of them work properly.

    2- Another User From Another Login, with full access to this db (db_owner) , Cause such error : "The database ..."

    3- If a User (such as User1) be sysadmin , It Works Properly. But I dont want get this level access to this user.

    4- If I changed The database owner from sa to User1 , It works Properly . (EXEC sp_changedbowner 'User1') !!!!! , But I dont Want to do this.

    5- I backed Up , And Restore , The problem still remains. (More over I restored It on Another server : The problem Remains!!!!)

    >>>>>> Then : I think Problem is in this database , and not related to login , server , ....

    --------------------------------------------------------------------------------------

    I read from internet and did some things that they say : Offline and Online , ....

    But any of them didnt work.

    Please help me.

  • Quick thought, create the user login and grant the appropriate permissions

    😎

Viewing 2 posts - 1 through 1 (of 1 total)

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