none
The database is not accessible (ObjectExplorer)

    Question

  • Hi,

    i have several database all are working fine except only one database.
    i am getting following error message when try to open and access database using management studio.

    The database is not accessible (ObjectExplorer)

    my database storage on SAN. database is not listed under user mapping. please tell how to fix this.

    thx.

    iffi

    Thursday, March 08, 2012 6:03 AM

All replies

  • Do you have relevant permission to manage that database ? If not add your account to SQL Security.

    Murugesa Pandian.,MCTS|App.Devleopment|Configure

    Thursday, March 08, 2012 8:25 AM
  • hi,

    i have all permission. when i expand user mapping under user login for user, specified database is not listed.


    iffi

    Thursday, March 08, 2012 9:36 AM
  • Hi,

    If you have permission try to 

    1- bring it off line and then bring it online

    2 - or deattach the database and attach it again


    Regards, Fadi Abdulwahab. http://blogs.msdn.com/b/fabdulwahab http://sqlgoogler.blogspot.com/ Please click "Propose As Answer" if a post solves your problem or "Vote As Helpful" if a post has been useful to you

    Thursday, March 08, 2012 9:57 AM
  • this is surely a permission issue, i believe you are using a SQL Login to connect to database instance

    you need to check with you administrator for permissions

    if its not under user mappings then user needs to be created.

    "my database storage on SAN. database is not listed under user mapping. please tell how to fix this"

    Thursday, July 05, 2012 10:15 AM
  • I had the same problem. Have found the solution:

    1. Take offline

    2. Take online

    It helped me.

    Sunday, August 05, 2012 3:11 PM
  • Had the same issue (SQL 2012, Availability Group Setup).

    Taking it offline and online again solved the issue.
    Had to remove it from the AG first.

    Friday, June 13, 2014 8:25 AM