Skip to content
Trending
Simplify Windows Devices to Run Only the Required Applications using Intune Enhance macOS Compliance with Custom Security and Compliance Checks to Improve Device Security using Microsoft Intune Manage Samsung Galaxy Firmware Versions to Improve Security and Compliance using Microsoft Intune MS Intune Adds Windows Registry Data Collection to Device Inventory for Single Values All Key Values and Subkeys Updated Windows Device Sync Experience Enhances Per-Device Troubleshooting Configure Windows Sandbox vGPU Policy using Intune for Better Graphics Performance or Reduced Attack Surface Simplify Windows Devices to Run Only the Required Applications using Intune Enhance macOS Compliance with Custom Security and Compliance Checks to Improve Device Security using Microsoft Intune Manage Samsung Galaxy Firmware Versions to Improve Security and Compliance using Microsoft Intune MS Intune Adds Windows Registry Data Collection to Device Inventory for Single Values All Key Values and Subkeys Updated Windows Device Sync Experience Enhances Per-Device Troubleshooting Configure Windows Sandbox vGPU Policy using Intune for Better Graphics Performance or Reduced Attack Surface
SCCM Clustered DB Migration to Single Instance SQL

SCCM Clustered DB Migration to Single Instance SQL

Written By Anoop C Nair
Last Updated July 30, 2024
Posted In SCCM
SHARE

SCCM Clustered DB Migration to Single Instance SQL ConfigMgr Endpoint Manager. In this post, I’m trying to explain my experience with SCCM ConfigMgr central Server SQL DB migration.

We had migrated SCCM ConfigMgr 2007 central site DB from SQL 2005 to SQL 2008 R2 and changed the SQL DB server from a clustered instance to a single instance.

Also, the ConfigMgr SCCM DB server is moving from a physical box to a virtual one. So, we don’t need clustering for a virtual box; VMware VMotion takes care of the SQL server’s redundancy.

Along with the SCCM ConfigMgr 2007 central Database, we need to move the WSUS database and SSRS. This adds to the complexity of this movement. Moving SCCM 2007 DB is documented over here by Sudheesh N.

Patch My PC

SCCM Clustered DB Migration to Single Instance SQL ConfigMgr Endpoint Manager

Once migration is completed as per the document, you need to verify and confirm the sitecomp.log file to see if the following entry is present. Once the next entry is there, you can restart the SCCM 2007 central site server and remote site system servers (Remote MPs, DPs, or SUPs—if required).

Synchronization complete

SCCM Clustered DB Migration to Single Instance SQL - Fig.1
SCCM Clustered DB Migration to Single Instance SQL – Fig.1

SCCM WSUS database (software update) move and remote SUP server reconfiguration have been completed by changing the following registry key in the remote SUP server.

Navigate to HKLM->Software->Microsoft->Update Services->Server->Setup ==> Edit SqlServerName Key and provide new SQL server and Instance name.

SCCM Clustered DB Migration to Single Instance SQL

After following the documented process, I got stuck with SCCM console connectivity issues, which are explained in the following blog post: I cannot connect to the site database after it’s moved to a failover cluster. When I tried to launch the SCCM ConfigMgr console after migration, I got the following errors in SmsAdminUI.log and Smsdbmon.log !!

SmsAdminUI.log
The ConfigMgr console could not connect to the ConfigMgr site database. Verify that this computer has network connectivity to the SMS Provider computer and that your user account has Remote Activation permissions on both the ConfigMgr site server and SMS Provider computers. For more information, see “How to Configure DCOM Permissions for Configuration Manager Console. The ConfigMgr Provider reported an error.
Smsdbmon.log
CTriggerManager::Init – unable to get SQL connection
*** [28000][18456][Microsoft][ODBC SQL Server Driver][SQL Server]login failed for user ‘NT AUTHORITY\ANONYMOUS LOGON’
*** Failed to connect to the SQL Server.

SCCM Clustered DB Migration to Single Instance SQL

As mentioned in the above post, these errors pointed to the SPN registration issue. My SQL 2008 Database SQL Server (MSSQLSERVER) service runs with a domain service account.

SPN registration commands – SCCM Clustered DB Migration to Single Instance SQL

This SQL 2008 service account is already registered to Active Directory SPN (Service Principal Name) using the following commands. So, the SQL service account pointed to the correct hostname and FQDN along with the 1433 port of the SQL server.

setspn -A MSSQLSvc/ACNSQL2K8DB:1433 ConfigMgr\svc_SQLSERVICEACCOUNT
setspn -A MSSQLSvc/ACNSQL2K8DB.ConfigMgr.com:1433 ConfigMgr\svc_SQLSERVICEACCOUNT

So what is the issue now? Resolution. There is no need to worry about SCCM ConfigMgr SQL clustered instance DB to single instance SQL DB. The SCCM repair or reconfiguration wizard will take care of this complexity. I need to remove the old SQL DB site system roles (there must be two DB site systems roles because of clustered instances).

Simple resolution for complex problems:) I hope this helps !!

When I checked the old SCCM ConfigMgr SQL 2005 DB, it was running with a different SQL service account and that service account was part of local administrators group of central SCCM ConfigMgr 2007 site server and remote SUP server.  So the resolution for my problem here was just to add new SQL service account ConfigMgr\svc_SQLSERVICEACCOUNT to local administrators group of both remote SUP and SCCM ConfigMgr 2007 central site server.

Resources

How To Automatically Cleanup Intune Device | EndPoint Manager – HTMD Blog #2

Free SCCM Training Part 1 | 17 Hours Of Latest Technical Content | ConfigMgr Lab HTMD Blog

We are on WhatsApp now. To get the latest step-by-step guides, news, and updates, Join our Channel. Click here. HTMD WhatsApp.

Author

Anoop C Nair is Microsoft MVP from 2015 onwards for consecutive 10 years! He is a Workplace Solution Architect with more than 22+ years of experience in Workplace technologies. He is a Blogger, Speaker, and Local User Group Community leader. His main focus is on Device Management technologies like SCCM and Intune. He writes about technologies like Intune, SCCM, Windows, Cloud PC, Windows, Entra, Microsoft Security, Career etc…

Written by

Anoop C Nair is Workplace Technology solution architect with 25+ years of experience in global enterprise organizations such as JP Morgan, Capgemini, etc. Microsoft Certified Trainer. Microsoft MVP from 2015 onwards for consecutive 11+ years! He also conducts Intune and modern workplace tech training for enterprise organizations. He is Blogger, Speaker, and Founder of HTMD Community and HTMD Conference. His main focus is on Device Management technologies like Intune, Windows, Cloud PC. He writes about technologies like Intune, SCCM, Windows, Cloud PC, Windows, Entra, Microsoft Security.

Discussion

Join the discussion

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

Related guides

Intune

Windows 11 KB5101650 KB5099414 July 2026 Patch and 3 Zero Day Vulnerabilities and 570 Flaws

Key Takeaways Windows 11 KB5101650 KB5099414 July 2026 Patch and 3 Zero Day Vulnerabilities and 570 Flaws! In the July 2026 Patch, Microsoft introduced new features designed to improve the overall Windows experience. The update adds enhancements to Windows Update for more flexible update management and introduces Point-in-Time Restore, providing an additional recovery option for […]

AC Anoop C Nair 9 min read
Intune

2026 June KB5094126 KB5093998 Windows 11 Patch | 3 Zero Day Vulnerabilities and 200 Flaws

Key Takeaways 2026 June KB5094126 KB5093998 Windows 11 Patch | 3 Zero Day Vulnerabilities and 200 Flaws! The June 2026 Windows 11 Patch Tuesday update brings several improvements to File Explorer. It adds support for additional archive formats, including UU, CPIO, XAR, and NuGet Packages (NUPKG). The update also preserves View and Sort preferences in […]

AC Anoop C Nair 10 min read
Intune

2026 May KB5089549 KB5087420 Windows 11 Patch | 0 Zero Day Vulnerabilities and 120 Flaws

Key Takeaways The Windows 11 May 2026 Patch KB5089549 KB5087420 Update brings important security fixes, performance improvements, and reliability enhancements across the operating system. The update introduces new features such as Xbox Mode for gaming, File Explorer improvements, enhanced input and sharing experiences, better taskbar and Windows Hello reliability, and additional enterprise management capabilities for […]

AC Anoop C Nair 8 min read
SCCM

ConfigMgr 2603 Introduces New Early Update Enrollment Process

Key Takeaways In this post we are discussing the ConfigMgr 2603 Introduces New Early Update Enrollment Process. Microsoft has officially released Configuration Manager version 2603 to the Early Update Ring, giving organizations an opportunity to test upcoming improvements before the global production rollout. The release is targeted at enterprises running ConfigMgr version 2409 or later […]

AC Anoop C Nair 3 min read