SQL Server- Installing SQL Server 2014

In this tutorial, I will show you step by step installation of SQL Server 2014 Evolution version (Default Instance).

Before you start, it’s highly recommended to check hardware and software requirements for Installing SQL Server 2014.

 

Step By Step (Installation)

1. Go to the Installation Setup (SQL Server 2014). Right click setup.exe and run as administrator.

1

2. Upon starting the installation, you will get this window. Go to the Installation tab on the left and then click “New SQL Server stand-alone installation or add features to an existing installation.

 

2

3. Enter the product key and click Next

 

 

3

4. Accept the license term in order to continue.

 

 

4

5. It checks your machine to make sure it meets the hardware and software requirements to install SQL Server. If you get any Errors in the results, do not move to the next step.

 

 

5

6. Choose the first option in order to install SQL Server, and Click Next.

 

6

7. Select which features to install. I have selected only limited features (Database engine, management tolls, client tools, integration services). Click Next to continue:

 

7

8. Select Default instance and click next.

 

 

8

9. In this step you can select the service accounts for the SQL Server actions. Each service in SQL Server represents a process or a set of processes to manage authentication of SQL Server operations with Windows. Each service can be configured to use its own service account. Its recommended to use domain account to run sql services in production. However, i have slected local account.  Click next to proceed.

 

9

10. Select collation and click next.

 

 

10

11. SQL Server can operate in one of two security (authentication) modes: (a) Windows Authentication mode which allowed a user to connect through an operating system user account. or (b) Mixed Mode which allowed users to connect to an instance of SQL Server using either Windows Authentication or SQL Server Authentication.

I have selected Mixed Mode and have spacified password for sa account.  I have also added my account as sql server adminstrator. Click next to proceed.

 

 

11

12. By default SQL Server uses the system operation disk  Thus it is highly recommended to use the best practice according to your specific system and usage. Separating the LOG files from the data files can improve performance significantly. The system database tempDB is used extensively by SQL Server. This database is rebuilt each time the server is restarted. It is best practice to separate data, transaction logs, and tempdb for environments where you can guarantee that separation.

As i have installing SQL on a virtual machine which has only one drive i.e C. I am going ahead with the default directory locations. Click next to proceed.

 

 

 

12

13. Review the summary of features and components for your SQL Server installation. To proceed, click Install

 

13 14 15 16

14. On the “Complete” page, you can view the Setup summary log by clicking the blue link provided on the bootom this page. To exit the SQL Server Installation Wizard, click Close. We have successfully installted SQL Server 2014.

 

 

 

17

Connecting to SQL Instance:

Go to the Start menu, and choose SQL Server 2014 Management Studio (SSMS), to connect to the newly created instance of SQL Server 2014

 

 

18

 

 

 

Hope this was helpful !!!