Bookmark and Share Subscribe Bookmark and Share



SQL Server 2012 Installation on Windows Server 2012


 « »    

Run Setup.exe from the installation media

Click Installation on the menu on the left

Then click on the installation you would like to perform, in my case I will be selecting New SQL Server stand-alone installation

Setup will check the server for prerequisites, if everything passes, press OK

Enter your product key and press Next

Accept the license terms, press Next

SQL Server 2012 Setup will check for updates, in my case I unchecked this option because I will be installing SP1 after the installation is complete.

Press Next

Setup files will be installed on your system. Press Install

Now we will proceed with the actual installation and configuration.

Select the type of installation you would like to install, in my case I will be installing SQL Server Feature Installation

Press Next

Select the component you want to include with the installation, then press Next. I typically install the following components for a basic install:

  • Database Engine Services
  • SQL Server Replication
  • Client Tools Connectivity
  • Client Tools Backwards Compatibility
  • Management Tools – Basic
  • Management Tools – Complete

Based on the components you select, setup will check rules to make sure those components can be installed, press Next

I will be installing using the Default Instance, press Next.

Setup will check the disk space requirements, press Next

Service Accounts Tab: In the next step you can configure the service accounts used by SQL. In my case I will be keeping all of the defaults.

Collation Tab: I will keeping the default collation setting of “SQL_Latin1_General_CP1_CI_AS”.

Press Next

Server Configuration Tab: Select the type of authentication you would like to use. In my case I am selecting mixed mode because I will be installing an application that had SQL user accounts. If you select Mixed Mode you must enter a password for the SA account. Press Add Current User or add a windows user that will be a SQL Admin

Data Directories Tab: I will be keeping the defaults, you would want to change this if your system is connected to a SAN.

File Stream Tab: I will be keeping the defaults.

Press Next

Error Reporting, press Next

Setup will check for blocking issues. Press Next

Review your installation components. Press Install

Installation will start, once the installation has completed press Close

SQL Server Management Studio is now located under Start

Launch SQL Server Management Studio and verify connectivity

    Did I save you time and headaches? Buy me a cup of coffee.
    The more coffee I drink the more articles I can write.