Tuesday 5 July 2016

SQL Server 2016 Installation Step by Step with Screen shot

How to install SQL Server 2016.

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 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 below TechNet URL we have perform SQL server 2016 Installation:

The following requirements apply to all SQL Server 2016 installations:
Component
Requirement
.NET Framework
SQL Server 2016 RC1 and later require .NET Framework 4.6 for the Database Engine, Master Data Services, or Replication. SQL Server 2016 setup automatically installs .NET Framework. You can also manually install .NET Framework from Microsoft .NET Framework 4.6 (Web Installer) for Windows.

For more information, recommendations, and guidance about .NET Framework 4.6 see .NET Framework Deployment Guide for Developers.

 Windows 8.1, and Windows Server 2012 R2 require KB2919355 before installing .NET Framework 4.6.
Network Software
Supported operating systems for SQL Server 2016 have built-in network software. Named and default instances of a stand-alone installation support the following network protocols: Shared memory, Named Pipes, TCP/IP and VIA.

Note: Shared memory and VIA are not supported on failover clusters.

Also note that the VIA protocol is deprecated. This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature.

 

For more information about Network Protocols and Network Libraries, see Network Protocols and Network Libraries.
Hard Disk
SQL Server 2016 requires a minimum of 6 GB of available hard-disk space.

Disk space requirements will vary with the SQL Server 2016 components you install. For more information, see Hard Disk Space Requirements later in this topic. For information on supported storage types for data files, see Storage Types for Data Files.
Drive
A DVD drive, as appropriate, is required for installation from disc.
Monitor
SQL Server 2016 requires Super-VGA (800x600) or higher resolution monitor.
Internet
Internet functionality requires Internet access (fees may apply).

Processor, Memory, and Operating System Requirements


The following memory and processor requirements apply to all editions of SQL Server 2016:
Component
Requirement
Memory*
Minimum:

Express Editions: 512 MB

All other editions: 1 GB

 Recommended:

Express Editions: 1 GB

All other editions: At least 4 GB and should be increased as database size increases to ensure optimal performance.
Processor Speed
Minimum: x64 Processor: 1.4 GHz

 Recommended: 2.0 GHz or faster
Processor Type
x64 Processor: AMD Opteron, AMD Athlon 64, Intel Xeon with Intel EM64T support, Intel Pentium IV with EM64T support
System_CAPS_ICON_note.jpgNote

Hard Disk Space Requirements


During 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.

Feature
Disk space requirement
Database Engine and data files, Replication, Full-Text Search, and Data Quality Services
1480 MB
Database Engine (as above) with R Services (In-Database)
2744 MB
Database Engine (as above) with PolyBase Query Service for External Data
4194 MB
Analysis Services and data files
698 MB
Reporting Services
967 MB
Microsoft R Server (Standalone)
280 MB
Reporting Services - SharePoint
1203 MB
Reporting Services Add-in for SharePoint Products
325 MB
Data Quality Client
121 MB
Client Tools Connectivity
328 MB
Integration Services
306 MB
Client Components (other than SQL Server Books Online components and Integration Services tools)
445 MB
Master Data Services
280 MB
SQL Server Books Online Components to view and manage help content*
27 MB
All Features
8030 MB

Benefits
  • Enhanced in-memory performance provide 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 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

  1. When I mount the ISO image and browse the image you see the following directory.
  2. 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.

  1. When I mount the ISO image and browse the image you see the following directory.
  1. To launch the installation I just double clicked on the “setup” exe as shown.


  1. To launch the installation I just double clicked on the “setup” exe as shown, do next after all verification for hardware and software
  1. You should also provide a product key, if you are installing a licensed edition of SQL Server.



  1. Here select license term and condition and do next
  1. On this screen select global rule and Microsoft update, you can skip also. In our case we had skip and do next.

  1. 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. 
  1. Then click on next, below Instance Configuration wizard will get open, Here give your instance name or keep default like below

  1. Click on next, server configuration wizard will appear here leave default
  1. Click on next on this screen Database engine configuration wizard will come. Add user to access database. You can add multiple user over here or later also can add but minimum one user should add here
Note: Here can configure data directory and temp DB
  1. Once click next it will go to summary page of SQL server here verify all setup if need do modify and click on install button to install SQL server 2016
  1. Wait for complete installation, once it will complete successfully will show below wizard click on close button it will close automatic


  1. Now download SSMS from below link and install the same



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

  1. Here new wizard will look like this

Cheers

5 comments:

  1. The post is written in very a good manner and it contains many useful information for me.
    server installation uae

    ReplyDelete
  2. Thanks for sharing such easy steps of SQL server installation. By using these steps we can easily install SQL server but also, you can operate online SQL server providing by Datasparc . They are providing this benefit online where data are secured and you can easily connect with Microsoft SQL server. Visit their website to know more: https://www.datasparc.com/sql-server-data-tools

    ReplyDelete
  3. In this era of advanced technologies, there is great list of software development companies is available. The thing is to choose to best one. Our developers have left no stoner uncovered and still there is a lot more to come. Feel free to contact us for any type of software queries.

    ReplyDelete