Windows Internal Database: Difference between revisions

Revision as of 19:53, 16 March 2013

Revision as of 14:04, 4 March 2014

Line 1:

'''Windows Internal Database''' (codenamed WYukon, sometimes referred to as SQL Server Embedded Edition) is a variant of [[SQL Server Express]] 2005-2012 or that is included with [[Windows Server 2008]] (SQL 2005), [[Windows Server 2008 R2]] (SQL 2005) and [[Windows Server 2012]] (SQL 2012), and is included with other free [[Microsoft]] products released after 2007 that require an SQL Server database backend. [[Windows SharePoint Services]] 3.0 and [[Windows Server Update Services]] 3.0 both include Windows Internal Database, which can be used as an alternative to using a retail edition of SQL Server. WID was a 32-bit application, even as component of Windows Server 2008 64-bit, which installs in the path C:\Program Files (x86)\Microsoft SQL Server. In Windows Server 2012, it is a 64-bit application, installed in C:\Windows\WID.

Windows Internal Database is not available as a standalone product for use by end-user applications; Microsoft provides SQL Server Express and [[Microsoft SQL Server]] for this purpose. Additionally, it is designed to only be accessible to [[Windows Service]]s running on the same machine.

Several components of Windows Server 2008 and 2012 use Windows Internal Database for their data storage: [[Active Directory Rights Management Services]], [[Windows System Resource Manager]], [[Universal Description Discovery and Integration|UDDI Services]], [[Active Directory Federation Services]] 2.0, [[Windows_Server_2012#IP_address_management|IPAM]]<ref>{{cite web|url=http://technet.microsoft.com/en-US/library/jj878342.aspx|title=IPAM Architecture
|work=TechNet|publisher=Microsoft}}</ref> and Windows SharePoint Services. On Windows Server 2003, SharePoint and [[Windows Server Update Services]] will install Windows Internal Database and use it as a default data store if a retail SQL Server database instance is not provided. A Knowledge Base article published by Microsoft states that Windows Internal Database does not identify itself as a removable component, and provides instructions how it may be uninstalled by calling [[Windows Installer]] directly.<ref>{{cite web

|url=http://support.microsoft.com/kb/920277

|title=Windows Internal Database is not listed in the Add or Remove Programs tool and is not removed when you remove Windows SharePoint Services 3.0 from the computer (MSKB920277)