SOLVED Configuration manager can not connect to the site (SCCM console)

[TOTO JDD]

Hello,

Since this morning my console sccm 1710 does not open anymore. It was just after having a problem of trust relationship between my server and the domain, when I wanted to connect to this server with a domain account. To solve this problem, I logged on to the server with a local admin account, then pulled that server out to the domain and then put it back in the domain



Can someone tell me how to solve this problem?

 

[Prajwal Desai]

In the screenshot, there are reasons listed for why this error could have come up. Have you verified those ?.

 

[TOTO JDD]

Exactly I checked without success.
Voici le fichier log SMSProv :

*** [28000][18456][Microsoft][SQL Server Native Client 11.0][SQL Server]Échec de l'ouverture de session de l'utilisateur 'Domaine\NomServeur$'. SMS Provider 09/07/2018 12:09:32 2036 (0x07F4) *~*~[28000][18456][Microsoft][SQL Server Native Client 11.0][SQL Server]Échec de l'ouverture de session de l'utilisateur 'Domaine\NomServeur$'. [28000][18456][Microsoft][SQL Server Native Client 11.0][SQL Server]Échec de l'ouverture de session de l'utilisateur 'Domaine\NomServeur$'. ThreadID : 2036 , DbError: 18456 , Sev: 0~*~* SMS Provider 09/07/2018 12:09:32 2036 (0x07F4) *** Failed to connect to the SQL Server, connection type: SMS ACCESS. SMS Provider 09/07/2018 12:09:32 2036 (0x07F4) *~*~..\sspobjectquery.cpp(6314) : SQL Connection attempt timed out~ SQL Error: [28000][18456][Microsoft][SQL Server Native Client 11.0][SQL Server]Échec de l'ouverture de session de l'utilisateur 'Domaine\NomServeur$'.~*~* SMS Provider 09/07/2018 12:09:32 2036 (0x07F4) *~*~SQL Connection attempt timed out [28000][18456][Microsoft][SQL Server Native Client 11.0][SQL Server]Échec de l'ouverture de session de l'utilisateur 'Domaine\NomServeur$'.~*~* SMS Provider 09/07/2018 12:09:32 2036 (0x07F4) CSspClassManager::SQL query failed and returned quickly so sleeping for 20 seconds... SMS Provider 09/07/2018 12:09:32 2036 (0x07F4) ...now attempting SQL connection + query SMS Provider 09/07/2018 12:09:52 2036 (0x07F4) CSspQueryForObject :: Execute... SMS Provider 09/07/2018 12:09:52 2036 (0x07F4) Execute WQL =select * from SMS_Identification SMS Provider 09/07/2018 12:09:52 2036 (0x07F4) 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 09/07/2018 12:09:52 2036 (0x07F4) *** [28000][18456][Microsoft][SQL Server Native Client 11.0][SQL Server]Échec de l'ouverture de session de l'utilisateur 'Domaine\NomServeur$'. SMS Provider 09/07/2018 12:09:52 2036 (0x07F4) *~*~[28000][18456][Microsoft][SQL Server Native Client 11.0][SQL Server]Échec de l'ouverture de session de l'utilisateur 'Domaine\NomServeur$'. ThreadID : 2036 , DbError: 18456 , Sev: 0~*~* SMS Provider 09/07/2018 12:09:52 2036 (0x07F4) *** [28000][18456][Microsoft][SQL Server Native Client 11.0][SQL Server]Échec de l'ouverture de session de l'utilisateur 'Domaine\NomServeur$'. SMS Provider 09/07/2018 12:09:52 2036 (0x07F4) *~*~[28000][18456][Microsoft][SQL Server Native Client 11.0][SQL Server]Échec de l'ouverture de session de l'utilisateur 'Domaine\NomServeur$'. [28000][18456][Microsoft][SQL Server Native Client 11.0][SQL Server]Échec de l'ouverture de session de l'utilisateur 'Domaine\NomServeur$'. ThreadID : 2036 , DbError: 18456 , Sev: 0~*~* SMS Provider 09/07/2018 12:09:52 2036 (0x07F4) *** Failed to connect to the SQL Server, connection type: SMS ACCESS. SMS Provider 09/07/2018 12:09:52 2036 (0x07F4) *~*~..\sspobjectquery.cpp(6314) : SQL Connection attempt timed out~ SQL Error: [28000][18456][Microsoft][SQL Server Native Client 11.0][SQL Server]Échec de l'ouverture de session de l'utilisateur 'Domaine\NomServeur$'.~*~* SMS Provider 09/07/2018 12:09:52 2036 (0x07F4) *~*~SQL Connection attempt timed out [28000][18456][Microsoft][SQL Server Native Client 11.0][SQL Server]Échec de l'ouverture de session de l'utilisateur 'Domaine\NomServeur$'.~*~* SMS Provider 09/07/2018 12:09:52 2036 (0x07F4) <*><*> CANT CONNECT TO SQL, RETURNING ERROR <*><*> SMS Provider 09/07/2018 12:09:52 2036 (0x07F4) Found IClassManger: Opal SMS CSsp Provider Extension Implementation. SMS Provider 09/07/2018 12:09:52 2036 (0x07F4) CExtUserContext::LeaveThread : Releasing IWbemContextPtr=281290000 SMS Provider 09/07/2018 12:09:52 2036 (0x07F4) SMSPROV DllMain - DLL_PROCESS_DETACH...calling AfxTermExtensionModule SMS Provider 09/07/2018 12:10:42 6392 (0x18F8) EXTNPROV DllMain DLL_PROCESS_DETACH SMS Provider 09/07/2018 12:10:42 6392 (0x18F8)

 

[TOTO JDD]

Hello,

To solve this problem, I proceeded as follows:

Check if the sccm server is with the correct name in the "System management" container on the AD.
On the server of the database delete the computer account of the sccm server, then add it. Before deleting this account I noted the permissions that it has in order to assign them to the new account

Please follow this tutorial for adding a new account on the database server: https://www.enhansoft.com/blog/how-to-create-a-sql-server-computer-account -login

After this manipulation, I logged in again on my sccm console.

Cordially.