Adding a SharePoint 2013 Server To A Farm

Adding additional servers to a SharePoint farm provides the flexibility of role assignments per server within the SharePoint farm as well as high availability for servers that are running the same services. For example having two servers running Excel Services increases the availability (and performance) of the farm as both servers would be used by the users and load balanced internally by SharePoint.

Adding The Second Server

First ensure the second server is ready and available up to OS level and Windows Server patching is applied.  Next ensure that it is part of the same domain as the first SharePoint server and that the setup account (SPSETUP in our example) account is a local administrator on this server.

Install the Pre-Requisites and Binaries

Install SharePoint pre requisites and run the SharePoint Setup Program.  The server may require a couple of reboots during the installation.  Once complete install the binaries.

Select Install SharePoint Server

image

Enter license key and accept license agreement and select “Complete” to install the SharePoint binaries onto the server.

image

Once this process completes you can run the configuration wizard.

image

Click Next and accept the warning message by clicking yes.

image

Leave the default option selected and click next.

image

Enter the database server name and click Retrieve Database Names.

This should make a connection back to the database server and allow you to select the SharePoint_Config database.  If it cannot access SQL Server then ensure there are no firewalls blocking access.  If the firewall is on you can use this script on the SQL Server host server to ensure connectivity :-

netsh advfirewall firewall add rule name="Open SQL Server Port 1433" dir=in action=allow protocol=TCP localport=1433

image

Enter the passphrase you used when creating the first SharePoint server.

image

if you have forgotten your pass phrase then it can be reset easily on the main SharePoint server using the SharePoint PowerShell Module as shown here. and the Set-SPPassPhrase commandlet.as shown here.

image

Check Summary and continue.

image

The advanced settings here allow you to run the Central Admin site on this new server.  We have selected to NOT host Central Admin on this server also for our exercise.  In order to make the CA site highly available (running on more than one server) then select the option to “use this machine to host the web site.”.  However you would need to configure access mappings or a proper URL for the CA site.  I may cover this in the future.

image

Await the completion of the configuration

image

image

Central Admin will now open.  If not log onto the CA site from the original server and we can now see and configure the farm.

If we look at System Settings, Servers in Farm we can see both servers SharePointDemo and SharePointDemo2.

image

We can also see that only the basic core services are running on the new server.

Configuring Services on the second SharePoint Server

From Central Admin select, System Settings, Manage Services on server.

Select change Server where the server name is displayed (top right).

image

Select the server to change to (we will click SharePointDemo2)

image

Now we can see all services running on this server.  So if we want to run a service on this server we simply click start next to the service that is stopped.  Here we will start the Word Automation Service.

image

Other services such as Excel Services, Visio Graphics and more can be started up in this way on any additional SharePoint servers.  Services which require an installation process such as PowerPivot, SSRS / Power View will need to be installed first and configured.  We will cover this in the BI services section.

Add Secure Store Service and Configure an Application ID

To add the secure store service start the service.

Also you will note the application event log message on the new SharePoint server.

Event ID “7535, Secure Store Service”…failed to retrieve the master secret key. The error returned was: ‘Unable to obtain master key; “

image

From Central Admin, go to manage service applications and click manage on the Secure Store application and the “Unable to obtain master key” error is displayed (just like it was when adding the first server).

image

In order to join the new server and configure the Secure Store service correctly select Refresh Key.

Enter the passphrase which was used when creating the Secure Store service. 

image

Once complete the following screen should appear.

image

While we are here lets create a secure store application ID which we can use later in Excel Services when we do the BI section.

Click New enter the application ID name and display name.

image

click Next

Enter the account details of the Domain user account that will be used as the unattended account.

image

Note: The password will be shown on screen, i have just put in some *’s for the screenshot !

Enter the administrator accounts who can manage the secure store credentials.  I would recommend creating a SharePoint Admins group or groups for different environments to provide this type of access within SharePoint.

image

We should now see the application ID we created. 

image

The credentials we provided here (unattended account) can be used to provide access to backend data sources for example when users do not have direct access.

Create our Web Application, Site Collection and Web (aka Site).

Each Web Application can host many site collections and site collections can host many Webs.  Note the term Web is used to reference a site or the entity which sits in IIS.  Each Web Application can have multiple databases.

A database can contain many site collections.  A site collection can only exist in one database.

Separate site collections can be create for users and business areas that require security isolation.

Here we will get on with the task of create a web so users have something to work with.  We will use the Enterprise BI template and create web application followed by a Site Collection.  We will also give the site a proper URL AND make it highly available in that it will run on two servers.  The webs would run on servers allocated to the Web Front End role in any production architecture meaning that these servers will not host application roles such as Excel Services etc.  

Creating the BI Site

First create a DNS Alias and register the application pool account.

We will use the URL http://BI.demo.local and the demo\SPBISvcApp domain account for the application pool.  We will also use Kerberos authentication as opposed to NTLM in order to allow us to fully utilise the BI features.

In DNS I have created a simple A record.

image

This would generally be the IP address of a load balancer. The load balancer would be configured to respond to this URL and send it to the Web Front End servers.  Windows Server has it’s own load balancing services which could be used here but generally a hardware load balancer is used as they are more sophisticated in that they can check for certain conditions and strings in a web page for example.  The Windows NLB can only check for pings.  This would not help if the server was well but IIS had hung for example.

Add the managed account if not already done.

From Central Admin, Security, Configure Managed Accounts.  Check to see if your BI service account is included, if not add it now.

image

Back to Central Admin, Web applications, Manage Web Applications

image

Create New Web Applications, click new.

Create a new IIS web site, Enter a name for it, and enter the host header which should match the A record in DNS. 

image

Select Kerberos for the authentication method.

image

Leave sign in page and public  URL as default.

image

Enter the New App Pool Name, check service account and rename the database to something more sensible than the default WSS_Content.

image

All other settings can be left as default including the proxy groups.

Wait for the Web App to be created

image

image

Now that the site web app is created we can create the site collection which is a container for the individual webs.

Click on the Create Site Collection link or if you have closed it from Central Admin, Create Site Collections.

Enter a name

image

Use Define Managed Paths to create a subsite link rather than top level.  Ours will be a top level bi.demo.local rather than bi.demo.local/SITENAME.

image

Enter two administrator accounts and click OK.

image

Successful.

image

Clicking on the link should open up the site. It may take a while..Enter the login details of the setup or farm account.

and Voila

image

About Mitesh Chauhan
Mitesh Chauhan, Principal Infrastructure Consultant. This is my blog where I will be sharing articles and thoughts on IT Infrastructure and architecture. The topics I am most passionate about are Implementation and architecture of SQL Server, Windows Server both physical, virtual and using IaaS cloud services such as Microsoft Azure. MCSE Server Infrastructure (Windows Server 2012) , MCITP SQL Server 2008, Togaf Certified, Prince 2 Practitioner.

5 Responses to Adding a SharePoint 2013 Server To A Farm

  1. Daniel says:

    HI Mitesh,
    Thank you posting this article. I am in the process of setting up a Stretched Environment from our existing three tier environment. HA and Always-On are the primary reasons for setting up the stretched environment. Currently, I have two WFE servers which are being load balanced, one SharePoint 2013 App server and one SQL 2012 SP1 server. After I am done, I plan on have two SharePoint 2013 servers and three SQL servers.
    As you stated in your article, “In order to make the CA site highly available (running on more than one server) then select the option to “use this machine to host the web site.”. However you would need to configure access mappings or a proper URL for the CA site. I may cover this in the future” What are the Access Mappings or Proper URLs for the CA site?
    Thanks in advance.

    • Mohd Faisal says:

      Hello Daniel,
      You may configure the Central admin site on 2 servers for redundancy. The CA can be provisioned using the PSConfig wizard or through the Powershell. Once you have the CA setup you would notice in the AAM that the site is accessible through the server name. you can now create a load balenced A record in DNS and configure AAM and IIS host to use that host instead of the server name. You now have a load-balanced URL for CA.

  2. Axl says:

    Hi Mitesh, I enjoyed your SharePoint 2013 articles, guidelines, and explanations. They are loaded with great information and setup tips! Your style combines real world experience and deep understanding with best practices. Will you be updating this blog with the BI services section soon? I hope so, looking forward to it, specifically PowerPivot and SSRS / Power View installation and configuration. Thank you!

    “Services which require an installation process such as PowerPivot, SSRS / Power View will need to be installed first and configured. We will cover this in the BI services section.”

  3. Thanks for this great post

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Follow

Get every new post delivered to your Inbox.

%d bloggers like this: