question

BoopathiSubramaniam-6294 avatar image
0 Votes"
BoopathiSubramaniam-6294 asked AllenLiu-MSFT commented

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

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

mem-cm-updates
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

AllenLiu-MSFT avatar image
0 Votes"
AllenLiu-MSFT answered AllenLiu-MSFT commented

Hi, @BoopathiSubramaniam-6294
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.


· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hello AllenLiu134559-1.jpg

It is already selected


134587-capture1.jpg


0 Votes 0 ·
1.jpg (100.2 KiB)
capture1.jpg (23.3 KiB)