SCCM SUP Critical alert

Question

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.

"

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)"

Please help me to fix the problem.

Answer 1

Hi @Premkumar Nagaiah ,

Cannot open database "SUSDB" requested by the login. The login failed.~~Login failed for user 'TECHDATA\TECHDATASCCM$'

Make sure that the above account has necessary privileges to access to the SUSDB.

Regards,

---

Youssef Saad | New blog: https://youssef-saad.blogspot.com
Please remember to ** “Accept answer” ** for useful answers, thank you!

Answer 2

Hi,

Thanks for posting in Microsoft MECM Q&A forum.

Agree with Youssef Saad, it seems to be that your account is lack of needed permissions on the SUSDB database. For more detailed steps to check and delegate the permissions, please refer to:

sccm wsus shared database
Minimum Permissions Required for Publisher to Scan SCCM Database
ConfigMgr WSUS, WSUSCtrl.log "Cannot open database "SUSDB" requested by the login. The login failed.~~Login failed for user 'DOMAIN\SERVER$'"

By the way, when you post the log information, please pay attention to hide private information, such as Domain user name, FQDN, IP address.

Best regards,
Simon

---

If the response is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 3

@Premkumar Nagaiah Normally sysadmin permissions should suffice
Permission issue? Try opening SSMS using system account https://sanderstechnology.net/2018/access-sql-server-as-nt-authoritysystem-using-ssms-and-the-psexec-tool/15453/#.YKFHpL4zaHs
Make sure, check HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Update Services\Server\Setup>SqlServerName to find where SUSDB is installed
If its WID, need to use SSMS to connect to \.\pipe\MICROSOFT##WID\tsql\query