Cannot access to the Central Administration. Permission problem with SharePoint_Config database

Question

I have reviewed all posts related to my issue but nothing seems to work yet.

I'm working with SHP2010 and I'm getting the classic:
Cannot connect to the configuration database while trying to connect to the Central Admin.

The LOG says:
Cannot open database "SharePoint_Config" requested by the login...

But I'm not being able to grant permissions to my user since the DataBase seems to be in a readonly state. (although I'm an Administrator)

More information:

• I've tried it with all Administrator users.
• All Windows Services are running (shpAdmin, shpTimer, all MSSQLSERVER services)
• I've restarted all services listed above and also did IIS-reset.
• I've tried to re-run Sharepoint Wizard and I'm getting same permission error.
• When I open Sharepoint 2010 Management Shell as Administrator, I have the following message: The local farm is not accessible. Cmdlets with FeatureDependencyId are not registered.
• Psconfig.exe -cmd upgrade -inplace b2b -wait -force gives me the same permission error.

Any thoughts?
Thanks in advance!
Andrés.

Answer 1

If the database seem to be "readonly" as you say, I think it may have been put in "Suspect" state after some issue occurred on the machine. When SQL Server thinks a database may have entered an invalid state, the "Suspect" state may be triggered - I had it once happen on a development virtual machine that was turn down during a web application creation and the results were the same you describe - an inaccessible Central Admin.

Try to confirm that the database is still working correctly. If this is not the case, you may want to try to recover it with some external tool. Microsoft also provides some basic recovery functions that may help in some situations, but you should have some more advanced tool ready - especially if the database contains some important data you cannot afford to lose.

Answer 2

Finally I was able to fix my problem.

Following your suggestions, I was checking if my database was in a SUSPECT mode and I realized that it was in a RECOVERY_PENDING status.

I tried a lot of things but these two post were very useful:

1. Using EMERGENCY mode to access a RECOVER_PENDING database
   
2. EMERGENCY mode, repair example
   

Summarizing:

1. Check database status:
   SELECT DBName=NAME, [Status]=state_desc FROM sys.databases
   

2. ALTER DATABASE SharePoint_Config SET EMERGENCY;
   
3. ALTER DATABASE SharePoint_Config SET SINGLE_USER;
   
4. DBCC CHECKDB (N'SharePoint_Config', REPAIR_ALLOW_DATA_LOSS) WITH ALL_ERRORMSGS, NO_INFOMSGS;
   Please note that in my case I was working in a Development Environment where there's nothing important to lose.
5. ALTER DATABASE SharePoint_Config SET MULTI_USER;
   

My Central Administration is working again! I really appreciate your help, thank you guys!