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.
Pre request
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