MCSE Study Guide (+MSCD & other Microsoft Certification qualifications)

Lesson 2 :  Performing the installation.
——————————————————————————–

In this topic, we will walk through an installation of SQL Server.

When you insert the SQL Server CD ROM, it should autorun. If it does not, run the file Setup.bat on the root directory of the CD ROM.

One of the options you will see on the first menu is “Install SQL Server 7.0 Prerequisites”. This will detect what operating system you are running on and tell you if there are any additional requirements. For example, for NT4 you must install Service Pack 4 before SQL Server.

If you do not need to install any prerequisites on your PC, then select the option “Install SQL Server 7.0 Components

Your next choice is between installing the full version of SQL Server and the Desktop version. In addition, you have the option of installing OLAP Services or English Query. Don’t worry about these two options at this stage. Click to install the full version of SQL Server.

After accepting the licensing agreement and entering your name, company and license number, you will be able to choose from Custom Installation, Typical Installation or Compact Installation.

Most users will select the Typical Installation, and further down we’ll describe this in more detail. For training purposes, however, I suggest you select Custom Installation. You now have the option of changing the folder to which SQL Server should be installed. The default is C:\MSSQL7.

You can select which components and subcomponents you wish to install, from the following:

Upgrade Tools
Replication Support
Client Management Tools
Online Documentation
Development Tools
Samples

The next stage is to select a character set (default=ISO 1252), a sort order (default=Dictionary order, case-insensitive) and a Unicode Collation (default=General, case-insensitive)

Choose the network libraries you want to install (defaults for NT=Named Pipes, TCP-IP and Multiprotocol)
Finally, you have some security options. SQL Server need to run under a user name and password. You can opt to use the “LocalSystem” account, a special system account that is always present, and is typically used to run services. If you’re going to give SQL Server a real user name and password, though, it’s advisable to set one up specially, rather than use the actual domain Administrator account.

After you have selected all your options, SQL Server will self-install.