Export (0) Print
Expand All
9 out of 25 rated this helpful - Rate this topic

Installing SQL Server 2008 R2

The SQL Server Installation Wizard is Windows Installer-based. It provides a single feature tree to install all SQL Server components:

  • SQL Server Database Engine

  • Analysis Services

  • Reporting Services

  • Integration Services

  • Replication

  • Management tools

  • Documentation

Note   SQL Server is available in 32-bit and 64-bit editions. The 64-bit and 32-bit editions of SQL Server are installed either through the Installation Wizard, or at a command prompt. For more information about SQL Server components, see Editions and Components of SQL Server 2008 R2 and Features Supported by the Editions of SQL Server 2008 R2.

By default, sample databases and sample code are not installed as part of SQL Server Setup. To install sample databases and sample code for non-Express editions of SQL Server, see the CodePlex Web site. To read about support for SQL Server sample databases and sample code for SQL Server Express, see Databases and Samples Overview.

Regardless of whether you use the SQL Server Installation Wizard or the command prompt to install SQL Server, the Setup process involves the following steps:

Planning a SQL Server Installation

Describes how to prepare your computer for SQL Server:

  • Review hardware and software requirements.

  • Review System Configuration Checker requirements and blocking issues.

  • Review security considerations for a SQL Server installation.

Configuring SQL Server 2008 R2

After Setup finishes, you can configure SQL Server by using graphical and command prompt utilities.

Considerations for Side-by-Side Instances of SQL Server 2008 R2 and SQL Server 2008

This section describes the considerations for side-by-side installations of SQL Server 2008 R2 and SQL Server 2008.

Considerations for Installing the SQL Server Database Engine

Describes how to install and configure the SQL Server Database Engine.

Considerations for Installing Analysis Services

Describes how to install and configure Analysis Services.

Considerations for Installing SQL Server PowerPivot for SharePoint

Describes how to install and configure Analysis Services and PowerPivot server components in a SharePoint farm.

Considerations for Installing Reporting Services

Describes how to install and configure Reporting Services.

Considerations for Installing Integration Services

Describes how to install and configure Integration Services.

Considerations for Installing SQL Server Replication

This section describes how to install and configure SQL Server Replication.

Considerations for Installing SQL Server Management Tools

This section describes how to install and configure SQL Server management tools.

Considerations for Installing SQL Server Samples and Sample Databases

This section describes how to install SQL Server AdventureWorks2008R2 samples.


 Stay Up to Date with SQL Server Install, and Upgrade information

For the latest downloads, articles, videos and troubleshooting information from Microsoft, as well as selected solutions from the community, visit the SQL Server Setup page

For automatic notification of these updates, subscribe to the RSS feeds available on the page.

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.