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.

 

Advertisements
Leave a comment

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: