Unanswered: Get error: The database is not accessible. (ObjectExplorer)
Thanks in advance for your help.
When trying to access the sql server database thru SSMS, I am getting the following message "The database SMSProductionSQL is not accessible. (ObjectExplorer)". Yet, I am able to INSERT/UPDATE/DELETE the database using an ACCESS frontend application.
I am new to SQL Administration, and am at a lost. What could possibly cause this problem? Where should I look first? I am using SQL Server 2008 Express.