Premkumar Nagaiah
New Member
- Messages
- 1
- Reaction score
- 0
- Points
- 1
Hi Sir,
I am working as a SCCM Administrator in an MNC company . I have setup SCCM Test lab using the Hyper-V VM's. I have configured the SUP role in SCCM Standalone Primary server. When i see the SUP role, it is showing critical. I have checked in WCM log and it is showing the below error. I have tried searching in google but unable to find the resolution.
Checking for supported version of WSUS (min WSUS 3.0 SP2 + KB2720211 + KB2734608) SMS_WSUS_CONFIGURATION_MANAGER 28-12-2020 04:51:09 6736 (0x1A50)
Checking runtime v4.0.30319... SMS_WSUS_CONFIGURATION_MANAGER 28-12-2020 04:51:09 6736 (0x1A50)
Found supported assembly Microsoft.UpdateServices.Administration version 4.0.0.0, file version 6.2.14393.0 SMS_WSUS_CONFIGURATION_MANAGER 28-12-2020 04:51:09 6736 (0x1A50)
Found supported assembly Microsoft.UpdateServices.BaseApi version 4.0.0.0, file version 6.2.14393.479 SMS_WSUS_CONFIGURATION_MANAGER 28-12-2020 04:51:09 6736 (0x1A50)
Supported WSUS version found SMS_WSUS_CONFIGURATION_MANAGER 28-12-2020 04:51:09 6736 (0x1A50)
Using TechData\SCCM credentials for network connections SMS_WSUS_CONFIGURATION_MANAGER 28-12-2020 04:51:09 6736 (0x1A50)
Attempting connection to local WSUS server SMS_WSUS_CONFIGURATION_MANAGER 28-12-2020 04:51:09 6736 (0x1A50)
Successfully connected to local WSUS server SMS_WSUS_CONFIGURATION_MANAGER 28-12-2020 04:51:10 6736 (0x1A50)
Verify Upstream Server settings on the Active WSUS Server SMS_WSUS_CONFIGURATION_MANAGER 28-12-2020 04:51:10 6736 (0x1A50)
System.Data.SqlClient.SqlException (0x80131904): Cannot open database "SUSDB" requested by the login. The login failed.~~Login failed for user 'TECHDATA\TECHDATASCCM$'.~~ at Microsoft.UpdateServices.Internal.BaseApi.SoapExceptionProcessor.DeserializeAndThrow(SoapException soapException)~~ at Microsoft.UpdateServices.Internal.DatabaseAccess.AdminDataAccessProxy.ExecuteSPGetConfiguration()~~ at Microsoft.UpdateServices.Internal.BaseApi.UpdateServerConfiguration.Load()~~ at Microsoft.UpdateServices.Internal.ClassFactory.CreateWellKnownType(Type type, Object[] args)~~ at Microsoft.UpdateServices.Internal.ClassFactory.CreateInstance(Type type, Object[] args)~~ at Microsoft.UpdateServices.Internal.BaseApi.UpdateServer.GetConfiguration()~~ at Microsoft.SystemsManagementServer.WSUS.WSUSServer.SetUpstreamServerSettings(Boolean SyncFromMicrosoftUpdate, Boolean ReplicaServer, String UpstreamWSUSServerName, Int32 UpstreamWSUSServerPortNumber, Boolean UseSSL, Boolean HostBinariesOnMU, Int32 ReportingLevel, Int32 MaximumAllowedComputers)~~ClientConnectionId:00000000-0000-0000-0000-000000000000 SMS_WSUS_CONFIGURATION_MANAGER 28-12-2020 04:51:20 6736 (0x1A50)
Done using TechData\SCCM credentials SMS_WSUS_CONFIGURATION_MANAGER 28-12-2020 04:51:20 6736 (0x1A50)
Remote configuration failed on WSUS Server. SMS_WSUS_CONFIGURATION_MANAGER 28-12-2020 04:51:20 6736 (0x1A50)
STATMSG: ID=6600 SEV=E LEV=M SOURCE="SMS Server" COMP="SMS_WSUS_CONFIGURATION_MANAGER" SYS=TECHDATASCCM.TECHDATA.LOCAL SITE=T01 PID=2372 TID=6736 GMTDATE=Sun Dec 27 23:21:20.442 2020 ISTR0="TechDataSCCM.TECHDATA.LOCAL" ISTR1="" ISTR2="" ISTR3="" ISTR4="" ISTR5="" ISTR6="" ISTR7="" ISTR8="" ISTR9="" NUMATTRS=0 SMS_WSUS_CONFIGURATION_MANAGER 28-12-2020 04:51:20 6736 (0x1A50)
Setting new configuration state to 3 (WSUS_CONFIG_FAILED) SMS_WSUS_CONFIGURATION_MANAGER 28-12-2020 04:51:20 6736 (0x1A50)
Waiting for changes for 60 minutes SMS_WSUS_CONFIGURATION_MANAGER 28-12-2020 04:51:20 6736 (0x1A50)
Trigger event array index 0 ended. SMS_WSUS_CONFIGURATION_MANAGER 28-12-2020 04:53:48 6736 (0x1A50)
SCF change notification triggered. SMS_WSUS_CONFIGURATION_MANAGER 28-12-2020 04:53:53 6736 (0x1A50)
Populating config from SCF SMS_WSUS_CONFIGURATION_MANAGER 28-12-2020 04:53:53 6736 (0x1A50)
Waiting for changes for 57 minutes SMS_WSUS_CONFIGURATION_MANAGER 28-12-2020 04:53:53 6736 (0x1A50)
Can you please explain me. Also I tried to open WSUS console but when connecting to SCCM server but it is showing unable to connect SQL server.
Please help me to resolve this issue.
I am working as a SCCM Administrator in an MNC company . I have setup SCCM Test lab using the Hyper-V VM's. I have configured the SUP role in SCCM Standalone Primary server. When i see the SUP role, it is showing critical. I have checked in WCM log and it is showing the below error. I have tried searching in google but unable to find the resolution.
Checking for supported version of WSUS (min WSUS 3.0 SP2 + KB2720211 + KB2734608) SMS_WSUS_CONFIGURATION_MANAGER 28-12-2020 04:51:09 6736 (0x1A50)
Checking runtime v4.0.30319... SMS_WSUS_CONFIGURATION_MANAGER 28-12-2020 04:51:09 6736 (0x1A50)
Found supported assembly Microsoft.UpdateServices.Administration version 4.0.0.0, file version 6.2.14393.0 SMS_WSUS_CONFIGURATION_MANAGER 28-12-2020 04:51:09 6736 (0x1A50)
Found supported assembly Microsoft.UpdateServices.BaseApi version 4.0.0.0, file version 6.2.14393.479 SMS_WSUS_CONFIGURATION_MANAGER 28-12-2020 04:51:09 6736 (0x1A50)
Supported WSUS version found SMS_WSUS_CONFIGURATION_MANAGER 28-12-2020 04:51:09 6736 (0x1A50)
Using TechData\SCCM credentials for network connections SMS_WSUS_CONFIGURATION_MANAGER 28-12-2020 04:51:09 6736 (0x1A50)
Attempting connection to local WSUS server SMS_WSUS_CONFIGURATION_MANAGER 28-12-2020 04:51:09 6736 (0x1A50)
Successfully connected to local WSUS server SMS_WSUS_CONFIGURATION_MANAGER 28-12-2020 04:51:10 6736 (0x1A50)
Verify Upstream Server settings on the Active WSUS Server SMS_WSUS_CONFIGURATION_MANAGER 28-12-2020 04:51:10 6736 (0x1A50)
System.Data.SqlClient.SqlException (0x80131904): Cannot open database "SUSDB" requested by the login. The login failed.~~Login failed for user 'TECHDATA\TECHDATASCCM$'.~~ at Microsoft.UpdateServices.Internal.BaseApi.SoapExceptionProcessor.DeserializeAndThrow(SoapException soapException)~~ at Microsoft.UpdateServices.Internal.DatabaseAccess.AdminDataAccessProxy.ExecuteSPGetConfiguration()~~ at Microsoft.UpdateServices.Internal.BaseApi.UpdateServerConfiguration.Load()~~ at Microsoft.UpdateServices.Internal.ClassFactory.CreateWellKnownType(Type type, Object[] args)~~ at Microsoft.UpdateServices.Internal.ClassFactory.CreateInstance(Type type, Object[] args)~~ at Microsoft.UpdateServices.Internal.BaseApi.UpdateServer.GetConfiguration()~~ at Microsoft.SystemsManagementServer.WSUS.WSUSServer.SetUpstreamServerSettings(Boolean SyncFromMicrosoftUpdate, Boolean ReplicaServer, String UpstreamWSUSServerName, Int32 UpstreamWSUSServerPortNumber, Boolean UseSSL, Boolean HostBinariesOnMU, Int32 ReportingLevel, Int32 MaximumAllowedComputers)~~ClientConnectionId:00000000-0000-0000-0000-000000000000 SMS_WSUS_CONFIGURATION_MANAGER 28-12-2020 04:51:20 6736 (0x1A50)
Done using TechData\SCCM credentials SMS_WSUS_CONFIGURATION_MANAGER 28-12-2020 04:51:20 6736 (0x1A50)
Remote configuration failed on WSUS Server. SMS_WSUS_CONFIGURATION_MANAGER 28-12-2020 04:51:20 6736 (0x1A50)
STATMSG: ID=6600 SEV=E LEV=M SOURCE="SMS Server" COMP="SMS_WSUS_CONFIGURATION_MANAGER" SYS=TECHDATASCCM.TECHDATA.LOCAL SITE=T01 PID=2372 TID=6736 GMTDATE=Sun Dec 27 23:21:20.442 2020 ISTR0="TechDataSCCM.TECHDATA.LOCAL" ISTR1="" ISTR2="" ISTR3="" ISTR4="" ISTR5="" ISTR6="" ISTR7="" ISTR8="" ISTR9="" NUMATTRS=0 SMS_WSUS_CONFIGURATION_MANAGER 28-12-2020 04:51:20 6736 (0x1A50)
Setting new configuration state to 3 (WSUS_CONFIG_FAILED) SMS_WSUS_CONFIGURATION_MANAGER 28-12-2020 04:51:20 6736 (0x1A50)
Waiting for changes for 60 minutes SMS_WSUS_CONFIGURATION_MANAGER 28-12-2020 04:51:20 6736 (0x1A50)
Trigger event array index 0 ended. SMS_WSUS_CONFIGURATION_MANAGER 28-12-2020 04:53:48 6736 (0x1A50)
SCF change notification triggered. SMS_WSUS_CONFIGURATION_MANAGER 28-12-2020 04:53:53 6736 (0x1A50)
Populating config from SCF SMS_WSUS_CONFIGURATION_MANAGER 28-12-2020 04:53:53 6736 (0x1A50)
Waiting for changes for 57 minutes SMS_WSUS_CONFIGURATION_MANAGER 28-12-2020 04:53:53 6736 (0x1A50)
Can you please explain me. Also I tried to open WSUS console but when connecting to SCCM server but it is showing unable to connect SQL server.
Please help me to resolve this issue.