SQL Server 2008 Installation Process (Part 2 of 3)

By:   |   Comments (1)   |   Related: 1 | 2 | 3 | 4 | > Install and Uninstall


Our company has decided to migrate to SQL Server 2008. In a previous tip you discussed the initial options and tools available for preparation for, and installation of, SQL Server 2008. What else has changed with the installation process?


The installation described in this tip was performed using the DVD from the Microsoft Action Pack subscription, so there may be subtle differences in the first part of the installation. The first part of the installation involves running the System Configuration Checker. As a review, the System Configuration Checker evaluates the current machine for conditions that may negatively impact the installation process.

Results of the System Configuration Checker

One screen that appears quite often during the installation process is the status window, indicating that the current operation is being processed:

Status window that appears during installation operation processing

Once the System Configuration Checker has completed it evaluation, I was asked for which installation type I wanted. The DVD had a number of options on it, including an evaluation copy of SQL Server 2008 Enterprise, and SQL Server 2008 Express with and without the Advanced Services. If the Enterprise Edition is chosen, you can enter the Product Key on this page:

Edition selection for the installation

As usual, the Terms and Conditions window:

Terms and Conditions window

As with SQL Server 2005, there are a number of Support files that must be installed prior to the main installation point:

Support Files installation process

Another evaluation of the System Configuration Checker/Setup Support Rules is performed to make sure there are no recurring issues prior to installation:

Result of the System Configuration Checker after the SQL Server Support files are installed

Microsoft included as part of the SQL Server 2008 installation a progress area on the left side of the installation screen so you can determine where you are the installation process. It is present from the current step to the end of the installation:

feature selection

The next part of the installation involves specifying whether to install a named or default instance, as well as the location of the instance root directory. Notice on this page that there is an "Instance ID". The instance ID is used during folder creation and naming to help identify the instance folder. By default, it is named the same as the instance name:

Instance/Folder specification screen

Once the instance and folder installation information has been specified, a confirmation screen appears so you can review the information and modify, if necessary:

Confirmation of instance and folder information specified

The next part of the installation allows you to specify which account will run each service, as well as the collation to be used. As with SQL Server 2005, there are a number of services involved, and Microsoft recommends that you use a different account for each service. In my particular instance, I chose to use one account for all services, since this is a small environment. A window is presented so that you can select an account from either the local machine or domain:

Specification of the accounts to be used for each service involved in SQL Server 2008

Selecting to use one account for all services

Once you choose the account you wish to use, another screen will appear that allows you to enter the password for the account.

As you can see, there are a number of differences in the initial process for installing SQL Server 2008. In the last tip on generic SQL Server 2008 installation we will discuss the rest of the installation, including specifying where data files are installed, FILESTREAM configuration, and configuration of ancillary services like Integration Services, Analysis Services, and Reporting Services.

Next Steps

sql server categories

sql server webinars

subscribe to mssqltips

sql server tutorials

sql server white papers

next tip

About the author
MSSQLTips author Tim Cullen Tim Cullen has been working in the IT industry since 2003 and currently works as a SQL Server Reports Developer.

This author pledges the content of this article is based on professional experience and not AI generated.

View all my tips

Comments For This Article

Thursday, January 13, 2011 - 8:46:05 PM - Jeremy Kadlec Back To Top (12604)


Check out part three of this tip:


Thank you,
Jeremy Kadlec

get free sql tips
agree to terms