Friday, February 27, 2009

Exploring the WSUS Windows Internal Database

 

Exploring the WSUS Windows Internal Database

When installing WSUS you have the option to connect to a SQL instance or to use the Windows Internal Database which ships with WSUS 3.0 SP1. The Windows Internal Database is just a limited version of Microsoft SQL Server 2005 which can be connected to using the standard SQL console.

If you want to open the database created by WSUS (SUSDB) you can download and install SQL Management Studio Express on the WSUS server.

Note: SQL Management Studio Express will not install SQL Express or any SQL database engine. It is simply an MMC snap-in.

Note: Before installing, you must install MSXML 6.0 or higher. You can download MSXML 6.0 from here.

  1. Download Microsoft SQL Server Management Studio Express from here. Make sure you select the x86 or x64 version depending on your server architecture.
  2. Install SQL Management Studio by selecting all defaults.
  3. Open SQL Management Studio by selecting Start – All Programs – Microsoft SQL Server 2005 and selecting SQL Server Management Studio Express.
  4. At the “Connect to Server” dialog, in the Server name field enter the  following string:

    \\.\pipe\MSSQL$MICROSOFT##SSEE\sql\query

    image

    Select Windows Authentication and click Connect.

  5. At this point SQL Management Studio Express will make a connection to the Windows Internal Database using a named pipes connection (one of the limitations of Windows Internal Database).
  6. Expand Databases and select SUSDB to explore tables, views, permissions, etc as you would as if you were using full SQL.image
  7. It is important to remember that editing the SUSDB tables, is not supported by Microsoft.

If you are interested in querying the WSUS database, it is recommended and supported to use the documented WSUS SQL Views which is defined in this MSDN article.

Posted: Friday, February 27, 2009 1:49 AM by gborger

Gerry's System Center Blog : Exploring the WSUS Windows Internal Database

No comments:

Blog Archive