SQL Server 2016 is released this month at first of the June, and in this tutorial I will demonstrate how to install SQL Server 2016 on your machine. Installation of SQL Server 2016 is more-less same as SQL Server 2014 version but this this time SQL Server Management Studio (SSMS) is not part of standard installation so we need to install it before or after SQL Server installation.

So let's begin with installing our new SQL Server 2016 version.

Install SQL Server 2016

First of all download ISO file installer from your download source (Technet Evaluation Center, MSDN, Dev Essentials, DreamSpark...). I have my downloaded from MSDN Subscription and I chosed Developer edition and as reminder I strongly recommend you to check SHA1 hash for file after you download your ISO file, you can check it with tools for checksum in my case i used fciv command line tool to check it out. This step is optional but it is very useful for security reasons.

After you extract your iso file... Run setup.exe file (as admin)


 and wait couple of seconds to load it up and you will see this window in front of you:


At this screen you can see all kind of install options best for me in this moment in first one (New SQL Server stand-alone installation... ) and Upgrade from a previous version of SQL Server (I have SQL Server 2014 installed on this machine).

For this tutorial I will select first one new stand-alone installation.

First window in installation that you will get is window about Product Key... for Developer edition it is not required so I will choose here Developer edition and go next and after this step you need to accept terms and conditions in order to SQL Server on your machine


And this little step which ask you do you want to check for updates that you need for SQL Server regularly and install them automatically.


After that installer found some critical update that I need to install before it installs the SQL Server on my machine.


At this step installer is downloading and installing that critical update for me... so you will need to wait couple of minutes depending on your internet speed.


Now we can go with next step in which installer is checking out our system to find if there is any potential problem that can cause error with our installation, as you can see I don't have any problem... but if you have some of problems SQL Server installer will explain you what to do to resolve that problem.



Next step is feature selection in which you need to specify which features you want to install, in my case I need basic installation and I will install documentation and of course Database Engine Service, there is also service for R Server,  Reporting and Analyses services this step depend on your needs.

I use SQL Server for learning and development so these two and documentation will be good for me, reminder is that we can run the setup and install additional features if we need them someday in the future.


After this we need to specify the name of our SQL Server instance... As I mentioned early I have SQL Server 2014 so my default instance if  "taken" so in that case I need to choose named instance for my new SQL Server 2016... if you don't have any previous versions of SQL Server just got with Default instance which is strongly recommended to use.



So when we choose name for our instance (or use default one)... we can to specify the service accounts and collation configuration for our services on SQL Server instance...



Now we need to specify which type of authentication we will use for sign in to our SQL Server instance... As you can see I will use Windows authentication mode and most important thing is to Add Current user if you are installing this as an administrator so you will not need to type your username and password every time when you want to use SQL Server... user which are you signed in right now (administrator) will be your user and password credentials for authentication.

About mixed mode I will write in some of future blog posts. So with Windows authentication mode we will be good and go next.


Note: If you selected more than just database engine after step with authentication you will need to configure that additional services with your needs.

Now we are ready for the installation... and you can see the list of all features that will be installed... And if we are sure that this is all we want we can click on Install.



Now we can see how our installation is going and about 10-15 minutes will be enough for the installation, this amount of time also depends on your PC and additional services that you choose to install.



If everything is OK you should see something like this at the end of your installation.

SQL Server Management Studio (SSMS)

After last step our SQL Server 2016 is installed successfully... one step to our goal is left and that is to install SQL Server Management Studio (SSMS)... So we can see our first setup window and select second option and that is: Install SQL Server Management Tools



Click on it and it will navigate you to download page for SSMS to this URL.


After you download it run it as an admin and follow very simple steps to install it.

This is the welcome screen for new SQL Server Management Studio installer.


After we click install we have started our installation... first thing that this installer will do is to load packages and than install some additional packages and update some parts of your Visual Studio if it is needed, because new Management Studio uses the Visual Studio 2015 Isolated shell.



Couple of minutes and if everything is OK... our new Management Studio is successfully installed.

Run new SSMS and SQL Sever instance: