Microsoft SharePoint and .NET Technology Insight

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


Leave a comment

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

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