Installing Microsoft SQL on Server 2012 R2


Windows Server 2012 R2

Microsoft SQL 2012

Can be obtained from TCAT’s DreamSpark –

Note: you can use the trial software on Server and SQL if you do not have a Dreamspark account.

Files to use as demos:

Virtualization needed:

Hardware needed:

Dual Core computer with 4 GB of RAM (Minimum)

How to:

Install VMWare Player and commit at least 30GB of HDD space, 1 CPU and 2 GB of ram (minimum).

Install Windows Server 2012 R2

Open Windows Server 2012 R2

Extract the SQL ISO into a folder on the Server

Click on Setup

Click on new SQL Server stand-alone installation


SQL Server 2012 Setup will run a Rule Check to make sure your computer is adequate 2 SQL

You should receive a pass for all items checked (.Net 2.0, .Net 3.5, etc.)3 SQL

Next enter your product key if applicable4 SQL

Click Next and accept the terms5 SQL

SQL Server will begin to install if you have corrected any items that may need correcting.7 SQL

This will check for Setup Support Rules.  Correct any failures if necessary.8 SQL

You will now select SQL Server Feature Installation9 SQL

On the next screen, it is recommended that you select all features if you are learning SQL10 SQL

This will in turn check the installation rules such as .Net Framework and Visual Studeio 2010.11 SQL

Create a default instance of SQL.  You can name the Instance ID or select a hard drive for the installation12 sQL

This will now check your space on the virtual machine (HDD space)13 SQL

It is recommended at the next screen to select the SQL Server agent be placed on automatic in the startup type14

Next select Mixed Mode and provide a complex password.  You will also add the Administrator or your account name as a SQL Server Administrator.15 SQL 16

Below is an example of a simple password.  You must use a complex password.17 SQL 18 SQL 19 20 21 22 23 24

Monitor your task manager and CPU to ensure you have adequate resources.25 26 Host 27

SQL Server manager will now be available for you to use.  While I installed this on my work laptop, you must remember to monitor laptops for heat and resource utilization.

Using one of the resources below, you can substitute what you learn on these pages and try writing queries from data you import from the codeplex database (

A few links to SQL tutorials –

Opening Studio

Opening Studio

Running a basic query

Sample Query

Server Manager – if you want desktop icons on Server, you must open the server manager and add a feature (Desktop Experience).


If you right click on the desktop to use Personalize to add desktop icons, it will not be available.  You must use the above wizard to add features  (Desktop Experience to add icons such as Computer, Network, files and control panel).  Personalize will become available after a reboot.

Features 2Features 3

About TCAT Shelbyville IT Department

The Tennessee College of Applied Technology - is one of 46 institutions in the Tennessee Board of Regents System, the seventh largest system of higher education in the nation. This system comprises six universities, fourteen community colleges, and twenty-six Applied Technology Colleges.
This entry was posted in Technology and tagged , , , , , , , , , . Bookmark the permalink.

Leave a Reply

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

You are commenting using your 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