Why do I receive the error "Server Name Mismatch. The server was identified as 'server2' in SQL server. 'server1' was entered as the server name on this form; please resolve the issue and then try again." when attempting to install or upgrade the Interface Engine?

Version

Interface Engine 8.x, 9.x

Problem

During the installation or upgrade of the Interface Engine, the following error may occur:

The server was identified as 'xxxxxx' in SQL server.
'yyyyyyy' was entered as the server name on this form;
please resolve the issue and then try again.

Cause

This issue occurs when the server name entered on the Interface Engine installation form does not match the server name recorded in SQL Server.

A common cause is that the Windows computer name for the server was changed after SQL Server was installed. SQL Server does not automatically update its internal server name when the underlying computer name is changed, leading to the mismatch.

Resolution

1. Reference the Microsoft article “Rename a Computer that Hosts a Stand-Alone Instance of SQL Server” for detailed instructions on how to change the server name within SQL Server so that it matches the current computer name.
2. Update the server name in SQL Server according to Microsoft’s guidance.
3. After the server name is updated, restart the SQL Server service to apply the change.
4. Once the SQL service has been restarted, re-run the Interface Engine installation or upgrade.

Important Notes

• These steps should only be performed by a qualified SQL database administrator.
• This fix has been tested and confirmed to have no negative impact on Solution Series connectivity or functionality.
• However, before making any changes in SQL Server, it is the responsibility of the SQL database administrator to:
  • Assess the impact of the change on any third-party applications or dependencies, and
  • Proceed only if it has been confirmed that no third-party dependencies will be adversely affected by updating the server name in SQL Server.