Home > Computers > Connect to WSUS Database Using SQL Server Management Studio Express

Connect to WSUS Database Using SQL Server Management Studio Express

You can use SQL Server Management Studio Express (SQL SMSE) to connect to the internal WSUS database. Do the following.

  • If not already done, Install SQL SMSE 2005.
  • Launch SQL SMSE.
  • In the Server name drop-down type \\.\pipe\mssql$microsoft##ssee\sql\query
  • In the Authentication drop-down select Windows Authentication.
  • You can now use SQL SMSE to run queries against the WSUS database (SUSBD).
Advertisements
Categories: Computers Tags: ,
  1. simeon
    May 27, 2016 at 5:23 am

    make sure to RUN AS ADMINISTRATOR if you have User Access Control enabled or you will see a message like
    18452 Can not connect to //./pipe/MSSQL$MICROSOFT##SSEE/sql/query
    login failed for user xxxxx

  2. October 25, 2016 at 7:50 pm

    Seeing this was one of Google’s top hits, updated instructions for WSUS 3.0 on Windows Server 2012R2:

    Run SSMS as Admnistrator
    In the Server name: field enter: \\.\pipe\MICROSOFT##WID\tsql\query

    • ltrain1976
      January 12, 2017 at 1:03 pm

      downforce you are awesome!! I have been messing with this for hours and with your instruction I was able to connect.

  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: