Wednesday, February 3, 2016

Connect to WS2012 WSUS Internal Database

To connect to the Windows Internal Database (WID) WSUS, install SQL Management Studio and connect to the server using:


\\.\pipe\MICROSOFT##WID\tsql\query

You may confirm the SQL instance name in red against the startup service description using services.msc.

As there is a constant error of "WSUS server is still processing a previous configuration change", this is what I need to execute on the database instance:

USE SUSDB; 
UPDATE tbSingletonData SET ResetStateMachineNeeded = 0

No comments:

Post a Comment