- You receive a "Cannot connect to the configuration database"
- Service Unavailable
Suddenly while you are in the middle of your important SharePoint deployment or configuration, either of these issues will prop up and eat up lengthy hours. Even the easiest solutions to all SharePoint problems i.e. IISReset or Server restart also do not end your miseries.
Hence, I decided, lets apply TRY-CATCH-FINALLY on these issues for once-n-for-all here.
Try to run the SharePoint configuration wizard once, follow these steps for the same:
- Is your SQL server agent running?
- Credentials (app pool permissions) used for connecting to SQL Server is working or failing?
- Facing any network issues to be able to connect to DB?
(this only applies if the SQL is applied on a separate box from MOSS 2007)
- so on..
If even after carrying out the above suggestions, you are not able to track down the problem, then you could unprovision Central Administration and then reprovision it.
This could be easily done via an STSADM command given below:
|stsadm.exe -o provisionservice -action start -servicetype Microsoft.SharePoint.Administration.SPWebService -servicename WSS_Administration|
I sincerely hope this helps you all in fixing this critical MOSS 2007 Central Administration issue.