The Installation Process

As in previous versions, you can install SQL Server 2012 services with a graphical user interface: the Installation Center. Unattended and automated deployments are also possible using the Command Line and PowerShell.

You can install all the SQL Server 2012 services by following the installation wizards launched from the Installation Center. Some of the services and features that can be installed using Installation Center include Database Services, Integration Services (SSIS), Analysis Services (SSAS), Reporting Services (SSRS), Master Data Services (MDS), and Data Quality Services (DQS). Additionally, management and development tools such as SQL Server Management Studio (SSMS) and SQL Server Data Tools (formerly BIDS) can be installed through Installation Center. Additional settings and configurations may be necessary after the core installation process completes.

The scope of this chapter includes the installation process of a SQL Server 2012 standalone Database Engine instance.

SQL Server 2012 Installation Center

The Installation Center provides a graphical user interface that groups common installation tasks and resources in seven logical sections:

  • Planning
  • Installation
  • Maintenance
  • Tools
  • Resources
  • Advanced
  • Options

To launch the Installation Center, locate and execute the Setup.exe application in your installation media. Figure 3.1 shows the Installation Center.

Figure 3.1 SQL Server 2012 Installation Center.

The initial section of the Installation ...

Get Microsoft SQL Server 2012 Bible now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.