Solved

Sharepoint 2010 reconnect front end to SQL back end

Posted on 2014-01-01
4
495 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
Comment Utility
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
Comment Utility
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 500 total points
Comment Utility
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
Comment Utility
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

IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

This article is an update and follow-up of my previous article:   Storage 101: common concepts in the IT enterprise storage This time, I expand on more frequently used storage concepts.
The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
In this Micro Tutorial viewers will learn how they can get their files copied out from their unbootable system without need to use recovery services. As an example non-bootable Windows 2012R2 installation is used which has boot problems.
This tutorial will walk an individual through setting the global and backup job media overwrite and protection periods in Backup Exec 2012. Log onto the Backup Exec Central Administration Server. Examine the services. If all or most of them are stop…

744 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

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now