Advertisements
Home > SQL Embedded Edition, Windows 2008 > Windows Internal Database

Windows Internal Database

I haven’t ran into this much, as it seems it is optional component that can be installed when configuring Microsoft Windows.  The reason I say its optional is I don’t see this configured on every Windows 2008 Server.

Only seen it on handful servers so far; I have not had much chance or need to dig into it.  But this database stores information for “Active Directory Rights Management Services, Windows System Resource Manager, UDDI Services, and Windows SharePoint Services” [1].

It uses SQL Server Embedded/Internal/Express Edition and is not remotely manageable.  I had to deal with this instance of SQL Server because there seem to be some contention issue on a server running full version of SQL Server (sorry don’t remember details).

Anyhow this article is more on just this database exists, and how to connect to it.  Since this SQL Server instance is not remote manageable or TCP/IP manaageable; you have to use Named-pipe protocol to connect or all attempts at a connection will fail.

Server Connection name is “\\.\pipe\MSSQL$MICROSOFT##SSEE\sql\query” (without quotes).

Again please note this is local to server, you cannot manage this remotelly.

References

  1. Wikipedia. Windows Internal Database. Link.
  2. MSSQL Tips. Administrating your Windows Internal Database (MICROSOFT##SSEE). Link.
  3. Microsoft TechNet. How to migrate your WSUS WIndows Internal Database. Link.
  4. Microsoft KB. Uninstalling Windows Internal Database. Link.
Advertisements
  1. No comments yet.
  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: