SQL Server 2012 Setup

During planning an upgrade to SQL Server 2012, you first have to make sure that the target servers meet the necessary hardware and software requirements for SQL Server 2012 Setup to be completed.

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 .

SQL Server Prerequisites Installed by Setup

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.

To install SQL Server 2012 follow the mentioned steps below :

  • Mount SQL Server Media ISO/CD -> Run SQL Server Installation file -> From SQL Server Installation Center –> Click on Installation.

SQL installation_1

  • 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.

SQL 2012 Setup complete.png

  • Open SQL Management Studio.

SSMS welcome

  • Connect to SQL Server using Windows Authentication or SQL Authentication.

Connect to SSMS

For security reasons, Microsoft recommend that you do not install SQL Server 2012 on a domain controller.
SQL Server Setup will not block installation on a computer that is a domain controller, but the following limitations apply:

  • You cannot run SQL Server services on a domain controller under a local service account.
  • After SQL Server is installed on a computer, you cannot change the computer from a domain member to a domain controller. You must uninstall SQL Server before you change the host computer to a domain controller.
  • After SQL Server is installed on a computer, you cannot change the computer from a domain controller to a domain member. You must uninstall SQL Server before you change the host computer to a domain member.
  • SQL Server failover cluster instances are not supported where cluster nodes are domain controllers.
  • SQL Server Setup cannot create security groups or provision SQL Server service accounts on a read-only domain controller. In this scenario, Setup will fail.

For more details check  MSDN

 

Enjoy 🙂

Advertisements

2 thoughts on “SQL Server 2012 Setup

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s