SharePoint 2010 Installations: Adding a second server to an existing SharePoint Server Farm

As many of you know, I’ve been working on building some hosted SharePoint 2010. I’m also trying to determine exactly what each service account needs rights/permissions to. I’ll have more on the specifics of the service accounts in an upcoming post, but the main service accounts I currently have are:

  1. Install account
  2. Farm account

The Install service account is what I use to run the SharePoint 2010 installation and configuration wizard.

The Farm service account is the account I use for app pools and database connectivity.

When you setup the configuration wizard this way, your configuration database is created by the farm account you specify, while the admin database is created with the install account. This doesn’t cause problems… until you try to connect a second SharePoint Server to the farm.

The Problems:

If you click the Retrieve Database names button you should get the following error:

Cannot find an existing configuration database located at the specified database server. Please choose a different database server.

If you type in the database name and click next, you should get the following error:

Failed to connect to the existing server farm located at the specified database server and database name. The database name is not a valid configuration database.

The Root Cause of The Problems:

The install service account you are using to run the configuration wizard on the second server has no rights to the configuration database that was created by the farm account during the first server install.

The Quick Fix

I went through to try and give minimal rights to allow the configuration wizard to pass, but only full rights works. To continue moving through the SharePoint 2010 configuration wizard, you must give the install service account db_owner rights/permissions.

VN:F [1.9.22_1171]
Rating: 9.6/10 (5 votes cast)

About Fpweb.net Crew

Our business is centered on bringing enterprise-class strategy, support, and security to your hosted or managed platforms no matter where you choose to deploy your environment. We specialize in providing managed services, cyber security, and expert, USA-based, 24/7 Absolute Support® on-premises, or in any cloud.
This entry was posted in SharePoint Tips & Tricks and tagged , , , . Bookmark the permalink.

5 Responses to SharePoint 2010 Installations: Adding a second server to an existing SharePoint Server Farm

  1. Ardiseis says:

    I am Having the same issue as listed above please see thread
    http://social.msdn.microsoft.com/Forums/en-US/sharepoint2010general/thread/c145ada4-8532-41d2-888d-df672a97ca82/?prof=required

    What service settings are you talking about in your post I am in a 2 server enviroment and the windows installer service runs as local system account how would I give it permission on the second server?

  2. rohan says:

    Hello Chris,

    I have a query , I got an error while testing the MOSS 2007 CU updates on their test environment. I just need your expertise on this issue, it would be very helpful for me while troubleshooting further.

    Test Environment- Server – windows 2003, MOSS 2007 sp2, aug-2011 CU update

    WSS and MOSS patches(CU updates-2011-aug) were installed but the SharePoint Wizard failed. From our investigation, the configuration database is where the patching failed and the web server became disconnected to the farm. We tried to connect it back but the configuration database looks to have become corrupted.

    The error message is : Failed to connect to the existing server farm located at the specified database server and database name. The database name is not a valid configuration database.

  3. Tom Cox AA says:

    This issue can also be caused by missing stored procs caused by using Sql Server Intregrated Services SSIS. Copy the Stored Procs to the DB and try again.

    God Bless You.

  4. SharePoint 2010 Server Installations: Adding an existing configuration database to a SharePoint farm, ended up being a perfect blog title to give this article.
    Where exactly could I actually learn more pertaining to this?

Leave a Reply

Your email address will not be published. Required fields are marked *

Let's make sure you're human first: *