Windows Internal Database: Difference between revisions

Revision as of 04:22, 2 June 2015

Revision as of 10:46, 16 September 2015

Line 1:

'''Windows Internal Database''' (codenamed WYukon, sometimes referred to as SQL Server Embedded Edition) is a variant of [[SQL Server Express]] 2005-20122005–2012 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 {{code|C:\Program Files (x86)\Microsoft SQL Server}}. In Windows Server 2012, 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.

Line 11:

}}</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> (2003-20082003–2008) or <code>\\.\pipe\MICROSOFT##WID\tsql\query</code> (2012) as instance name. But this will only work locally, as Remote Connections cannot be enabled for this edition of SQL Server. ''Also note that "Windows Authentication" should be used (as opposed to SQL Server Authentication), and administrators seem to have the best results of authenticating successfully when logged on using the same administrative account that was created when Windows was installed.''

==References==

Line 17:

==External links==

* [http://go.microsoft.com/fwlink/?LinkId=79600 Planning and Architecture for Windows SharePoint Services 3.0 Technology]

* [http://go.microsoft.com/fwlink/?LinkId=71220 Release Notes for Microsoft Windows Server Update Services 3.0]

* [http://www.mssqltips.com/tip.asp?tip=1577 http://www.mssqltips.com/tip.asp?tip=1577]

{{database-software-stub}}