SystemCenter

All about System Center Articles and Tutorials

Fix – The SQL server name specified during setup must match the Name in sys.servers of the SQL server

Posted by on Jun 30, 2017 in SCCM, SQL

Fix – The SQL server name specified during setup must match the Name in sys.servers of the SQL server

Recently we got into a situation wherein we were trying to install a stand-alone Primary Site by running system Center Configuration Manager setup in our staging environment. The setup passed all the prerequisite checks however the installation got stuck while setting up the SQL Server database.

Below is the error message:

The SQL server name specified during setup must match the Name in sys.servers of the SQL server. For more information on how to rename SQL server, see Microsoft knowledge Base on http://microsoft.com or contact Microsoft Product Support Services (PSS) for further assistance. Click the View Log button for more information.

When we checked the ConfigMgtSetup.log file, we found the reason behind this error message.

Reason: Since we did change the server hostname after SQL Server installation, we were getting this error message.

Quick Fix: To fix this issue, we need to remove the old server name and add the new server name in SQL.

We can find the old server name and new server name in the ConfigMgtSetup.log file as highlighted in above screenshot.

Let’s fix this.

1: Login on to SQL Server and open SSMS.

2: Connect to the instance and run below query, which will remove the old server name.

sp_dropserver ‘Old Server Name’

Our case, old server name is ‘WIN-KQVMRF6K0RA’, so the query will be:

sp_dropserver ‘WIN-KQVMRF6K0RA’

The query will complete within a second and you should get Command(s) completed successfully. Message.

3: Run below query to add the new server name:

sp_addserver ‘New Server Name‘,’local’

Our case, the new server name is ‘SCCMSQL1’, so the query will be:

sp_addserver ‘SCCMSQL1′,’local’

The query will complete within a second and you should get Command(s) completed successfully. Message.

4: After executing both the queries, restart the SQL Server and run the SCCM setup again.

You need to uninstall the Configuration Manager site to start the installation.

Once the uninstallation completes, restart the SCCM server and you are good to go for the SCCM setup again.

That’s it.

Hope this helps.

Submit a Comment

Your email address will not be published. Required fields are marked *