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.
- Moved by Jinchun ChenMicrosoft employee, Moderator Monday, April 02, 2012 9:31 AM (From:SharePoint 2010 - Setup, Upgrade, Administration and Operation)
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
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"