Getting Started With SQL Server 2016

In this article, we will discuss in detail about SQL Server 2016, the list of features available in SQL Server 2016, prerequisites, setting up the environment, and more. Microsoft announced the new release of SQL Server 2016 on November 2016.

What's new in SQL Server 2016?

If you want to know what are all the things that are new features or the improvements for SQL Server 2016, then with this release, you can see the list of features, as shown below.
  • SQL Server setup
  • Analysis Services engine
  • Database engine
  • New SQL PowerShell module
  • Integration Services
  • Reporting Services (SSRS)
  • Master Data Services (MDS)
  • SQL Server R Services

 

Prerequisites
  • SQL Server 2016
 
Setting up the environment

We will discuss in detail about SQL Server 2016 installation procedure with a step by step guide, as given below.

Go to SQL Server 2016 Setup folder and double click Setup.exe.

 
SQL Server Installation Center Window will open and select the Installation option. Click the New SQL Server stand-alone installation or add features to an existing installation option.


The Product Key Window will open and verify the developer free edition option. Subsequently, click the Next button.



The License Terms Window will open, verify the license terms and select the check box of the license terms. Subsequently, click the Next button.



Microsoft Update Window will open and click Next button.



The Product Update Window will open and click Next button.



Install Rules Window will open and verify that all the install rules are passed (i.e. Windows Firewall enable to SQL Server port 1433). Subsequently, click Next button. 



The Feature Selection Window will open and select the list features to install into your PC. Subsequently, click Next button.



The Instance Configuration Window will open and verify the default instance check box is checked. Now, click Next button.



The Server Configuration Window will open and change the account name for the Services given below.
  • SQL Server Agent - Domain\System
  • SQL Server Database Engine - Domain\System
  • SQL Server Analysis Services - Domain\System
  • SQL Server Reporting Service - Domain\System

Now, click Next button.



The database engine configuration Window will open and select the Mixed Mode radio button, which is checked. Now, type the password, confirm password and click 'Add Current User' button. Subsequently, click 'Next' button.



The Analysis Services Configuration Window will open, select the Multidimensional and Data Mining Mode radio button, which is checked. Click 'Add Current User' button and click 'Next' button.



The reporting Services configuration Window will open and select 'Install and Configure radio button', which is checked. Now, click Next button. 



The Ready to Install Window will open and click 'Install' button.



The installation progress Window will open.



The complete Window will open and verify all the setup operation is succeeded. Now, click 'Close' button. Afterwards, restart your PC.



Conclusion

I hope, you understood SQL Server 2016, the list of features available in SQL Server 2016, prerequisites, and setting up the environment. I have covered all the required things. If you find anything, which I missed in this article, please let me know. Please share your valuable feedback or comments and suggestions to improve the future article.