Tech Community Live: Microsoft Intune
Oct 01 2024, 07:30 AM - 11:30 AM (PDT)
Microsoft Tech Community

After moving SCCM SQL DB to a cluster, SCCM couldn't connect to the DB

Copper Contributor

Hi Everyone, I am migrating our SQL DB to a cluster and the last error in configmgrsetup.log is 

 

Site server does not have admin rights on remote sql server machine db_sccm.domain.com.

 

I made sure the main servers computer account had full permission on the servers hosting the cluster. Any idea what I'm missing?

2 Replies
The site server account must be both SA and administrator on all nodes within the cluster. You will also want to preform a site reset too, to ensure all the services and permissions are correct.

@ appreciate the response Garth, I saw you responded to my reddit thread I'll update there.