Cannot open database “SUSDB” requested by the login. The login failed.~~Login failed for user ‘NT AUTHORITY\NETWORK SERVICE’

Unable to synchronize updates with SCCM 2012 R2 with WSUS using a Windows Internal Database.

WCM.log – SCCM\Microsoft Configuration Manager\Logs\

Cannot open database “SUSDB” requested by the login. The login failed.~~Login failed for user ‘NT AUTHORITY\NETWORK SERVICE’

System.Data.SqlClient.SqlException — Cannot open database “SUSDB” requested by the login. The login failed. Login failed for user ‘NT AUTHORITY\NETWORK SERVICE’.

 

Checking the error.log for WID – C:\Windows\WID\

Login failed for user ‘NT AUTHORITY\NETWORK SERVICE’. Reason: Failed to open the explicitly specified database ‘SUSDB’.
Error: 18456, Severity: 14, State: 38.

 

The solution:

Uninstall KB3148812

More info: https://blogs.technet.microsoft.com/wsus/2016/04/22/what-you-need-to-know-about-kb3148812-part-two/

Update

https://blogs.technet.microsoft.com/wsus/2016/05/05/the-long-term-fix-for-kb3148812-issues/

Install KB3159706

Then run the post-install steps from the link above.

Total Views: (10707)

Leave a Reply

*