SQL Server 2016 Standard Installation

Asad Mehmood

Thank you for your purchase of SQL Server 2016 from your #1 software dudes! 

*ONCE ACTIVATED OR REGISTERED, DIGITAL PRODUCTS ARE NOT REFUNDABLE* 

Product activation key(s):

 

Installation Instructions: 

Step 1. Go to Microsoft’s website and download the trial version for SQL Server 2016 

 

Step 2. After clicking on “Register to continue” button, additional information is required: name, email address, language, and country. There are some more fields that can be filled, but only the fields marked with * are necessary in order to access the download link. Click the Continue button, and download the file to the hard drive  

 

Step 3: Burn or mount the downloaded ISO image (SQLServer2016-x64-ENU.iso), and start the installation process. 

  1. Starting the Autorun, or running the Setup.exe will initiate the SQL Server Installation Center. First tab that opens by default is Planning. Many useful links that are found here, lead to pages with more info on the product and installation instructions. 

  1. It is always a good idea to run System Configuration Checker. It only takes a minute or two to complete, and can save you from possible issues in the future. If the system passes all the tests in System Configuration Checker, proceed to the next step. 

  1. Clicking on the Installation tab in the upper left corner displays the standard installation options. It is noticeable that the options for SQL Server Services and SQL Server Management Tools stand separated, which was not the case in previous versions of SQL Server. To start the installation, click on New SQL Server Stand-alone installation or add features to an existing installation. 

  1. Choose which SQL Server 2016 version to install. The Evaluation version gives access to all of the SQL Server 2016 features, as well as trial license limited to 180 days. Other versions can be chosen as well – but they require the activation key to be entered in the field beneath. In this example, the Evaluation version is used. Click Next to proceed.  

  1. Read and accept License Terms. Check the box in front of I accept the license terms, and click Next. 

  1. In this step, set the options for Microsoft Automatic Updates. Check the box to enable automatic updates, or leave it unchecked if you prefer to install them manually. Click Next. 

  1. Wait for the Install Setup File and Install Rules to complete. It is possible to get the Windows Firewall warning after Install Rules check is completed. The warning occurs if port 1433 is closed by the Windows Firewall. The warning can be ignored at the moment, but the 1433 port will have to be configured later. There is also an option to specify another port(s) that will be used by SQL Server instance. Detailed instructions on how to configure Windows Firewall to enable Database Engine Access can be found here. 

 

  1. On a Setup Role, choose to install All Features with defaults, or perform custom installation with features that you specify. In this example, the custom installation is chosen. 

  1. In the Feature Selection step, select the features of the SQL Server that need to be installed. You can check the description for each feature on the upper right, as well as prerequisites for all selected features in the box bellow. On the lower right, the Disk Space Requirements are displayed. In comparison to older versions of SQL Server, it is noticeable that Management Tools feature (which installs SQL Server Management Studio) is missing, but it can be installed separately later. For the instance to work, it is only necessary to install Database Engine Services. The latest SQL Server 2016 feature, PolyBase Query Service for External Data, can also be installed, but be aware of additional requirements. At least 4 GB of RAM is required to use this feature, and the installation of Java Runtime Environment 7 Update 51 in the next step will be required. If needed, set Instant root directory and Shared feature directory paths manually on the bottom of the menu. When finished with the selection, click Next. 

  1. If PolyBase Query Service is chosen in the previous step, the wizard will display the warning about failed test for Java Runtime Environment. Just click on the failed link on the right, and it should open the JRE download page. 

  1. In the Instance Configuration step, choose the default, or named instance, and specify the Instance ID. Click Next to proceed.  

  1. In Server configuration step, specify the accounts that can start SQL Server services. Set the startup options for any of these services to Manual, Automatic, or Disabled. Click Next when done.  

  1. In Database Engine Configuration, under Server Configuration tab, specify the authentication mode and Administrator account(s) for the server. As in earlier versions, Windows Authentication mode and Mixed Authentication mode are available.  

  1. After checking Feature Configuration Rules, the wizard proceeds to Ready to Install step. All of the settings that are specified earlier, can be reviewed here. Check the settings one last time, and click Install to start the installation. 

  1. Wait for the installation to finish. The process may take some time, depending on hardware specifications. 

  1. Optionally, install SQL Server Management Studio, so you could easily manage your databases. Start the autorun or setup.exe again, and under the settings tab, choose Install SQL Server Management Tools. This will open the download page for the latest version of SSMS. Click on the download link, and save the installation to the hard drive. 

  1. Once the download completes, run the file to start SSMS setup. Just click on the Install button, and the installation should complete without any further setup options. Depending on the system, the computer restart might be required. 

 

If you have any questions or concerns please email support at support@software-dudes.com