úterý 29. prosince 2015

WSUS database

Exploring the WSUS Windows Internal Database

Správa WSUS databaze

Note: You must install .NET Framework 2.0 and MSXML 6.0 Parser before you install SSMSE 2008 R2.

Note: You must install .NET Framework and MSXML 6.0 Parser before you install SSMSE 2005

  1. Download Microsoft SQL Server Management Studio Express 2008 R2 from here or SSMSE 2008 R2 RTM.  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:
  5. \\.\pipe\MSSQL$MICROSOFT##SSEE\sql\query
  6. 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).
  7. Expand Databases and select SUSDB to explore tables, views, permissions, etc as you would as if you were using full SQL.
  8. It is important to remember that editing the SUSDB tables, is not supported by Microsoft.



https://technet.microsoft.com/cs-cz/library/ms365247(v=sql.105).aspx