question

AhmedEssam-4837 avatar image
0 Votes"
AhmedEssam-4837 asked AllenLiu-MSFT answered

Move SCCM DB and SUSDB to Different instance

Hi,

We've SCCM Primary Site CB 1902 and its databases hosted on a clustered SQL server, we are planning to move SUSDB and CM DB from default instance (MSSQLSERVER) to new Instance on the same cluster.

so please I need the sequence should I follow to perform this task


Thanks in advance

mem-cm-site-deployment
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Jason-MSFT avatar image
0 Votes"
Jason-MSFT answered
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

AllenLiu-MSFT avatar image
0 Votes"
AllenLiu-MSFT answered AllenLiu-MSFT edited

Hi,

We can move the site database to a new instance of SQL Server on the same computer, or to a different computer that runs a supported version of SQL Server.
Run Configuration Manager setup on the site server, and select the option Perform site maintenance or reset this site. Then select the Modify SQL Server configuration option. Then we can change instance of SQL Server.
Note when we move the database to a new instance on SQL Server, we need to enable common language runtime (CLR) integration. Use SQL Server Management Studio to connect to the instance of SQL Server that hosts the site database. Then run the following stored procedure as a query: sp_configure 'clr enabled',1; reconfigure

Here is the documentation and the precautions:
https://docs.microsoft.com/en-us/mem/configmgr/core/servers/manage/modify-your-infrastructure#bkmk_dbconfig


If the response is helpful, please click "Accept Answer" and upvote it.


5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

AhmedEssam-4837 avatar image
0 Votes"
AhmedEssam-4837 answered

Hi Allen and Jason

Thanks for your help

I followed the steps to move to CM database from default instance to another instance (Always On)

when I try to modify SQL configuration using SCCM setup wizard which is located in cd.latest, I get the below errors

ERROR: SQL Server error: [08001][-2146893019][Microsoft][SQL Server Native Client 11.0]SSL Provider: The certificate chain was issued by an authority that is not trusted.

i found a certificate named with the SQL instance name in the Trusted People folder in sccm server

Thanks

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

AllenLiu-MSFT avatar image
0 Votes"
AllenLiu-MSFT answered

@AhmedEssam-4837
Your SQL is clustered, so you may need to check which certificate is being used follow the steps.
You may refer to the last reply of the thread:
https://social.technet.microsoft.com/Forums/en-US/a96b7ba6-32cc-4ceb-a1e0-b0952d5a134d/sccm-2012-db-migration-certificate-chain-error?forum=configmanagermigration


If the response is helpful, please click "Accept Answer" and upvote it.


5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.