Software Installation

How to install Microsoft SQL Server 2016 Standard 

How to install SQL Server 2016

Sign in with a valid Hotmail account or else create a new Microsoft account.

Sign in with valid Hotmail account

Fill in the required information, click Register to continue. Your download will start automatically and if it does not start click the download button to download SQL Server ISO File.

click download button

Once the download is completed, run the setup file (run as administrator).

run as administrator

After a few seconds the screenshot shown below will appear, check the hardware and software requirements and click the installation tab.

click installation tab

Click new stand-alone SQL Server installation or add the feature to an existing installation.

SQL Server installation

If you have a Product ID enter it or select the free edition.

evaluation

Pick any one drop down now. I selected evaluation and clicked next.

selected evaluation t

Accept the license and click next.

Accept the license

Click next.



Check Microsoft update and click next.

Check Microsoft update

Now I am installing SQL Server offline. I have not used the internet connection and therefore, I unchecked the latest update.

Click next.

installing SQL Server

Check all the rules which are passed. Firewall gives a warning, which is not a problem, and you are good to go. Click here to learn how to configure Windows Firewall for SQL Server access. Click next.

configure Windows Firewall

Select the required features and click next.

Part (1/2)

feature selection

Part(2/2)

Select the required features

Click next to continue the installation.



I am installing SQL Server on my machine first, so there will be no instance. Create a named instance, shown below, and click next.

SQL Server

If you want a separate account to maintain SQL Server Service, you can create a new user profile and assign the password. Now I don’t need this, so I  set the default one and click next.



Select the mixed SQL Server Authentication to provide the password for SQL Server authentication. Click the ADD current user button to add the current user as an administrator.

ADD current user

Once user is added click next.



If you want, you can change the data directories path.

change the data directories path

Check the Temp DB Size. If you want, you can change the temp DB size and the path.

Temp DB Size

Enable the File stream. If required for more information about enabling and configuring File Stream, please click here. Click next.

configuring File Stream

Select SSAS Server Mode and add current user for SSAS administrator and click next.

Server Mode

Check the Analysis Service installation path. If you want, you can change the installation path and click next.

Analysis service

Select Install and Configure for SQL Server Native Mode.

Select Install and Configure

Click Accept to install on your machine.

Click Accept to install

Click next to continue installation.



Check the features you are going to install and click install button.

going to install the click install

It will take some time for the installation and click next, once installation completes.

process

All the features are installed successfully.

All features installed

stalled successfully

Click close to complete the installation.

complete the installation

Now, I am going to check what are the features installed on the start Menu?

start Menu

Oops, I can’t find SQL Server Management Studio and Visual Studio.

Don’t panic, as we have to download SQL Server Management Studio and SSDT 2015 (SSIS, SSRS and SSAS) followed by installing it separately.

Go to SQL Server Setup and run it, followed by Click Installation -> Install SQL Server Management.


click Install SQL Server

It will take you to the Web Browser and download SSMS, as shown below:

Download page

Once the download completes, run the setup.

run the setup

Click install.

Click install

Installation will take some time. Click close, once installation completes.

Installation

SSMS installed successfully.

Like SSMS, download SSDT from the internet. Once download completes, run the setup.

SSDT from internet

Select SSIS, SSRS and SSAS and click next.



Setup

Click Close to complete the installation.
 
Thank you 

Leave a Reply

Your email address will not be published. Required fields are marked *