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 :

http://answers.flyppdevportal.com/categories/sharepoint2010/sharepoint2010setup.aspx?ID=b7ba6c51-3248-4dc2-a476-49cdd4267210

http://technet.microsoft.com/en-us/library/ee662513(office.14).aspx

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 !