SQL Server 2008 Installation Process (Part 1 of 3)


By:   |   Updated: 2009-02-02   |   Comments (3)   |   Related: 1 | 2 | 3 | 4 | More > Install and Uninstall


Problem

The company where I work is investigating a migration to SQL Server 2008. I have heard that the installation process for SQL Server 2008 differs from previous installation processes. So, how much different is the installation process? In this three-part tip series, we will review the installation process for SQL Server 2008, which differs quite a bit from SQL Server 2000 and SQL Server 2005 installations.

Solution

The crux of the installation process for SQL Server 2008 is the SQL Server Installation Center. There are various tools and documentation that can assist you in preparing for a number of different installation options and mitigate the chances of unsuccessful installations. The Installation Center has seven main sections which are Planning, Installation, Maintenance, Tools, Resources, Advanced and Options.  Let's start to dig into each of these areas.

Planning

The planning section gives you all the tools and information you need to make sure your server(s) have the minimum requirements and plan for whatever installation option you choose:

SQL Sever 2008 Main Installation Screen

Of particular interest in this section is the System Configuration Checker. It runs a variety of checks on the current server to ensure a successful installation of SQL Server 2008, such as whether the current user has administrative rights to install products, any unsupported SQL Server installations on the server, or whether the current server is a domain controller. In the case of this installation, I have only one server that serves many purposes including being a domain controller.  Here is the sample output:

System Configuration Check results

When you click on the Status link a message box will give additional information on the particular test executed:

Warning indicating that installation on a domain controller is not recommended

Installation

The installation section allows you to install a new stand-alone instance, add features to a current instance, install a new failover cluster, add a new node to a failover cluster, or upgrade a SQL Server 2000 or SQL Server 2005 instance:

Installation Options for the SQL Server Installation Center

Maintenance

The Maintenance section allows you to repair a corrupted SQL Server instance, remove a node from a failover cluster, or perform an upgrade of a current edition:

Maintenance Options for the SQL Server Installation Center

Tools

The Tools section offers methods for upgrading SSIS packages to the 2008 format, execute the System Configuration Check, and run a SQL Server features discovery report. This report gives information on all instances installed on the current server and is rendered as an HTML form. A copy of the report is stored in C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\<Date> (20081229) _ 212810\SqlDiscoveryReport.htm:

Tools Options for the SQL Server Installation Center
Sample SQL Server Setup Discovery Report
Next Steps


Last Updated: 2009-02-02


get scripts

next tip button



About the author





Comments For This Article




Tuesday, September 04, 2012 - 6:45:52 AM - anwaralikhan Back To Top (19381)

http://msdn.microsoft.com/en-us/library/dd299415.aspx


Thursday, January 13, 2011 - 8:41:55 PM - Jeremy Kadlec Back To Top (12603)

Everyone,

Check out part 2 and 3 of this tip for a full picture of the SQL Server 2008 installation process:

http://www.mssqltips.com/tip.asp?tip=1728

http://www.mssqltips.com/tip.asp?tip=1742

Thank you,
Jeremy Kadlec


Monday, February 16, 2009 - 10:16:50 AM - mihart Back To Top (2777)

For help installing SQL Server 2008, please also take a look at this video:

http://msdn.microsoft.com/en-us/library/dd299415.aspx

Michele 

 



download





Recommended Reading

SQL Server 2008 Installation Process (Part 2 of 3)

SQL Server 2008 Installation Process (Part 3 of 3)

SQL Server 2008 Client Tools Installation

Cleanly Uninstalling Stubborn SQL Server Components

SQL Server Setup Error - There was an error generating the XML document. Error code 0x84B10001.














get free sql tips
agree to terms