Greeting for the day!! Today We will be discussed about due to any of the reason you have to change site server database ABC Server Database to XYZ Database server.
Scenarios: You Infrastructure is working as normal but due to existing server decommission or want to separate database from share database.
How to Move Database from ABC Server to XYZ Database.
Login to your Site Server à Control Panel à Add or remove Program à Select System Center Configuration site Setup
You will be see below screen Click on Next
In Getting Start Wizard
Select Perform Site maintenance or reset this site. à Click Next
In Site Maintenance Wizard
Select Modify SQL Server configuration Click on Next
Database Information Wizard.
You will see existing site server configure Database as we have to change ABC database server to XYZ change new server name and click next
Wizard will check new server name and validate all pre request if all good then your new server configuration will go smooth as normal but today I will be sharing issue like while moving database getting error Failed to decrypt SQL Server machine serialized pfx certificate (LastError=0)
Issue: While moving Database using site maintenance wizard getting error
Failed to decrypt SQL Server machine serialized pfx certificate (LastError=0)
Error on configMGRSetup.log
While open ConfigMGRSetuWizard.log you will see error like received error fail to create SQL server certificate
Now we have error how to fix to success full move. Above issue will reports on below scenarios.
Step 1: The account used for the installation and the computer account of SCCM have to be members of the local admins group on SCCMDB and need also sysadmin rights in SQL.
Step 2: make sure you configure the SQL services to run under a domain user account rather than as local system or network service. Running SQL under a domain user follows MS best practices.
Step 3: Certificate is not mapped to your SCCM Instance. How to verify ?
Launch the SQL Server Configuration Manager, expand SQL Server Network Configuration, right click Protocols for MSSQLSERVER and click Properties. Make sure ConfigMGR SQL Server Identification Certificate is Mapped if missing then we have to create certificate and import in SCCMDB Server
If Certificate is missing. How to Create Certificate?
Create ConfigMgr SQL Server Identification Certificate.
To create ConfigMgr SQL Server Identification Certificate, open the IIS management console. Select the server then double click Server Certificates