Windows Internal Database: Difference between revisions

Revision as of 18:10, 26 February 2022

Revision as of 16:44, 7 December 2022

Line 1:

'''Windows Internal Database''' (codenamed WYukon, sometimes referred to as SQL Server Embedded Edition) is a variant of [[SQL Server Express]] 2005–2014 that is included with [[Windows Server 2008]] (SQL 2005), [[Windows Server 2008 R2]] (SQL 2005), [[Windows Server 2012]] (SQL 2012), [[Windows Server 2012 R2]] (SQL 2012), [[Windows Server 2016]], [[Windows Server 2019]] and [[Windows Server 20162022]] (SQL 2014)<ref>{{Cite web |last=Marshall |first=Adam J. |date=2022-06-02 |title=WSUS Post-deployment Configuration Failed - Windows Server 2022 |url=https://www.ajtek.ca/wsus/wsus-post-deployment-configuration-failed-windows-server-2022/ |access-date=2022-12-07 |website=AJ Tek Corporation |language=en-US}}</ref> 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 a component of Windows Server 2008 64-bit, which installs in the path {{code|C:\Windows\sysmsi\ssee\}} In Windows Server 2012 and later, it is a 64-bit application, installed in {{code|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.