SQL Server 2012 Installation Guide

 

We will start with list the minimum hardware and software requirements to SQL Server 2012. For both x64 and x86 editions, MS suggests the use of NTFS file system, you must install Powershell 2.0, both .NET 3.5 SP1 and .NET 4.0 is required. The hardware requirements are:

SQL Server 2012 Express

WOW64 (Windows x86 on Windows x64) is a piece of x64 editions of Windows that enables x86apps to run natively in x86 mode. Apps function in x86 mode, even though the underlying operating system is x64 operating system. WOW64 is supported only for stand-alone instances of SQL Server. WOW64 is not supported for SQL Server failover cluster installations

For SQL Server x64 edition installations on x64 supported OS, Management Tools are supported in WOW64. On a supported x64 operating system, SQL Server x86 edition installations can be installed to the WOW64 x86 subsystem of ax64 server.

SQL Server editions that are supported on Server 2008 R2 x64x64 Standard are also supported on Windows Small Business Server x64x64.

SQL Server 2012 is now supported on Windows 2008 R2 SP1 server core operating system. Server core functionality is available on the following Server 2008 R2 editions:

SQL Server 2012 Requirements

Step-by-Step Installation

To install SQL Server 2012

  1. Double-click Setup.exe from ISO. The Installation Wizard runs the SQL Server Installation Center. new installation of SQL Server is created by, clicking Installation in the left-hand area, and then click New SQL Server stand-alone installation or add features to an existing installation.
  2. The System Config Checker runs a detection operation on your computer. To stay, click OK. You can view the specifics on the screen by clicking Show Details, or as an HTML report by clicking View detailed report.
  3. On the Setup Support Files page, click Install.The System Config Checker runs a discovery operation on your computer. To continue, click OK. You can view the details on the screen by clicking Show Details, or as an HTML report by clicking View detailed report.
  4. You can specify the language for your instance of SQL Server if you are installing on a localized operating system and the installation media includes language packs for both English and the language corresponding to the operating system. clickNext and continue.
  5. On the Product Key page, select an option to indicate whether you are installing a free edition of SQL Server, or a production version of the product that has a PID key. To continue, click Next.
  6. On the License Terms page, review the license agreement and, if you agree, select the I accept the license terms check box, and then click Next. To help improve SQL Server, you can also enable the feature usage option and send reports to MS. 
  7. On the Product Updates page, the latest available SQL Server product updates are displayed. If you don't want to include the updates, clear the Include SQL Server product updates check box. If no product updates are discovered, SQL Server Setup does not display this page and auto advances to the Install Setup Files page.
  8. On the Install Setup files page, Setup provides the progress of downloading, extracting, and installing the Setup files. If an update for SQL Server Setup is found, and is stated to be included, that update will also be installed.
  9. The System Config Checker verifies the system state of your computer before Setup continues.
  10. On the Setup Role page, select SQL Server Feature Installation, and then click Next to continue to the Feature Selection page.
  11. On the Feature Selection page, select the components for your installation. A description for each component group appears in the Feature description pane after you select the feature name.
  12. You can also specify a custom directory for shared components by using the field at the bottom of the Feature Selection page. To change the installation path for shared components, either update the path in the field at the bottom of the dialog box, or click Browse to move to an installation directory. The default installation path is C:\Program Files\MS SQL Server\110\.

    The path stated for the shared components must be an absolute path. The folder must not be compressed or encrypted. Mapped drives are not supported. If you are installing SQL Server on a 64-bit Operating System, you will see the following options:
    • Shared feature directory
    • Shared feature directory (x86)

    The path stated for each of the above options must be different.

  13. On the Installation Rules page, Setup verifies the systemstate of your computer before Setup continues.
  14. On the Instance Config page, specify whether to install a default instance or a named instance.
    1. Instance ID — By default, the instance name is used as the Instance ID. This is used to identify installation directories and registry keys for your instance of SQL Server. This is the case for default instances and named instances. For a default instance, the instance name and instance ID would be MSSQLSERVER. To use a non-default instance ID, specify a different value for Instance ID text box.
    2. Instance root directory — By default, the instance root directory is D:\Program Files\MS SQL Server\110\. To specify a non-default root directory, use the field provided, or click Browse to locate an installation folder.

      All SQL Server service packs and upgrades will apply to every component of an instance of SQL Server.
    3. Installed instances — The grid shows instances of SQL Server that are on the computer where Setup is running. If a default instance is already installed on the computer, you must install a named instance of SQL Server 2012.
  15. The Disk Space Requirements page calculates the required disk space for the features that you specify. Then it compares the required space to the available disk space.
  16. Work flow for the rest of this topic depends on the features that you have stated for your installation. You might not see all the pages, depending on your selections.
  17. Use the Server Config — Service Accounts page to specify login accounts for SQL Server services. The actual services that are configured on this page depend on the features that you selected to install.

    You can assign the same login account to all SQL Server services, or you can configure each service account individually. You can also specify whether services start automatically, are started manually, or are disabled. MS recommends that you configure service accounts individually to provide least privileges for each service, where SQL Server services are granted the minimum permissions they have to have to complete their tasks.

    To specify the same logon account for all service accounts in this instance of SQL Server, provide credentials in the fields at the bottom of the page.

    When you are finished specifying login information for SQL Server services, click Next.
    Use the Server Config — Collation page to specify non-default collations for the Database Engine and Analysis Services. Use the Database Engine Config - Account Provisioning page to specify the following:
    • Security Mode — Select Windows Authentication or Mixed Mode Authentication for your instance of SQL Server. If you select Mixed Mode Authentication, you must provide a strong password for the built-in SQL Server system administrator account.

      After a device establishes a successful connection to SQL Server, the security mechanism is the same for both Windows Authentication and Mixed Mode.
    • SQL Server Administrators — You must specify at least one system administrator for the instance of SQL Server. To add the account under which SQL Server Setup is running, click Add Current User. To add or remove accounts from the list of system administrators, click Add or Remove, and then edit the list of users, groups, or computers that will have administrator privileges for the instance of SQL Server. When you are finished editing the list, click OK. Verify the list of administrators in the Config dialog box. When the list is complete, click Next.

Use the Database Engine Config - Data Directories page to specify non-default installation directories. To install to default directories, click Next.

Use the Database Engine Config - FILESTREAM page to enable FILESTREAM for your instance of SQL Server.

When you are finished editing the list, click OK. Verify the list of administrators in the Config dialog box. When the list is complete, click Next.

To continue, click Next.

Specify the Working Directory for the Distributed Replay client service. The default working directory is <drive letter>:\Program Files\MS SQL Server\DReplayClient\WorkingDir\.

Specify the Result Directory for the Distributed Replay client service. The default result directory is <drive letter>:\Program Files\MS SQL Server\DReplayClient\ResultDir\.

To continue, click Next.

To continue, click Install. SQL Server Setup will first install the required prerequisites for the selected features followed by the feature installation.