SCCM Database Change

%3CLINGO-SUB%20id%3D%22lingo-sub-2136659%22%20slang%3D%22en-US%22%3ESCCM%20Database%20Change%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2136659%22%20slang%3D%22en-US%22%3E%3CP%3EDear%20Team%2Cneed%20your%20help%2C%26nbsp%3B%3C%2FP%3E%3CP%3EIn%20my%20company%2C%20i%20have%20one%20SQL%20server%20(2012%20SP4)%20with%203%20instances%20(One%20for%20SCCM%2C%20One%20for%20SCOM%2C%20One%20for%20SCVMM).%20Recently%20iam%20facing%20some%20issue%20with%20SCCM%20where%20iam%20not%20able%20to%20open%20the%20SCCM%20console%20%22Cannot%20connect%20to%20site%22%26nbsp%3B%20%2C%20the%20issue%20started%20to%20happen%20on%20the%20same%20day%20i%20updated%20SCCM%20to%202010%20version%20and%20when%20iam%20trying%20to%20connect%20SCCM%20database%20instance%20i%20was%20getting%20error.%20Then%20i%20reinstalled%20SCCM%20instance%20and%20copied%20the%20files%20into%20SQL%20data%20folder%2C%20after%20that%20SCCM%20instance%20was%20opening%20but%20the%20console%20still%20not%20opening%20and%20giving%20the%20same%20error.%20When%20checking%20the%20logs%20i%20can%20see%20it%20is%20a%20certificate%20issue%20%22%20The%20certificate%20chain%20was%20issued%20by%20an%20authority%20that%20is%20not%20trusted%22%20Can%20anyone%20help%20me%20how%20to%20solve%20this%20issue%20%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAlso%20i%20want%20to%20know%20whether%20i%20can%20backup%20the%20SCCM%20database%20and%20uninstall%20SQL%202012%20and%20freshly%20install%20SQL%202017%20and%20then%20restore%20the%20same%20SCCM%20database.%20I%20dont%20want%20to%20miss%20the%20updates%20and%20details%20which%20iam%20having%20in%20SCCM.%26nbsp%3B%20Looking%20for%20your%20valuable%20feedback%20and%20reply.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2136659%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ECM%20current%20branch%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2145485%22%20slang%3D%22en-US%22%3ERe%3A%20SCCM%20Database%20Change%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2145485%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F967237%22%20target%3D%22_blank%22%3E%40San_1232110%3C%2FA%3E%26nbsp%3BDear%20Team%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECan%20anyone%20please%20help%20on%20this.%20Its%20an%20urgent%20issue%20and%20need%20to%20solve%20this%20ASAP.%20Requesting%20your%20attention%20on%20this.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

Dear Team,need your help, 

In my company, i have one SQL server (2012 SP4) with 3 instances (One for SCCM, One for SCOM, One for SCVMM). Recently iam facing some issue with SCCM where iam not able to open the SCCM console "Cannot connect to site"  , the issue started to happen on the same day i updated SCCM to 2010 version and when iam trying to connect SCCM database instance i was getting error. Then i reinstalled SCCM instance and copied the files into SQL data folder, after that SCCM instance was opening but the console still not opening and giving the same error. When checking the logs i can see it is a certificate issue " The certificate chain was issued by an authority that is not trusted" Can anyone help me how to solve this issue ?

 

Also i want to know whether i can backup the SCCM database and uninstall SQL 2012 and freshly install SQL 2017 and then restore the same SCCM database. I dont want to miss the updates and details which iam having in SCCM.  Looking for your valuable feedback and reply.

1 Reply

@San_1232110 Dear Team,

 

Can anyone please help on this. Its an urgent issue and need to solve this ASAP. Requesting your attention on this.