Installing SQL Server 2014 (RTM) on Windows Server 2012 R2
April 2, 2014 3 Comments
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).
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.
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.
Select New Installation from the top right.
Select Next on license screen, I have selected Evaluation.
Accept the license agreement.
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.
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.
Select Features. Select the top option for a base installation of the SQL Server database engine..
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.,
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.
I am also leaving the service accounts as local accounts as I can change them after the installation or in the scripts where necessary.
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.
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.
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.
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.
Review summary and configuration file path.
I will take this configuration file now from this server to be used in future scripted installation.
Complete the installation by clicking Install in the Setup wizard.
Wait for installation to complete.
Successful installation reported after about 6 minutes on my VM running on my laptop..
Now check your start screen and you won’t see any SQL icons. Really useful I know.
Type SSMS and the icon will appear, right click it and add to start.
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.
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.
I hope this has been helpful to give you some guidance to install SQL Server 2014.