Solved

Sharepoint 2010 reconnect front end to SQL back end

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

Live: Real-Time Solutions, Start Here

Receive instant 1:1 support from technology experts, using our real-time conversation and whiteboard interface. Your first 5 minutes are always free.

Question has a verified solution.

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

David Varnum recently wrote up his impressions of PRTG, based on a presentation by my colleague Christian at Tech Field Day at VMworld in Barcelona. Thanks David, for your detailed and honest evaluation!
In 2017, ransomware will become so virulent and widespread that if you aren’t a victim yourself, you will know someone who is.
To efficiently enable the rotation of USB drives for backups, storage pools need to be created. This way no matter which USB drive is installed, the backups will successfully write without any administrative intervention. Multiple USB devices need t…
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…

808 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