I have just re-installed SQL Server 2008 R2 in my Windows Server, but after installing the SQL Server, I am unable to open my central admin. On opening the central admin its showing me the message -

Cannot connect to the configuration database

I am unable to open any of my site collection too. On opening a site collection its showing

Cannot connect to the configuration database. Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: Microsoft.SharePoint.WebPartPages.WebPartPageUserException: Cannot connect to the configuration database.

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:

[WebPartPageUserException: Cannot connect to the configuration database.]
Microsoft.SharePoint.ApplicationRuntime.SPRequestModule.EnsureInitialize(HttpRequest request) +740
Microsoft.SharePoint.ApplicationRuntime.SPRequestModule.BeginRequestHandler(Object oSender, EventArgs ea) +164
System.Web.SyncEventExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +80 System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +171

I have checked my SQL Server configuration manager and there is no sharepoint instance there too, I am afraid if my sharepoint db has been deleted. If yes, then is there anyway to restore it and how to make my sharepoint site collection and central admin up and running. Any help will be appreciated.

  • Do you have anything under C:\Program Files\Microsoft SQL Server\MSSQL10_50.SQLSERVER\MSSQL\DATA? Or wherever your Master db is stored in your new install? (Right click on it, properties, Files, and scroll to the right a bit to see the path)
    – lgaud
    Commented Apr 18, 2013 at 14:11

1 Answer 1


I think you should:

  • attach your configuration database to sql server (located at "C:\Program Files\Microsoft SQL Server\MSSQL10_50.SQLSERVER\MSSQL\DATA") manually,

  • And run "SharePoint 2010 Products Configuration Wizard"

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.