One of Microsoft's most long-awaited releases, SQL Server 2005 has finally hit the market and brought with it significant new features and changes from previous versions.
In this gallery, Scott Lowe walks through a sample deployment of SQL Server 2005. The installation procedure has changed quite a bit from previous versions, and this will hopefully help you find the potential pitfalls before you undertake your own deployment.
When you first put the SQL Server 2005 CD or DVD into your server, you're provided with an introductory window that outlines the product and what you need in order to be able to run it. The SQL Server 2005 introduction screen. Note that, even when you use the single DVD for installation, you still get the "Disc 1 of 2" text at the top of this window. This article is also available as a TechRepublic download and article.
To get the installation underway, under the Install heading, choose the "Server components, tools, Books Online, and samples" option. The first screen that pops up is the end user license agreement for the product. You need to check the box "I accept the licensing terms and conditions" and click the Next button to continue.
Bill Detwiler is Managing Editor of TechRepublic and Tech Pro Research and the host of Cracking Open, CNET and TechRepublic's popular online show. Prior to joining TechRepublic in 2000, Bill was an IT manager, database administrator, and desktop support specialist in the social research and energy industries. He has bachelor's and master's degrees from the University of Louisville, where he has also lectured on computer crime and crime prevention.