question

ibrahimgamal-9547 avatar image
0 Votes"
ibrahimgamal-9547 asked ·

migrate SCCM Db from sql cluster to new standalone sql server

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/

mem-cm-generalmem-cm-site-deployment
untitled.png (150.5 KiB)
10 |1000 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.

matteu31400 avatar image
1 Vote"
matteu31400 answered ·

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 ?

·
10 |1000 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.

FionaYan-MSFT avatar image
0 Votes"
FionaYan-MSFT answered ·

@ibrahimgamal-9547

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.


·
10 |1000 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.