Datasheet

SQL Server and Windows Authentication Mode
(Mixed Mode)
In SQL Server Mode and Windows Authentication Mode or Mixed Mode, valid Windows accounts and
standard SQL Server logins are permitted to connect to the server. SQL Server logins are validated by
supplying a username and password. Windows accounts are still trusted by SQL Server. The chief
advantage of Mixed Mode is the ability of non-Windows accounts (such as UNIX) or Internet clients to
connect to SQL Server.
A (Very) Brief History of SQL Server
How did we get here? Where did SQL Server 2005 come from? Without spending a great deal of time
discussing the complete history of SQL Server, I thought it would be of some interest to give a very brief
overview of SQL Server’s roots. I often joke with colleagues and customers that some day I’m going to
write a “Trivial Pursuit, Geek Edition.” This short description may help you get the yellow history
wedge, so pay close attention!
In the Beginning
Microsoft’s foray into the enterprise database space came in 1987 when it formed a partnership with Sybase
to market Sybase’s DataServer product on the Microsoft/IBM OS/2 platform. From that partnership, SQL
Server 1.0 emerged, which was essentially the UNIX version of Sybase’s DataServer ported to OS2.
The Evolution of a Database
After a number of years, the developers at Microsoft were allowed more and more access to the Sybase
source code for test and debugging purposes, but the core SQL Server application continued to be a
product of Sybase until SQL Server 4.2 was released for Windows NT in March of 1992.
SQL Server 4.2 was the first true joint product developed by both Sybase and Microsoft. However, the
database engine was still pure Sybase. Only the tools and database libraries were developed by
Microsoft. Up to that point, SQL Server had been developed to run primarily on the OS/2 platform, but
with the release of Windows NT, the developers at Microsoft essentially abandoned any OS/2 develop-
ment and focused on bringing a version of SQL Server to Windows NT.
Microsoft Goes It Alone
With the growing success of Sybase in the UNIX market and Microsoft in Windows, the two companies
found themselves competing for market share on a product essentially developed by Sybase. As a result,
in 1994, the two companies terminated their joint development agreement, and Sybase granted Microsoft
a limited license to use and modify Sybase technology exclusively for systems running on Windows.
A year later, in June 1995, Microsoft released the first version of SQL Server developed exclusively by
Microsoft developers— SQL Server 6.0— but the core technology was still largely Sybase code-base.
Less than a year later, more changes were made and Microsoft released SQL Server 6.5 in April of 1996.
19
Introducing SQL Server 2005
04_047046 ch01.qxp 10/18/06 12:18 AM Page 19