Installing SQL Server 2016 Developer Edition and SQL Server Management Studio Step by Step

Installing SQL Server 2016 Developer Edition

First, you need SQL Server 2016 Developer Edition. Here is a link of how to get SQL Server 2016 Developer Edition for free: SQL Server 2016 Developer Edition is Free.

Once you have SQL Server 2016 Developer Edition, start the installation by executing setup.exe. SQL Server Installation Center starts:

1

Click the Installation page:

2

Click the link labelled “New SQL Server stand-alone installation or add features to an existing installation”:

3

Accept the defaults on the Product Key page – Developer Edition and no product key, then click the Next button:

4

On the License Terms page check the “I accept the license terms” checkbox and click the Next button:

5

If the Install Rules page tests pass, click the Next button to proceed:

6

On the Feature Selection page, select the features you want to install and a location for the instance root files. I installed the Database Engine Services, Analysis Services, Reporting Services – Native, Integration Services, and Client Tools Connectivity, Client Tools Backwards Compatibility, Master Data Services. Click the Next button to proceed:

7

On the Instance Configuration page select default instance if it’s your first time installing SQL Server, otherwise select Named instance and give an instance name and clicked the Next button:

8

On the Server Configuration page, I accepted the defaults for services and startup types:

9

On the Database Engine Configuration page, I opted to use Mixed Mode, supplied a strong password, and added the current user to the SQL Server Administrators group.

10

On the Analysis Services Configuration page, select Multidimensional and Data Mining Mode (from where you can also see Tabular Mode and PowerPivot Mode), and click Add Current User, then click Next button:

11

On the Reporting Services Configuration page, select install only, then click the Next button:

The Ready to Install page displayed; I clicked the install button to begin the installation.

12

Installing SQL Server Management Studio

Once the installation completed, I clicked the “Install SQL Server Management Tools” link on the SQL Server Installation Center’s Installation page:

13

The link takes me to a page titled Download SQL Server Management Studio.

14

Once the download is complete, click the Run button to install SSMS 2016:

15

The SQL Server Management Studio (SSMS) installation starts:

16

 

2 thoughts on “Installing SQL Server 2016 Developer Edition and SQL Server Management Studio Step by Step”

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