Nisarg Upadhyay
Download SQL Server developer edition iso file

How to install SQL Server developer edition

August 31, 2021 by

In this article, we are going to learn how we can install the SQL Server developer edition. We are installing the SQL Server 2017 developer edition on my workstation.

Before we begin the installation, we must download the web installer of SQL Server from here. This installation file allows us to download the iso file of the SQL Server 2017. Once the installer is downloaded, run it.

On the Select installation type screen, choose Download Media.

Download SQL Server developer edition iso file

On the next screen, choose the language of the SQL Server software, the type of package that you want to download, and provide the download location.

Choose the SQL Server developer edition installer

Once the download completes, open the iso file and run the setup.exe file.

SQL Server developer installation files

In the SQL Server installation wizard, click Installation and select the New SQL Server stand-alone installation link.

SQL Server installation center

Using wizard, we can install any of the following free editions of the SQL Server 2017.

  1. Evaluation
  2. Developer
  3. Express

Choose Developer edition from the list of the SQL Server free editions.

Product Key

On the License term screen, review the license terms carefully and click on I Accept.

License Terms

Now, SQL Server performs a setup configuration (Global Rules) check and generates a report. If any of the rules fail, the setup will not continue.

Global Rules

Screenshot of the configuration report generated on my workstation.

Global Rule configuration report.

On the next screen, you can choose to run the SQL Server updates. Ideally, the cumulative updates must be check before applying to the SQL Server. I am installing the SQL Server on my workstation, so I have chosen an option to check for the latest updates of SQL Server.

Enable microsoft update for SQL Server

Now, SQL Server performs an install configuration (Install Rules) check and generates a report. If any of the rules fail, the setup will not continue.

Install Rules

The report generated on my workstation is the following.

Install Rules report

On the feature selection screen, you can perform the following tasks.

  1. Choose the components and SQL Server instance features
  2. Specify the SQL Server instance root directory, share feature directory, and shared feature directory for x86 based components

To install all features, click on Select All. The instance root directory and shared feature directories are unchanged.

Feature selection

You can specify the instance type on the Instance Configuration screen. We can choose the default instance or named instance. I have already installed a default instance, so I am installing Named Instance.

Instance configuration

On the Server configuration screen, you can configure the following:

  1. Specify the service accounts for SQL Server services
  2. Select collation for the database engine and analysis service
  3. Enable instant data file initialization

In our case, I am not changing the default service accounts configured by SQL Server. I have enabled instant data file initialization.

Server configuration service account

I have not changed the default collation of the database engine and analysis engine service.

Server configuration Collation

On the database engine configuration mode, we can configure the following:

  1. Choose authentication mode (Windows authentication mode and mixed mode) and specify the SQL Server administrator
  2. Specify the data root directory, User database directory, and user database log directory
  3. Specify the following items for TempDB
    1. Initial size and Autogrowth value of TempDB data file and Log file
    2. Specify the total number of TempDB data files
    3. Location of TempDB data file and log file
  4. Specify the FILESTREAM parameters

In our case, the Authentication mode is mixed, and I have added the current user as an SQL Server admin.

Specify authentication mode

Data directories are not changed

Specify data directories

Added five TempDB data files. The initial size of the TempDB data file is 1 GB, and the auto-growth value is 512 MB. The TempDB log file is 1 GB, and the Autogrowth value is 256 MB. The location of the TempDB database files is unchanged.

Specify TempDB directories

The FILESTREAM is not enabled.

Enable FILESTREAM

On the Analysis Service Configuration screen, you can perform the following tasks.

  1. Specify the Server Mode. You can choose any of the following:
    1. Multidimensional and Data Mining mode
    2. Tabular Mode
    3. PowerPivot Mode
  2. Specify the analysis services administrators
  3. Specify the data directories of the SQL Server analysis service

In our case, I have chosen Tabular mode in Server Mode and added the current user as an administrator of the analysis services.

Select server mode of analysis service

I did not change the data directories of the analysis service.

Select data directories of analysis service

On the Integration Services Scale Out Configuration – Master Node screen, you can perform the following:

  1. Specify the Port number that can be used to communicate worker threads
  2. Create an SSL certificate for communication between the master node and worker node

In our case, I have not changed any values.

Integration Services Scale Out Configuration – Master Node

On the Integration Services Scale Out Configuration – Worker Node screen, you can perform the following tasks:

  1. Specify the end-point to communicate with the Master Node
  2. Specify the SSL certificate that is used to communicate with the Master node

In our case, I have not changed values.

Integration Services Scale Out Configuration – Worker Node

On the Distributed Reply Controller screen, you must specify the users who have administrative privileges on distributed reply controller service. I have added the current user as an administrator.

Distributed Reply controller

On Distributed Reply Client screen, you must specify

  1. Controller Name
  2. Working Directory
  3. Result Directory

I have provided the appropriate controller name and did not change Working Directory and Result Directory.

Distributed reply client

On Consent to install Microsoft R Open screen, click on Accept.

Consent to install MS R language

On the Consent to Install Python screen, click on Accept.

Consent to install Python language

On the Ready to install screen, you can view the summary of the list of the components and features installed by the SQL Server installer. Review the list and click on Install.

Review features

The SQL Server installation process begins.

SQL Server installation begins

Once installation completes, you can view the list of SQL Server developer edition component that has been successfully installed.

SQL Server developer edition installed successfully

Click on Close and Reboot the server/workstation.

Connect to the SQL Server instance

We can use SQLCMD, Powershell command lets, or SQL Server management studio to access the SQL Server databases. I am using SQL Server management studio to connect the SQL Server instance. As we have created a named instance, the server name should be in HostName/InstanceName format. The screenshot of the connect to server dialog box is the following.

Connect to SQL Server developer edition

Run the following query to view the edition of the SQL Server.

Version of SQL Server developer edition

Summary

In this article, I have explained the step-by-step installation process of the named instance of the SQL Server developer edition.

Nisarg Upadhyay
Latest posts by Nisarg Upadhyay (see all)
212 Views