Quickie: Connect to the WSUS "Windows Internal Database" with SQL Management Studio

 My lab WSUS server uses the internal WSUS database instead of SQL.  I need to run some queries against it and was all set convert WSUS from WID to SQL (docs.microsoft.com) when I realized you can connect to the internal database with Sql Management Studio.

Use this for the Server name in  SSMS: \\.\pipe\Microsoft##WID\tsql\query



... it works great! 




Comments