migrate SCCM Db from sql cluster to new standalone sql server

Ibrahim Gamal A 21 Reputation points
2021-03-16T12:43:03.003+00:00

after migrate SCCM Db from sql cluster to new standalone sql server and when reconfigure site server to connect with new sql getting error78293-untitled.png

I followed this steps link:
https://deploymentresearch.com/moving-the-configmgr-current-branch-database-to-another-server-as-in-back-to-the-primary-site-server/

Microsoft Configuration Manager
0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. matteu31 467 Reputation points
    2021-03-16T22:54:33.587+00:00

    Hello,
    Did you restore the sql database on your server and can you seen it ?
    Did you enable clr ?
    Does your account used to sccm site restore has right to access this database ?

    1 person found this answer helpful.
    0 comments
  2. Fiona Yan-MSFT 2,311 Reputation points
    2021-03-17T02:24:22.063+00:00

    @Ibrahim Gamal A

    Thank you for posting in Microsoft Q&A forum.

    Did you check the ConfigMgrSetup.log on server side? If not, please check it to see if there is any related details in it. Besides, could you click "ok" and keep going on? Or we stuck on this step that the image shown above?
    As agreed with matteu31400, we could also track the configuration though this log, we may see "<<<Checking access permissions...CM Prereq, pri site Administrative rights on central administration site..."

    Have a good day!

    If the response is helpful, please click "Accept Answer" and upvote it.
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    0 comments