Installing SQL Server 2014 (RTM) on Windows Server 2012 R2

I am writing this as an update to my previous SQL Server 2012 blog and a reference for installing the above.  This post focuses on a manual GUI installation with some scripts so you can see the steps. I’ll do an unattended one in the future.

The environment is made up from Hyper-V virtual machines and this is a standalone installation with local service accounts which can be changed to domain accounts (recommended for production installations).

Preparation Tasks

Install the .Net Framework components and open up the SQL Server Firewall ports.

From an elevated command prompt run the following script to open up the default SQL Server DB engine and SSAS  firewall ports.

netsh advfirewall firewall add rule name=”Open SQL Server Port 1433″ dir=in action=allow protocol=TCP localport=1433

netsh advfirewall firewall add rule name=”SQL Server Analysis Services inbound on TCP 2383″ dir=in action=allow protocol=TCP localport=2383 profile=domain

Run the following to install the .net framework components.  ensure the sourcesz\sxs folder exists, it may not. Copy from Windows 2012 R2 source media or use a network location.

Install-WindowsFeature –Name NET-Framework-Features –Source C:\Sources\sxs

Reboot the server.  It’s a good idea to run Windows Update after this step to update the .Net Framework components.

image

Once the server has been rebooted and Windows updates have been applied run setup.exe from the SQL Server 2014 media and select Installation from the left of the screen.

image

Select New Installation from the top right.

image

Select Next on license screen, I have selected Evaluation.

image

Accept the license agreement.

image

A new option appears here to use Microsoft updates if you would like to. I am selecting no as I would patch SQL Server manually at the right time, after testing.

image

Run the product updates check which will look for updates to the setup files.  I am not running it here as I am installing it on the day it came out !  I would recommend you run this for production installs.

Run the setup rules checks.  I have a warning to tell me that the firewall is on and to make the necessary changes which we have already done above.   The .NET check will also give a warning if the computer does not have internet access.  It is safe to continue.

image

Select Features.  Select the top option for a base installation of the SQL Server database engine..

image

I am adding more features than needed here as I am using this installation GUI to generate my configuration file which will populate all the options I may need going forward.  Then I can remove the features I don’t need in future installations.  Select the options you require.,

image

image  image

Note I have also used the C Drive here.  You can change this to install on a different drive which would be recommended where possible.

I am using the default SQL Server instance settings as I do not want to create a named instance.

image

I am also leaving the service accounts as local accounts as I can change them after the installation or in the scripts where necessary.

image

Check the collation is correct for your region, the screen below is fine for the UK which shows that SQL will be case insensitive and accent sensitive using code page 1252.   Ensure your OS region settings are correct too.

image

Database Engine Configuration

Here we can add administrative accounts, set authentication methods and data file locations etc.  I have added the current user who is the local administrator.  Add domain groups that will administer SQL Server here.

I have left the default Windows authentication setting here as this should be used whenever possible.

image

I have specified non default directories for the installation of data files.  This is to provide an example of how you might set up a production environment which has separate volumes for different data files.

image

I have reverted all back to C:\ after the screenshot.  You can also enable FILESTREAM here if you wish.  Or it can be enabled later using the SQL Configuration Manager tool.

Analysis Services Configuration

Specify SSAS user, cube type and data files.  I have left Multidimensional (default).  This is an option that can not be changed after installation.  However you can add a Tabular instance as well or remove the Multidimensional instance and then specify Tabular.

image

Data files.

image

Review summary and configuration file path.

image

I will take this configuration file now from this server to be used in future scripted installation.

image

Complete the installation by clicking Install in the Setup wizard.

Wait for installation to complete.

image

Successful installation reported after about 6 minutes on my VM running on my laptop..

image

Now check your start screen and you won’t see any SQL icons.  Really useful I know.

image

Type SSMS and the icon will appear, right click it and add to start.

image

Once its on the start screen you can pin to task bar too if you like.

Type SQL Server to add other tools such as the installation center, Data Services, SQL Profiler, Config Manager etc. If you can’t find anything for example using SQL Server then type Config for config manager for example.   Here are some of the icons I have added to my start screen.

image

Click on SQL Management Studio and you should see a fully working SQL Server 2014 environment. My server name below is Server-2012 which relates to the server OS.

image

I hope this has been helpful to give you some guidance to install SQL Server 2014.

Advertisements

About Mitesh Chauhan
Mitesh Chauhan, Azure Cloud Solutions Architect. This is my blog where I share articles and thoughts on IT Infrastructure and architecture. The topics I am most passionate about are Implementation and architecture of rock solid Cloud Infrastructure based around SQL Server and Windows Server mainly using Microsoft Azure. MCTS - Azure Architecture MCTS - Azure Implementation MCSE Server Infrastructure (Windows Server 2012) , MCITP SQL Server 2008, Togaf Certified, Prince 2 Practitioner.

3 Responses to Installing SQL Server 2014 (RTM) on Windows Server 2012 R2

  1. Pingback: Installing SQL 2014 on Server 2012 - IT Consulting Solutions Blog

  2. vito- says:

    MR. Mitesh Chauhan, thanks a lot! It really helps me to install a sql server 2014 standard on a new laptop running on windows server 2012 R2.

  3. Sandeep says:

    Hello Mitesh, Thank you very much for this wonderful post for the step-by-step installation guidance.

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

%d bloggers like this: