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:
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: