Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Sharepoint 2010 reconnect front end to SQL back end

Posted on 2014-01-01
4
Medium Priority
?
548 Views
Last Modified: 2014-01-02
I have a simple SharePoint environment with a SharePoint 2010 front end and a dedicated SQL back-end. Both virtualized machines running on Hyper-V 2008 R2 host. There are no complicated apps - it is just a file serving SharePoint implementation.

The VHD for the front end server (it only had one drive) got corrupted. I have a Hyper-V export of the complete front end server from the 29th December, including the VHD.

The back end (SQL and all the databases) is unaffected, all the databases are there running happily.

I tried creating a new VM with the three day old VHD from the export, but it does not seem to correctly connect to the back end. The server starts, the Central Administration site runs, the only errors in the event log are Gatherer 114 errors. Central Administration says the databases are started. The websites are all running. I have recycled the application pools and reset IIS.

How to reconnect the front and back end please?
0
Comment
Question by:Carol Chisholm
  • 2
  • 2
4 Comments
 
LVL 17

Expert Comment

by:lruiz52
ID: 39750105
If you can access the central admin page it means you are connected to the backend SQL database sharepoint_config.


Gatherer 114 has to do with search gather host, check link below for possible solution.
http://technet.microsoft.com/en-us/library/ee513100(v=office.14).aspx
0
 
LVL 16

Author Comment

by:Carol Chisholm
ID: 39750138
But none of my sites are available :)
I'm not that worried about search, but I do need to see my sites.
0
 
LVL 17

Accepted Solution

by:
lruiz52 earned 2000 total points
ID: 39750155
On central admin, check your content databases for your web applications and verify that they are attached.

i) Browse to Central Administration -> Application Management -> Manage Content Databases.

If there not connected, check the link below to re attach.

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

http://www.sharepointpitstop.com/2012/06/attachdetach-sharepoint-webapp-contentdb.html
0
 
LVL 16

Author Comment

by:Carol Chisholm
ID: 39750928
In fact I took the back end out of the domain and then re-joined it and everything started working.
Note that this is an unsupported solution.
0

Featured Post

Automating Your MSP Business

The road to profitability.
Delivering superior services is key to ensuring customer satisfaction and the consequent long-term relationships that enable MSPs to lock in predictable, recurring revenue. What's the best way to deliver superior service? One word: automation.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

August and September have been big months for VMware—from VMworld last month to our new Course of the Month in VMware Professional - Data Center Virtualization. We reached out to Andrew Hancock, resident VMware vExpert, to have a more in-depth discu…
Mailbox Corruption is a nightmare every Exchange DBA wishes he never has. Recovering from it can be super-hectic if not entirely futile. And though techniques like the New-MailboxRepairRequest cmdlet have been designed to help with fixing minor corr…
This tutorial will walk an individual through locating and launching the BEUtility application and how to execute it on the appropriate database. Log onto the server running the Backup Exec database. In a larger environment, this would generally be …
This tutorial will walk an individual through locating and launching the BEUtility application to properly change the service account username and\or password in situation where it may be necessary or where the password has been inadvertently change…

916 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question