Installing SQL Server 2005 for the First Time (SQL Server 2005 Setup) - Video Series Video Category: Installing, Deploying, and Upgrading SQL Server Skill Level: 200 (Beginner - Intermediate) Versions/Editions Covered: SQL Server 2005 This is the video series for you if you are new to SQL Server 2005, even if you've had experience with prior versions of SQL Server. This is an extended series that covers every setup screen and walks you through installing SQL Server 2005 for the first time. You'l learn about how to choose the SQL Server Authentication Mode, the Network Libraries, what Collations are and how to choose the correct one for your organization and much, much more.

Videos in this Series:

Title Skill Length Download Part 1 - An Overview of the Setup Process Including Installing the Pre-Requisite...   100 9 mins. Download Part 2 - Choosing the Right Installation For Your Organization   100 12 mins. Download Part 3 - Choosing Your Service Accounts and a Tour of SQL Server 2005's Services   200 6 mins. Download Part 4 - Choosing the Right SQL Server Authentication Mode   200 11 mins. Download Part 5 - Collations and How to Choose the Most Compatible Collation   300 9 mins. Download Part 6 - Verifying Our Installation and Reviewing The Install Logs   100 7 mins. Download Part 7 - A Look at the Installed Folders   100 15 mins. Download

< Return to list of all videos

Miscellaneous Bits & Pieces:

Keyboard Shortcut for SQL Server Management Studio: CTRL+N opens a new query window Many people get confused about licensing for their SQL Server when their SQL Server is used for the company website. Bottom line: buying one license for your SQL Server because the web server is only one user is not sufficient. Microsoft requires that each connection that takes advantage of the data from your SQL Server be licensed. Keyboard Shortcut for Query Analyzer: CTRL+R hides/displays the results pane