Monday, June 15, 2026
type here...
CM InfrastructureSCCM InstallationSCCM Infrastructure

ERROR SQL server Name Hostname in sys.servers does not match with the SQL server name

By Haresh Hirani
0
765

I will be sharing details about while configure new build getting error which was causing to complete CM Current branch installation.

Issue reported:

ERROR SQL server Name Hostname in sys.servers does not match with the SQL server name.


ConfigMgrSetup.log

INFO: Getting SQL’s server name from sys.servers on ABC.DEMO.COM.             

Configuration Manager Setup        12/28/2018 3:19:44 PM     7604 (0x1DB4)

ERROR: SQL server’s Name ‘[ABC]’ in sys.servers does not match with the SQL server name ‘[ABC]’ specified during setup.

Please rename the SQL server name using sp_dropserver and sp_addserver and rerun setup. Configuration Manager Setup 

12/28/2018 3:19:44 PM     7604 (0x1DB4)

ERROR: The SQL Server name verification with Name in sys.servers failed, exiting Configuration Manager setup.

Configuration Manager Setup        12/28/2018 3:19:44 PM          7604 (0x1DB4)

Not recovery mode or not top level site. Skip restoring client piloting packages.

Configuration Manager Setup        12/28/2018 3:19:44 PM     7604 (0x1DB4)

Completed Configuration Manager Server Setup:

Configuration Manager Setup        12/28/2018 3:19:44 PM              7604 (0x1DB4)


Solution :

Normally above error will report once you have rename server Hostname after SQL installation.

Point 1: Based on above error verified Hostname of the server which was before rename.

Point 2: Uninstall all sql entries from control panel

Point 3: Replace old server entry to new in all the registry where it was create

Point 4: Reboot and reinstall SQL server with require configurations

Point 5: Start fresh CM installation and it was successfully completed. 

Happy Learning!!!!

Thanks&regards,
Haresh Hirani
Email: [email protected], [email protected]
Facebook https://www.facebook.com/Hiraniconfigmgr-120189361980772/
Follow us: https://www.linkedin.com/in/hiraniconfigmgr 
Twitter: https://twitter.com/hiraniconfigmgr

Author

  • Hi, I’m Haresh Hirani the mind behind Hiraniconfigmgr.com. I’m a seasoned IT professional with deep expertise in Microsoft technologies, especially in Configuration Manager (ConfigMgr/SCCM). Over the years, I’ve expanded my skill set to cover a broader range of modern device management platforms like Microsoft Intune, Jamf Pro, ManageEngine Endpoint Central, and VMware AirWatch (Workspace ONE UEM), I use this blog to document real-world, tested, working fixes and walkthroughs from my daily technical experiences. The 💡idea is simple: if it helped me, it might help someone like you. My goal is to create a living repository of practical IT solutions for the community. If you find something useful, or if you want to collaborate, feel free to connect with me on LinkedIn or drop a message through the Contact page. Happy to help.

Previous article
SCCM SCCM backup is getting failed with error sql backup did not complete or abort resolved
Next article
After Upgrade SQL 2016 Report service error failed to load expression host assembly

LEAVE A REPLY

Please enter your comment!
Please enter your name here

Search

Latest posts

I’m the person behind this webpage. Thank you for visiting the website and about me page! My website is all about Microsoft technologies. More about ConfigMgr and all other technologies which are interesting for me. However, larger percentage of my posts are related to SCCM. Normally, like to post the interesting issues which I came across in my day to day tech life. you will find only solutions which comes on my day to day life.

Hot Category

Popular Post

© COPYRIGHT Hiraniconfigmgr.com

Developed By : Deepcoder