How To Install SQL Server 2014 (Lesson-1)

SQL Server-2014

Microsoft SQL Server is a Relational Database Management System (RDBMS) developed by Microsoft. It is a highly scalable product that can be run on anything from a single laptop, to a network of high-powered cloud servers, and anything in between.

SQL Server comes with a number of tools to help you with your database administration and programming tasks.

Some typical database administration and programming tasks could include:

• Create & maintain databases
• Create & maintain tables
• Create & maintain other database objects such as stored procedures, views, etc
• Create & maintain and schedule data backups
• Replication (eg, create a copy of the database)
• Create & maintain users, roles, etc
• Optimization tasks
• Connection of Other Software by OPC

How to Install SQL Server 2014

Step By Step

The following installation was performed using the Installation Wizard.

1. Double click on the installation file (mine was an ISO file called SQLEXPRWT_x64_ENU at 853,214 KB
2. Click Yes if asked Do you want to allow the following program to make changes to this computer
3. When prompted to Choose Directory for Extracted Files, click OK to use the default directory, or click Browse... and select a different directory:

4. The installation will begin:

    5. Please select “installation” from the list of options given in this screen.

6. Let’s select the first type i.e.  “New SQL Server stand-alone installation” as shown in the image below

7.Click on “Run” in the next screen.

 8. Now  I’m running an evaluation version, I’m going to keep the option as evaluation in this screen

9.If not just accept the license agreement and click next

10. The “rule check”  is in progress as shown in the screen below.

11.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

12. 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.

13. The set-up files are getting installed as shown in the image below

14. 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.

15. The next screen gives you an option to choose which feature components to install, please click on “SQL Server Feature Installation” and click next.

16. 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

17.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

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

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.

20. 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”.

21.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.

22.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.

23. Make sure that you’re providing the credentials correctly or else you would end up getting a “validation error” as shown below.

24. 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 Authenticationand 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”

21. 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).

2    22. 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.

2    23. 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 .

z    

     24.The next screen would give you the path for the “Data Directories”, you can change this path if required

      

d   25.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”.

26. 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.

27. Once you’re done reviewing the summary of features, please click on Install as shown below and you would notice the installation proceeding further.

28. 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.