Windows Internal Database: Difference between revisions

Revision as of 22:51, 29 November 2008

Revision as of 23:15, 29 November 2008

Line 1:

'''Windows Internal Database''' is(codenamed anWYukon, alternativesometimes namereferred forto [[Microsoftas SQL Server]] 2005 Embedded Edition (SSEE). The term is useda invariant the documentation for such applications asof [[WindowsSQL SharePointServer ServicesExpress]] 3.0,2005 [[Windowsthat Serveris Updateincluded Services]] 3.0 andwith [[Windows Server 2008]], where itand is installedincluded aswith aother back-endfree database.[[Microsoft]] SQLproducts Serverreleased Embeddedafter Edition2007 isthat justrequire aan speciallySQL configuredServer nameddatabase instancebackend. of the [[SQLWindows ServerSharePoint ExpressServices]] database3.0 engineand which[[Windows canServer beUpdate accessedServices]] only3.0 byboth certaininclude [[Windows Service]]sInternal Database, orwhich bycan [[SQLbe Serverused Managementas Studioan Express]]alternative to using <code>\\.\pipe\mssql$microsoft##ssee\sql\query</code>a asretail serveredition nameof SQL Server.

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 Services]] running on the same machine.

Several components of Windows Server 2008 use Windows Internal Database for their data storage: [[Active Directory Rights Management Services]], [[Windows System Resource Manager]], [[Universal Description Discovery and Integration|UDDI Services]], 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)

|work=Knowledge Base

|publisher=Microsoft

}}</ref>

[[SQL Server Management Studio Express]] can be used to connect to an instance of Windows Internal Database using <code>\\.\pipe\mssql$microsoft##ssee\sql\query</code> as server name.

==References==

{{reflist}}

==External links==

Line 7 ⟶ 21:

{{MS DevTools}}

{{database-software-stub}}

{{windows-stub}}

[[Category:SQL]]