Quick-Start Installation of SQL Server 2012

Quick-Start Installation of SQL Ser...

Collapse All

Introduction

The SQL Server Installation Wizard is based on Windows Installer. It provides a single feature tree for installation of the following SQL Server components:

Database Engine
Analysis Services
Reporting Services
Integration Services
Master Data Services
Data Quality Services
Management tools
Connectivity components

You can install each component individually or select a combination of the components listed above. To make the best choice among the editions and components available in SQL Server, see Editions and Components of SQL Server 2012

SQL Server is available in 32-bit and 64-bit editions. SQL Server Setup supports the following installation options:

Installation Wizard
See Install SQL Server 2012 from the Installation Wizard (Setup) for procedural information about installing SQL Server by using the Installation Wizard.
Command Prompt
See Install SQL Server 2012 from the Command Prompt for sample syntax and installation parameters for running unattended Setup.
Configuration File
See Install SQL Server 2012 Using a Configuration File for sample syntax and installation parameters for running Setup through a configuration file.
SysPrep
See Install SQL Server 2012 Using SysPrep for procedural information about installing SQL Server by using SysPrep.
Server Core Installation
See Install SQL Server 2012 on Server Core for procedural information about installing SQL Server on Windows Server Core.
SQL Server 2012 BI Feature Installation
See Install SQL Server 2012 BI Features for information about installing the features that are part of the Microsoft BI platform, that include Analysis Services, Integration Services, Master Data Services, Reporting Services, and several client applications used for creating or working with analytical data.
Failover Cluster Installation
See SQL Server Failover Cluster Installation for procedural information about installing SQL Server on a SQL Server failover cluster.

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.

SQL Server Installation

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

Review installation requirements, system configuration checks, and security considerations for a SQL Server installation. For more information, see Planning a SQL Server Installation.
Run SQL Server Setup to upgrade an existing version of SQL Server to SQL Server 2012. For more information, see Upgrading to SQL Server 2012.
Run SQL Server Setup to install a new instance of SQL Server 2012. For more information, see Installing SQL Server 2012.
After you are finished with SQL Server installation, the next major step is configuration of SQL Server and its components. Use SQL Server utilities to configure SQL Server. For more information, see Configuring SQL Server 2012.

You can find detailed explanations of these tasks in the next section.

Related Tasks

Planning a SQL Server Installation

Before you install SQL Server 2012, you must review the hardware and software requirements, network and Internet considerations, and security considerations to install and run SQL Server. For more information, see Planning a SQL Server Installation and also the following topics:

Task Description	Topic
Review the hardware and software requirements, operating system support, network and Internet considerations, and hard disk space requirements.	Installation Prerequisites
Review the security considerations for a SQL Server installation.	Security Considerations
Review the details of the features supported by the different editions of SQL Server 2012.	Features and Editions
Determine the best choice among the editions and components available in SQL Server.	Editions and Components of SQL Server 2012
Review the hardware configuration, and learn to prepare for SQL Server failover cluster installation.	Before Installing Failover Clustering

Upgrading to SQL Server

You can upgrade existing instances of SQL Server 2005, SQL Server 2008, or SQL Server 2008 R2 to SQL Server 2012. For more information, see Upgrade to SQL Server 2012. Before running SQL Server Setup to upgrade to SQL Server 2012, review the following topics about the upgrade process:

Description	Topic
Documents supported upgrade paths to SQL Server 2012.	Supported Upgrades
Describes Upgrade Advisor, a tool that analyzes instances of SQL Server 2005, SQL Server 2008, and SQL Server 2008 R2 to identify known upgrade issues.	Use Upgrade Advisor to Prepare for Upgrades
Describes the Distributed Replay Utility, a tool that can use multiple computers to replay trace data, simulating a mission-critical workload. By performing a replay on a test server before and after a SQL Server upgrade, you can measure performance differences and look for any incompatibilities your application may have with the upgrade.	Use the Distributed Replay Utility to Prepare for Upgrades
Lists the significant changes that might affect your applications after you upgrade to SQL Server 2012.	Backward Compatibility
The procedural topic to upgrade a stand-alone instance of SQL Server to SQL Server 2012.	Upgrade to SQL Server 2012 Using the Installation Wizard (Setup)
The procedural topic to upgrade an edition of SQL Server 2012 to another edition. For information about supported edition upgrade paths, see Supported Version and Edition Upgrades.	Upgrade to a Different Edition of SQL Server 2012 (Setup)
SQL Server supports upgrade of the Database Engine and Analysis Services from SQL Server 2005, SQL Server 2008, or SQL Server 2008 R2 to SQL Server 2012 failover clusters separately on all failover cluster nodes. Review this topic for more information.	Upgrade a SQL Server Failover Cluster

Installing SQL Server 2012

Review the following topics for information about various installation scenarios for SQL Server 2012.

Description	Topic
Provides links to the topics for installing various components of SQL Server 2012 and procedural topics for installing SQL Server 2012.	Install SQL Server 2012
Review this topic to install SQL Server 2012 on Windows Server Core.	Install SQL Server 2012 on Server Core
Review this topic to add individual features to an existing instance of SQL Server 2012.	Add Features to an Instance of SQL Server 2012 (Setup)
Review this topic to create a new SQL Server failover cluster instance.	Create a New SQL Server Failover Cluster (Setup)
Use this topic to manage nodes in an existing SQL Server failover cluster instance.	Add or Remove Nodes in a SQL Server Failover Cluster (Setup)
Use this topic to install SQL Server client tools on a failover cluster.	Install Client Tools on a SQL Server Failover Cluster
Review the use of the SQL Discovery report to verify the version of SQL Server and the SQL Server features installed on the computer.	Validate a SQL Server Installation
Provides links to procedural topics for installing SQL Server 2012 from the installation wizard, from the command prompt, by using configuration files, and by using SysPrep.	Installation How-to Topics

Configuring SQL Server 2012

After you have installed SQL Server, you can further configure SQL Server by using graphical and command-prompt utilities. See the following topics to configure SQL Server for the first time:

Description	Topic
Use the information in this topic to determine whether you need to unblock ports in a firewall to allow access to Analysis Services or PowerPivot for SharePoint. You can follow the steps provided in this topic to configure both port and firewall settings.	Configure the Windows Firewall to Allow Analysis Services Access
This topic provides an overview of firewall configuration and summarizes information of interest to a SQL Server administrator.	Configure the Windows Firewall to Allow SQL Server Access
This topic describes how to configure SQL Server and Windows Firewall with Advanced Security to provide for network connections to an instance of SQL Server in a multi-homed environment.	Configure a Multi-Homed Computer for SQL Server Access

Uninstalling SQL Server 2012

The following topics describe how to manually uninstall a stand-alone instance and a failover-clustered instance of SQL Server:

Description	Topic
This topic describes how to manually uninstall a stand-alone instance of SQL Server.	Uninstall SQL Server 2012
This topic describes how to uninstall a SQL Server failover-clustered instance.	Remove a SQL Server Failover Cluster Instance (Setup)
This topic provides information about manually removing Data Quality Services (DQS) objects after uninstalling SQL Server or just DQS server.	Remove Data Quality Server Objects

Concepts

Backward Compatibility

Other Resources

Product Specifications for SQL Server 2012

Get Started with Microsoft Books Online for SQL Server