Move SCCM DB and SUSDB to Different instance

Ahmed Essam 196 Reputation points
2020-08-24T11:02:07.777+00:00

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

Not Monitored
Not Monitored
Tag not monitored by Microsoft.
25,520 questions

4 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Jason Sandys 30,911 Reputation points Microsoft Employee
    2020-08-24T14:37:21.517+00:00
  2. AllenLiu-MSFT 24,291 Reputation points Microsoft Vendor
    2020-08-25T02:27:26.99+00:00

    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://learn.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.

  3. Ahmed Essam 196 Reputation points
    2020-09-02T07:25:34.697+00:00

    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

  4. AllenLiu-MSFT 24,291 Reputation points Microsoft Vendor
    2020-09-07T02:00:49.76+00:00

    @Ahmed Essam
    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.