Cannot open database "SharePoint_Config" requested by the login. the login failed error

error - Cannot open database "SharePoint_Config" requested by the login. the login failed

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

Hope this helps !