Learn more about SQL Server tools



solving sql server problems for millions of dbas and developers since 2006 join MSSQLTips for free SQL Server tips













































   Got a SQL tip?
            We want to know!

SQL Server 2008 Installation Process (Part 3 of 3)

MSSQLTips author Tim Cullen By:   |   Read Comments   |   Related Tips: 1 | 2 | 3 | 4 | More > Install and Uninstall

Problem
Our company is ready to proceed with a regular installation of SQL Server 2008. What else can you tell us about the new installation process for SQL Server 2008? In a previous tip we discussed the first part of the new installation process for SQL Server 2008 and this tip covers additional components of the install process.

Solution
In two previous tips we took a look at the initial installation steps for SQL Server 2008.

To pick up where we left off in Part2, the other tab located where you can specify the service accounts is the COLLATION tab. As a review, collation is a method of sorting and comparing strings in a particular way. Note that there are two options - one for the Database Engine and one for Analysis Services:

Collation configuration for SQL Server 2008

The next section has three tabs available. The first is Account Provisioning. In this section you can specify which authentication method to use (Windows or Mixed), as well as which accounts should be assigned to the System Administrator role:

Account Provisioning for the Database Engine

The second tab allows you to specify the default location of databases, as well as the location of TempDB (the default location is the location of the installation):

Folder location specification for databases

The third tab allows you to enable FILESTREAM access. If file IO streaming access is also enabled, you can specify the share name to create:

FILESTREAM options during installation

The next part of the installation applies to Analysis and Reporting Services. As with the Database Engine section of installation, you can specify account provisioning and data directories for Analysis Services:

Account Provisioning for Analysis Services

Data directory locations for Analysis Services

The next section allows you to specify options for installing and configuring Reporting Services:

Options for installing the Reporting Services components

As with most other products from Microsoft, you have the option to send both installation and feature usage statistics to Microsoft:

Options for sending information and statistics to Microsoft

Since the configuration for installation may have changed, the installation process executes the Setup Support Rules to make sure there are no issues that could interfere with the setup:

Execution of the Setup Support Rules

Once the Setup Support Rules process determines there are no issues with the installation configuration, the installation process presents you with a list of configuration options you selected (either default or custom):

Configuration options chosen during the SQL Server 2008 installation process

Similar to the SQL Server 2005 installation process, the progress of each component is shown, as well as the overall progress of the installation:

Installation component during SQL Server 2008 installation

Overall progress of the SQL Server 2008 installation process

Once the installation is complete, a confirmation window appears with links to additional information about SQL Server 2008. In addition, the location of the text file with details about the installation is shown as a link at the top of the page:

Report of the installation process with file location

One of the interesting changes of the SQL Server 2008 installation compared with previous versions is the folder structure of the Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log folder. Rather than having one folder, there is one for each portion of the installation, along with various files including any SQL Discovery and System Configuration Check reports executed during that portion of the installation:

Folder structure of the Setup Bootstrap folder

Next Steps



Last Update: 5/1/2009


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.

View all my tips


print tip Print  
Become a paid author





join MSSQLTips for free SQL Server tips     



Learn more about SQL Server tools
Comments and Feedback:

Post a Comment or Question

Keep it clean and stay on the subject or we may delete your comment.
Your email address is not published. Required fields are marked with an asterisk (*)

*Name   *Email Notify for updates



Comments
Get free SQL tips:

*Enter Code refresh code


 
Sponsor Information







Copyright (c) 2006-2014 Edgewood Solutions, LLC All rights reserved
privacy | disclaimer | copyright | advertise | about
authors | contribute | feedback | giveaways | free t-shirt | user groups | community | events | first timer?
Some names and products listed are the registered trademarks of their respective owners.