Friday, May 16, 2014

Error - Cannot connect to configuration database

Cannot connect to configuration database - Error


After re-installing MSQL 2012,I tried to connect the Central Admin which gave the following error :






So I ran… SharePoint 2010 Products Configuration Wizard  
I got this error while I was trying to run SharePoint 2010 Products Configuration Wizard.

Resolution :

1)      Run this command : PSConfig -cmd configdb –disconnect

2)      Make sure the account that you are using has following roles assigned in SQL  

Dbcreator , public and securityadmin roles

Go to SQL -> Security -> Logins -> UserAccount -> Right Click -> Properties -> Server Roles -> Check -> Assign the Dbcreator , public and securityadmin roles - OK

3)      open regedit (from run command) ,Navigate to HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Shared Tools\Web Server Extensions\14.0\Secure

4)      Run SharePoint 2010 Products Configuration Wizard and Re-create new farm

Creating new farm will take sometime,so have some patience ;)

Well I am not sure if Step 1 & 2 are required but I am just letting you know the drill that I followed


Additionally Tips :

·         Make sure all the SQL services are running with the account that you are using to install Sharepoint.
·         Also make sure the Sharepoint timer services are running.
·         Checking the error in Event viewer can also help, you can then google the error.

References :



or simple process would be

Please follow a general practise when your SharePoint Central Admin does not work make sure
1)    Go to run->Services.msc à SharePoint timer services are running()
2)    Go to run->Services.msc à SQL(SharePoint)  service is running
3)    Go to IIS àIn application pool – make sure Central Admin  v4 application is started

In my case the application pool wasn’t working, so I started the Central Admin v4 application pool
And TaDa ! My central admin starts working J


Hope this helps !

No comments:

Post a Comment