Solved

Sharepoint 2010 reconnect front end to SQL back end

Posted on 2014-01-01
4
525 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 500 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

Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
vRealize Operations Manager - Oversized VMs Report 2 84
Error upgrading from esxi 5.5 to 6.5 15 227
Remote access to ESXi 6 free with USB modem 5 56
Planned failover 6 15
It Is not possible to enable LLDP in vSwitch(at least is not supported by VMware), so in this article we will enable this, and also go trough how to enabled CDP and how to get this information in vSwitches and also in vDS.
In 2017, ransomware will become so virulent and widespread that if you aren’t a victim yourself, you will know someone who is.
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…
How to install and configure Citrix XenApp 6.5 - Part 1. In this video tutorial we have explained step by step installation of Citrix XenApp 6.5 Server on Windows Server 2008 R2 is explained in this video. We have explained the difference between…

820 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