PENDING SCCM not connecting to DB after changing SQL Service account password

[Jans george]

logs:
*** [08001][-2146893019][Microsoft][SQL Server Native Client 11.0]Client unable to establish connection SMS Provider 3/3/2019 3:06:52 PM 7404 (0x1CEC)
[08001][-2146893019][Microsoft][SQL Server Native Client 11.0]Client unable to establish connection [08001][-2146893019][Microsoft][SQL Server Native Client 11.0]SSL Provider: The certificate chain was issued by an authority that is not trusted.~~ ThreadID : 7404 , DbError: -2146893019 , Sev: 0~~ SMS Provider 3/3/2019 3:06:52 PM 7404 (0x1CEC)
*** Failed to connect to the SQL Server, connection type: SMS ACCESS. SMS Provider 3/3/2019 3:06:52 PM 7404 (0x1CEC)
..\sspobjectquery.cpp(6326) : SQL Connection attempt timed out~ SQL Error: [08001][-2146893019][Microsoft][SQL Server Native Client 11.0]Client unable to establish connection~~ SMS Provider 3/3/2019 3:06:52 PM 7404 (0x1CEC)
SQL Connection attempt timed out [08001][-2146893019][Microsoft][SQL Server Native Client 11.0]Client unable to establish connection SMS Provider 3/3/2019 3:06:52 PM 7404 (0x1CEC)
CSspClassManager::SQL query failed and returned quickly so sleeping for 20 seconds... SMS Provider 3/3/2019 3:06:52 PM 7404 (0x1CEC)
...now attempting SQL connection + query SMS Provider 3/3/2019 3:07:12 PM 7404 (0x1CEC)
CSspQueryForObject :: Execute... SMS Provider 3/3/2019 3:07:12 PM 7404 (0x1CEC)
Execute WQL =select * from SMS_Identification SMS Provider 3/3/2019 3:07:12 PM 7404 (0x1CEC)
Execute SQL =select all SMS_Identification.License,SMS_Identification.LocaleID,SMS_Identification.MonthlyReleaseVersion,SMS_Identification.DaysLeft,SMS_Identification.ServiceAccountName,SMS_Identification.SMSAvailableConsoleVersion,SMS_Identification.SMSBuildNumber,SMS_Identification.SMSMinBuildNumber,SMS_Identification.SMSProviderServer,SMS_Identification.SMSSiteServer,SMS_Identification.SMSVersion,SMS_Identification.SupportID,SMS_Identification.ThisSiteCode,SMS_Identification.ThisSiteName,SMS_Identification.UIManifestHash,SMS_Identification.UIManifestHashAlgorithm,SMS_Identification.UIUpdateManifestHash,SMS_Identification.UIUpdateManifestHashAlgorithm from vSMSData AS SMS_Identification SMS Provider 3/3/2019 3:07:12 PM 7404 (0x1CEC)
*** [08001][-2146893019][Microsoft][SQL Server Native Client 11.0]SSL Provider: The certificate chain was issued by an authority that is not trusted. SMS Provider 3/3/2019 3:07:12 PM 7404 (0x1CEC)
[08001][-2146893019][Microsoft][SQL Server Native Client 11.0]SSL Provider: The certificate chain was issued by an authority that is not trusted.~~ ThreadID : 7404 , DbError: -2146893019 , Sev: 0~~ SMS Provider 3/3/2019 3:07:12 PM 7404 (0x1CEC)
*** [08001][-2146893019][Microsoft][SQL Server Native Client 11.0]Client unable to establish connection SMS Provider 3/3/2019 3:07:12 PM 7404 (0x1CEC)
[08001][-2146893019][Microsoft][SQL Server Native Client 11.0]Client unable to establish connection [08001][-2146893019][Microsoft][SQL Server Native Client 11.0]SSL Provider: The certificate chain was issued by an authority that is not trusted.~~ ThreadID : 7404 , DbError: -2146893019 , Sev: 0~~ SMS Provider 3/3/2019 3:07:12 PM 7404 (0x1CEC)
*** Failed to connect to the SQL Server, connection type: SMS ACCESS. SMS Provider 3/3/2019 3:07:12 PM 7404 (0x1CEC)
..\sspobjectquery.cpp(6326) : SQL Connection attempt timed out~ SQL Error: [08001][-2146893019][Microsoft][SQL Server Native Client 11.0]Client unable to establish connection~~ SMS Provider 3/3/2019 3:07:12 PM 7404 (0x1CEC)
SQL Connection attempt timed out [08001][-2146893019][Microsoft][SQL Server Native Client 11.0]Client unable to establish connection SMS Provider 3/3/2019 3:07:12 PM 7404 (0x1CEC)
<><> CANT CONNECT TO SQL, RETURNING ERROR <><> SMS Provider 3/3/2019 3:07:12 PM 7404 (0x1CEC)
Found IClassManger: Opal SMS CSsp Provider Extension Implementation. SMS Provider 3/3/2019 3:07:12 PM 7404 (0x1CEC)
CExtUserContext::LeaveThread : Releasing IWbemContextPtr=-1356316288 SMS Provider 3/3/2019 3:07:12 PM 7404 (0x1CEC)
SMSPROV DllMain - DLL_PROCESS_DETACH...calling AfxTermExtensionModule SMS Provider 3/3/2019 3:08:12 PM 2676 (0x0A74)
EXTNPROV DllMain DLL_PROCESS_DETACH SMS Provider 3/3/2019 3:08:12 PM 2676 (0x0A74)

 

[Garth]

if you read the log it talks about a cert error, not a password error. so exactly what was done? what have you tried to fix it?

 

[Jans george]

We have changed the sql service account password, then sccm stopped working.
So i have changed the password again to previous one.(old password). Still sccm is throwing the error.

 

[Garth]

do a set reset on the site.