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 !!!

Installing SQL Server 2012

This post will serve as a step by step guide to install SQL Server 2012.   Once you are ready with the OS setup and good to go for SQL Server 2012 Installation follow the below steps.

 

Copy the sql server 2012 setup onto the machine where you want to install it.

1

 

Right click on setup and Click Run as administrator
2

Go to Installation page and click on New SQL Server stand-alone installation

 

3

 

Setup Support Rules screen check whether all prerequisites are in place.

4

Click on show details to confirm all rules have passed and proceed by clicking OK. (if there are any failures then exit setup by clicking cancel and resolve the issue before running the setup again).

 

5

 

Setup Support Rules screen check whether all prerequisites are in place.  Click Next to proceed.

 

6

In my case, I already have a named instance installed on my machine. That is why add features to an existing instance of SQL 2012 is enabled.

however, ignore this and select Perform a new installation of SQL Server 2012 and click Next

7

Enter the product key and click Next

8

 

Read and accept the licence Terms to proceed.

9

Here you have two option for installation. first is custom installation, which means you can pick and choose the features you want to install.

Second is to install all Features with Default settings. It is always recommended to install only those features which are required.

10

Select the features to install and click Next

11

Setup will run some rules to foresee any issue. Click Next once complete.

12

Here you have two options to select the type of instance.

Default instance or Named Instance. You can install only only one default instance but can install multiple named instances.

 

13

Review the disk space summary. It will not allow you to proceed if you don’t have enough disk space.

14

 

Select the accounts to run SQL Services and Click Next.

15

You can change the collation if you want. Better leave it default and click Next.

16

 

Choose the authentication mode. Recommended mode is Windows Authentication, as it is more secure. However, if business require select mixed mode. Enter Sysadmin (sa) password twice and select SQL Server admins for this instance and click Next.

 

 

17

Select the Data Directory. If you want you can change it to some other drive. I have left it default.

As per best practices, Data, log, tempdb and backup files should all be on separate drives.

18

FILESTREAM enables SQL Server-based applications to store unstructured data, such as documents and images, on the file system. If required, select this feature, else click Next to proceed.

19

 

If you have selected Analysis Services in Feature Selection page then you will get this.  Specify Users to have Administrative permissions and click on Data Directories tab.

20

you can change the file locations if you want.

 

21

You will get this screen, if you have selected Reporting Services in Feature Selection Page. You have two options here, first to install and configure Reporting Service or Install only.

22

Distributed Replay feature helps you assess the impact of future SQL Server upgrades. Similar to SQL Server Profiler, you can use Distributed Replay to replay a captured trace against an upgraded test environment. Unlike SQL Server Profiler, Distributed Replay is not limited to replaying the workload from a single computer.

Specify users who will have permissions for Distributed Replay controller service.  Group accounts are not support. If you enter group account, it will throw validation error as below.

23

 

24

Specify controller name and click Next.

25

If you want to send windows and SQL Server Error reports to MS then click on check box and click Next.

26

 

27

Click on Install button to start Installation.

28

 

29

After a successful installation, the screen should be all green (as below).

30

Now you have successfully installed SQL Server 2012. Open the management studio to check.

 

 

31

 

I hope this article was helpful.