SQL Server 2016 installation step by step with screenshots

This SQL Server tutorial explains, how to install SQL server 2016 step by step with screenshots.

We are going to show you how to install SQL server 2016 step-by-step procedure for installing a new instance of SQL Server 2016 using the SQL Server setup installation wizard.

The SQL Server Installation Wizard provides a single feature tree for the installation of all SQL Server components so that you do not have to install them individually. For more information on various components that can be installed, see Installation for SQL Server 2016.

For more information about how to install the SQL Server components individually, see Install SQL Server 2016.

The following are some recommendations before installing SQL Server 2016:

The computer where SQL Server will be installed should have access to the Internet.
It is not supported to install SQL Server 2016 through Terminal Services client.

For all editions of SQL Server 2016, the following considerations apply:

We recommend that you run SQL Server 2016 on computers with the NTFS file format. Installing SQL Server 2016 on a computer with FAT32 file system is supported but not recommended as it is less secure than the NTFS file system.

SQL Server Setup will block installations on read-only, mapped, or compressed drives.

The installation of SQL Server 2016 fails if you launch setup through Remote Desktop Connection with the media on a local resource in the RDC client.

To install remotely the media must be on a network share or local to the physical or virtual machine. SQL Server installation media may be either on a network share, a mapped drive, a local drive, or presented as an ISO to a virtual machine.

SQL Server Management Studio installation requires installing .NET 4.6.1 as a pre-requisite. .NET 4.6.1 will be automatically installed by setup when SQL Server Management Studio is selected.

By following TechNet URL we have performed SQL server 2016 Installation:

Hardware and Software Requirements for SQL Server 2016

Follow this MSDN URL for Hardware and Software Requirements

Hard Disk Space Requirements:
During the installation of SQL Server 2016, Windows Installer creates temporary files on the system drive. Before you run Setup to install or upgrade SQL Server, verify that you have at least 6.0 GB of available disk space on the system drive for these files. This requirement applies even if you install SQL Server components to a non-default drive.

Actual hard disk space requirements depend on your system configuration and the features that you decide to install. The following table provides disk space requirements for SQL Server 2016 components.

Advantages of SQL Server 2016

  • Enhanced in-memory performance provides up to 30x faster transactions, more than 100x faster queries than disk-based relational databases and real-time operational analytics
  • New Always Encrypted technology helps protect your data at rest and in motion, on-premises and in the cloud, with master keys sitting with the application, without application changes
  • Built-in advanced analytics– provide the scalability and performance benefits of building and running your advanced analytics algorithms directly in the core SQL Server transactional database
  • Business insights through rich visualizations on mobile devices with native apps for Windows, iOS, and Android
  • Simplify management of relational and non-relational data with the ability to query both through standard T-SQL using PolyBase technology
  • Stretch Database technology keeps more of your customer’s historical data at your fingertips by transparently stretching your warm and cold OLTP data to Microsoft Azure in a secure manner without application changes
  • Faster hybrid backups, high availability and disaster recovery scenarios to backup and restore your on-premises databases to Microsoft Azure and place your SQL Server AlwaysOn secondaries in Azure.

Install SQL Server 2016 step by step

When I mount the ISO image and browse the image you see the following directory.

Insert the SQL Server installation media. From the root folder, double-click Setup.exe. To install from a network share, locate the root folder on the share, and then double-click Setup.exe.

When I mount the ISO image and browse the image you see the following directory.

sql server 2016 download

To launch the installation I just double-clicked on the “setup” exe as shown.

how to install sql server 2016 developer edition step by step

To launch the installation I just double-clicked on the “setup” exe as shown, do next after all verification for hardware and software.

how to install sql server 2016 on windows server 2016

You should also provide a product key if you are installing a licensed edition of SQL Server.

how to install sql server 2016 in windows server 2012 r2

Here select license terms and conditions and do next.

how to install sql server 2016 standard edition step by step

On this screen select global rule and Microsoft update, you can skip also. In our case, we had to skip and do next.

how to install sql server 2016 on windows server 2016

On this screen the option to install individual features, or all the features with the defaults. For my installation, I will only be installing the SQL Server database engine and therefore I selected the first radio button.

how to install sql server 2016 on windows 10

Then click on next, below Instance Configuration wizard will get open, Here give your instance name or keep default like below.

how to install sql server 2016 step by step on windows 10

Click on next, the server configuration wizard will appear here leave the default.

how to install sql server 2016

Click on next on this screen Database engine configuration wizard will come. Add user to access the database. You can add multiple users over here or later also can add but the minimum one user should add here.

sql server 2016 installation step by step screenshots

Note: Here can configure data directory and temp DB

Once click next it will go to the summary page of SQL server here verify all setup if need do modify and click on the install button to install SQL server 2016.

sql server 2016 installation step by step pdf

Wait for a complete installation, once it will complete successfully will show below wizard click on the close button it will close automatic.

sql server 2016 installation step by step
sql server 2016 installation best practices

Now download SQL Server Management Studio from this link and install the same.

sql server 2016 installation requirements

The installation process will appear like below, then restart the server and verify SQL server 2016 is installed.

sql server 2016 installation

Here the new wizard will look like this.

sql server 2016 installation steps

Here we have seen how to install SQL server 2016 step by step.

You may like following sql server tutorials:

Tags: sql server 2016 installation steps, sql server 2016 installation, sql server 2016 installation step by step pdf, install sql server 2016 step by step, sql server installation step by step, sql server 2016 step by step pdf, sql server 2016 step by step installation, sql server 2016 installation requirements, how to install sql server, how to install sql server 2016, how to install sql server 2016 step by step, how to install sql server 2016 management studio, sql server management studio 2016 download, sql server 2016 download, How to install SQL Server 2016 step by step?

free sharepoint training

SharePoint Online FREE Training

JOIN a FREE SharePoint Video Course (3 Part Video Series)

envelope
envelope
>