Config Manager could not connect to SUSDB: Login failed for user 'NT AUTHORITY\SYSTEM wsyncmgr.log

Question

Hello,
SUP role is installed in another site syste and getting the below message in wsynmgr.log in Primary SCCM server.

Done Declining updates in WSUS Server adatum.contoso.com
Starting Deletion of ObseleteUpdates
STATMSG: ID=6719 SEV=E LEV=M SOURCE="SMS Server" COMP="SMS_WSUS_SYNC_MANAGER" SYS=adatum.contoso.com SITE=CON PID=10880 TID=796 GMTDATE=Wed Sep 22 07:07:57.157 2021 ISTR0="" ISTR1="" ISTR2="" ISTR3="" ISTR4="" ISTR5="" ISTR6="" ISTR7="" ISTR8="" ISTR9="" NUMATTRS=0 LE=0X0
Could not Delete Obselete Updates because ConfigManager could not connect to SUSDB: Cannot open database "SUSDB" requested by the login. The login failed.~~Login failed for user 'NT AUTHORITY\SYSTEM'. UpdateServer: adatum.contoso.com
Sql Exeception was thrown while attempting to delete obselete updates. Error Message: Cannot open database "SUSDB" requested by the login. The login failed.~~Login failed for user 'NT AUTHORITY\SYSTEM'.
0 update(s) were deleted from SUSDB in Server: \.\pipe\MICROSOFT##WID\tsql\query Database: SUSDB
Deletion Completed
Set content version of update source {DB382BB1-B9C8-45BF-B98F-3D683B6D9D3F} for site CON to 3250
STATMSG: ID=6702 SEV=I LEV=M SOURCE="SMS Server" COMP="SMS_WSUS_SYNC_MANAGER" SYS=adatum.contoso.com SITE=CON PID=10880 TID=8896 GMTDATE=Wed Sep 22 07:08:08.112 2021 ISTR0="" ISTR1="" ISTR2="" ISTR3="" ISTR4="" ISTR5="" ISTR6="" ISTR7="" ISTR8="" ISTR9="" NUMATTRS=0 LE=0X0

I checked that all the permissions are correct and i am able to connect to SUSDB using SSMS. Also TCP/IP is enabled in configuraiton manager.

Please help

Answer 1

Hi, @Boopathi S
Thank you for posting in Microsoft Q&A forum.

Please try the steps to see if it helps:

1.Open SQL Server Management Studio
2.Connect to the SQL instance
3.Expand Databases, Security and then Logins
4.Right click on NT AUTHORITY\SYSTEM and choose Properties
5.Under User Mappings, select the SUSDB database from the central pane and delegate the "public" and "webService" role membership.
6.From the ConfigMgr console, open the Configuration Manager Service Manager and cycle the SUP's SMS_WSUS_CONTROL_MANAGER.

---

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 2

WSUS on Server 2022, SCCM 2207

Could not Delete Obselete Updates because ConfigManager could not connect to SUSDB: Cannot open database "SUSDB" requested by the login. The login failed.~~Login failed for user 'DOMAIN\SP-V-SCCM-CB$'. UpdateServer: sp-p-wsus.diomain.local  $$<SMS_WSUS_SYNC_MANAGER><11-10-2022 01:39:33.589+00><thread=48092 (0xBBDC)>  
Sql Exeception was thrown while attempting to delete obselete updates. Error Message: Cannot open database "SUSDB" requested by the login. The login failed.~~Login failed for user 'DOMAIN\SP-V-SCCM-CB$'.  $$<SMS_WSUS_SYNC_MANAGER><11-10-2022 01:39:43.621+00><thread=48092 (0xBBDC)>