Microsoft SharePoint and .NET Technology Insight

SharePoint, .NET, Office365, Windows Azure, TFS, Project Server and SQL Server Technology Insights

Adding a new Server to a SharePoint 2013 Farm and SQL Alias

Leave a comment

I recently had a requirement to add a new server into an existing SharePoint 2013 on-premises server Farm and ran into the following issue while running the SharePoint Products Configuration Wizard on the new server:

JuneBlogPicture1

Some blogs suggested running the PowerShell Disable-SPSessionStateService on the existing farm to resolve the issue. However, this change did not work for me. I noticed that the new server being added to the existing farm was missing a SQL Alias definition.

The issue was resolved by creating a SQL Alias on the new server using the commands below followed by running the SharePoint Configuration Wizard again:

JuneBlogPicture2

 

Advertisements

Author: Arsh

SharePoint Architect

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