How to Install SQL Server 2012 Step by Step

In this post, we will explain how to install SQL Server 2012 Step by Step.

You might also like to read How to install SQL Server 2019 Developer Edition


Install SQL Server 2012

Before you decide to install SQL Server 2012, you should first make sure that the target servers meet the necessary hardware and software requirements for SQL Server 2012 Setup to be completed.

Hardware Requirements

ComponentRequirement
Memory[1]Minimum:Express Editions: 512 MBAll other editions: 1 GBRecommended:Express Editions: 1 GBAll other editions: At least 4 GB and should be increased as database size increases to ensure optimal performance.
Processor SpeedMinimum:x86 Processor: 1.0 GHzx64 Processor: 1.4 GHzRecommended: 2.0 GHz or faster
Processor Typex64 Processor: AMD Opteron, AMD Athlon 64, Intel Xeon with Intel EM64T support, Intel Pentium IV with EM64T supportx86 Processor: Pentium III-compatible processor or faster

Software Requirements

The SQL Server 2012 Installation Wizard installs the following prerequisites (if they are not already present on the computer):

  • .NET Framework 3.5 SP1.
  • SQL Server Native Client.
  • SQL Server support files.

Setup Requirements for an In-Place Upgrade

SQL Server 2012 Setup has important version-level requirements for upgrading instances of SQL Server 2005, 2008, and 2008 R2 in-place. The basic requirements are as follows:

  • SQL Server 2005: SP4 is required.
  • SQL Server 2008: SP2 is required.
  • SQL Server 2008 R2: SP1 is required.

Note:

  • If your production instance of SQL Server 2005/2008/2008 R2 is installed on Windows Server 2003, you must upgrade to a new server by using a side-by-side upgrade.
  • SQL Server 2012 is not supported on Windows Server 2003 and an in-place upgrade is not possible.

Install SQL Server 2012 Step by Step

  • Mount SQL Server Media ISO/CD -> Run SQL Server Installation file -> From SQL Server Installation Center –> Click on Installation.
Install SQL Server 2012 Step by Step
  • Select the first option to add features to existing installation.
SQL installation_2
  • Click OK after passed all Setup Support Rules.
SQL installation_3
  • Check Product Updates and click Next.
SQL installation_4
  • Again,Check Setup Support Rules and click Next.
SQL installation_5
  • From Installation Types –> Check Perform New Installation –> Next.
Perform A new Installation SQL SSRS.png
  • From Setup Role –> Select SQL Server Feature Installation –> Next.
Set Up Role SQL SSRS
  • From Feature Selection –> Below Instance Features –> Select
    • Database Engine Services.
    • Client Tools Connectivity.
    • Management Tools – Basic.
    • Reporting Service -Native. (Optional)
  • Click Next.
Reporting Service Feature.png
  • Configure Instance by setting the instance name or leave default –> Next.
Instance Configuration
  • Check Disk Space Requirement –> Next.
Check Disk Space
  • In Server Configuration –> Set the Service Account –> Next.
Server Configuration.png
  • In Reporting Service Configuration –> Check Install only.
Install Only SSRS.png
  • In Error Reporting Click Next.
Error Reporting SSRS.png
  • In Installation Configuration Rules Check every thing is passed –> Next.
Installation Configuration Rules SSRS.png
  • In Ready to install –> Click on Install.
Ready to install SSRS
  • Complete the installation wizard and click Finish.
  • Open SQL Management Studio.
  • Connect to SQL Server using Windows Authentication or SQL Authentication.
Connect to SSMS

See Also

2 thoughts on “How to Install SQL Server 2012 Step by Step”

  1. Ellis Szuszkiewicz

    Hello colleagues, how is the whole thing,
    and what you want to say about this piece of writing, in my view its
    actually amazing for me.

Leave a Reply