SP central admin Cannot connect to the configuration database after reinstalling sql server 2008 r2

1
votes

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.

1
sql-server-2008sharepointsharepoint-2010

1 Answers

1
votes

Did you backup the database before reinstall it? if not, then your sharepoint database are gone. I'm afraid there is not much you can do about it.

check your database, are there databases named WSS_Content_..... and SharePoint_Config....? if there are, maybe your SP is not using the \sharepoint instance. Then, you can manually add administrator account to the database, so you can open SP site. But, from your description, this may not be the case.

Another way is: open SP management shell, run get-spcontentdatabase

does it show anything?

good luck.