How to connect to the WSUS database using SQL tools

On ocassion you may need to connect to the WSUS database.  There have been times where you run into consistency errors that need to be corrected using the SQL Management Studio.  Not a big deal if your database resides on a full blown SQL Server instance.  If you're using the Windows Internal database installation, its not quite as straightforward.

Here's how to connect:

How to uninstall SQL Server Embedded Edition (Windows Internal Database)

Certain Windows services, such as SharePoint Services, install SQL Server Embedded Edition by default as their database. This is the new name for the Windows Internal Database. Unfortunately they don't always uninstall it afterwards.

To remove the 32-bit (x86) version:
msiexec /x {CEB5780F-1A70-44A9-850F-DE6C4F6AA8FB} callerid=ocsetup.exe

To remove the 64-bit (x64) version:
msiexec /x {BDD79957-5801-4A2D-B09E-852E7FA64D01} callerid=ocsetup.exe

Syndicate content