Alright, for those who are already working as SQL DBA’s this is nothing new and this should just be a piece of cake for you guys. For those who are new to SQL, please consider this article as a primer for SQL Server 2014 installation.
Prerequisites for installing SQL Server 2014:
- 32- bit computers not allowed
- The minimum operating system requirements for the SQL Server 2014 are one of the following:
–>Windows Server 2012
–> Windows 8 RTM
–> Windows Vista SP2
–> Windows Server 2008 SP2
–> Windows 7 SP1
–> Windows Server 2008 R2 SP1
- .NET Framework 3.5 is required.
Listed below are the steps to be followed to install SQL Server 2014:
- Download SQL Server 2014 SP1 from the below mentioned link
- Once you’re done downloading the ISO file, please extract it to your preferred drive location and keep it ready for installation.
- Run the SQL Server 2014 setup as shown below .Make sure that you’re running it with elevated permissions as shown in the image below.
4. Please select “installation” from the list of options given in this screen.
5. This screen shows the types of installation available. Let’s select the first type i.e. “New SQL Server stand-alone installation” as shown in the image below.
- Click on “Run” in the next screen.
7. Since I’m running an evaluation version, I’m going to keep the option as evaluation in this screen.
8. If you want to participate in the CEIP program, then put a checkmark in the box highlighted in the image below .If not just accept the license agreement and click next.
9. The “rule check” is in progress as shown in the screen below.
10. Now if you want you’re SQL server installation wizard to look for any new updates, please put a checkmark in the box shown in the image below. The most preferred and suggested practice is to not check that box as it’s good to have a look at those updates in the Microsoft website and then run them manually . Hence I’m not checking that checkbox here.
11 . You might get an error as shown below . That’s a common error which you would get since I didn’t check the “Check for updates” checkbox .I’m just going to ignore it and proceed further with the installation by clicking next.
12. The set-up files are getting installed as shown in the image below.
13. Now you can see the below mentioned screen displaying warnings about the domain controller, .NET Application Security & Windows Firewall .Now if you’re performing this installation in a test lab its ok to ignore these errors and proceed further.However,if you’re performing this installation in a production server its mandatory that you fix these issues . Since I’m performing this installation in a test lab I’m just going to ignore this error and proceed further with this installation by clicking next.
14. The next screen gives you an option to choose which feature components to install, please click on “SQL Server Feature Installation” and click next.
15. Please select the evaluation features for this instance by checking the appropriate check box. Now how this works is if you want this instance to just have the “Database Engine Services” running, then please check the check box for “Database engine services” alone . Similarly if you want “Analysis Services” as well as “Reporting Services” running in the same instance, then check those check boxes as well.
16. Once you’re done choosing the required features for this instance the installation wizard will calculate the required disk space and will display it and shown in the above image.
17. Once you’re done choosing all the necessary features make sure that you check the “client connectivity tools” and “management tools” (SSMS) check box and click on next. These tools are mandatory to manage SQL Server.
18. You will see the next window where the operation proceeds further as shown in the image below.
19. Now once that’s complete and the operation is successful you will be taken to a window where you’re supposed to make the “Instance Configuration” . Now in SQL Server its very important that you understand the two different types of instances
a) Default Instance –>Choosing the “default instance” will pick up the server name/PC name in which you’re performing the installation and will proceed further with the installation.
b) Named instance–>Choosing the “Named instance” option will ask you to name the instance and the same name will be assigned to the “Instance ID” as well.
To access a default instance once it is installed using SQL Server Management Studio or any other program, you just need provide the computer name. To access a named instance, you will need to provide the name of the instance in the form of “Computername\nameoftheinstance”
It’s always preferable to go with “Named instance “option so that you would be able to differentiate between instances if many instances are installed in the same SQL server.
- Once that’s done the next screen (shown below) will ask you to specify the service account details for all the features that has been chosen , please specify the appropriate username and password as required . Now ,since this is my test lab, I’m going to stick to the defaults. It also gives you the option to choose the “startup type” .It can be either “Automatic” or “Manual”.
However there are couple of things to notice here, if the computer is not part of a domain, use a local user account without Windows administrator permissions. You can create this account using Control Panel -> User Accounts. Please provide a strong password to this account since SQL Server setup will required it on this “Server Configuration” page.
Use a Domain User Account if the service must interact with network service or access domain resources. This account should be pre-created by a domain administrator in AD.
- Make sure that you’re providing the credentials correctly or else you would end up getting a “validation error” as shown below.
- Once that’s done the next screen will ask you to specify your “authentication mode”. You have two authentication modes in SQL Server namely 1. Windows Authentication and 2. Mixed mode (Windows + SQL) authentication. If you choose Windows Authentication then users who are created within SQL server won’t be able to access SQL, so the best and recommended practice is to go with “mixed mode authentication”.
23) Once you’re done specifying the “authentication mode” please click on “Add current user” button as shown in the image below and this will make the current user who is running this wizard as the SA (i.e SQL Server Admin).
24) You can also add few more users to the “SQL Server Administrators” group by clicking on the “Add” button next to “Add current user” as shown in the above image.
25) Once that’s done , please click next and this will take you to the ‘Analysis Services Configuration “ wizard , please specify the “ Analysis Services administrator “ detail as shown in the image below and click next .
26) The next screen would give you the path for the “Data Directories”, you can change this path if required.
27) The next screen would be for “Reporting Services Configuration”, I strongly recommend to go with the second option (i.e. Install Only) as once the installation is complete you can configure “Reporting services” later using the “Reporting Services Configuration Wizard”.
28) Finally, On the Ready to Install page, review the summary of features and components for your SQL Server installation. To proceed, click Install…
You would also notice the “Configuration file path” which has the “configurationfile.ini” and this file can be used later if you want to create a different instance of SQL Server with the same configuration.This file basically holds all the configuration information for this instance of SQL installation.
29) Once you’re done reviewing the summary of features, please click on Install as shown below and you would notice the installation proceeding further.
30) Finally you would get a window as shown below which displays the status of our installation and if everything ran well you would notice a bunch of green tick marks. You can view the “summary log “ file if you want which will give you the complete information of the installation.
31) Now that brings us to the end of the SQ Server 2014 installation and you can open “SQL Server Management Studio” to access it.
If you’re also looking for the new features in SQL Server 2014 , please check this site : _ http://windowsitpro.com/sql-server-2014/top-ten-new-features-sql-server-2014