Skip Ribbon Commands
Skip to main content

Ondrej Sevecek's English Pages

:

Engineering and troubleshooting by Directory Master!
MCM: Directory

Quick Launch
Ondrej Sevecek's English Pages > Posts > How to connect to Windows Internal Database (WID) with SQL Server Management Studio
January 09
How to connect to Windows Internal Database (WID) with SQL Server Management Studio
by  Ondřej Ševeček  on 09/01/2016 14:55
Category: Blog

The Windows Internal Database (WID) is used by the following Windows server components:

  • Windows Server Update Services (WSUS)
  • Active Directory Federation Services (AD FS)
  • Active Directory Rights Management Services (AD RMS)
  • Windows System Resource Manager (WSRM)

For Windows Server 2008 R2 and Windows Server 2008, you can use the following named pipes (NP) string:

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

On Windows Server 2012 and Windows Server 2012 R2 you must use a different np connection string:

\\.\pipe\MICROSOFT##WID\tsql\query

 

Permanent Link to Post | Email Post Link | Number of Comments 2 Comment(s)

Comments

Re: How to connect to Windows Internal Database (WID) with SQL Server Management Studio

on Windows 2012 and newer, the WID databases are located by default in %WINDIR%\WID\Data folder
 on 29/06/2016 17:27

Re: How to connect to Windows Internal Database (WID) with SQL Server Management Studio

for example, the WSUS database is SUSDB.MDF and SUSDB_LOG.LDF at that precise location
 on 29/06/2016 17:53

Add Comment

Sorry comments are disable due to the constant load of spam *


This simple antispam field seems to work well. Just put here the number.

Title


You do not need to provide any value this column. It will automatically fill with the name of the article itself.

Author *


Body *


Attachments