How to install SQL Server 2016 (and SSMS 2016)

SQL Server, How-to, SQL Server 2016, SQL Server Management Studio, SQL Server Management Studio 2016

As an update to our earlier how-to for setting up a developer environment with IIS and SQL Server 2014 for Orchard, here's a step-by-step guide for setting up SQL Server 2016 and SQL Server Management Studio 2016 on your machine. If you're upgrading from SQL Server 2005, we have good news for you: SQL Server 2016 is faster.

Prerequisites

Make sure that your msvcr120.dll file is the appropriate version, as described in the official documentation.

SQL Server 2016

  • Go to the Technet Evaluation Center, sign in with a Microsoft ID and download the installer.
  • Installation
    • Select "Custom" as the installation type on the splash screen.
    • New SQL Server stand-alone installation or add features to an existing installation (opens a new window)
      • Product key
        • Specify a free edition: Developer
      • Feature Selection
        • Instance Features -> Database Engine Services -> check (you probably won't need anything else)
      • Instance Configuration
        • Default instance -> select
        • Instance ID: MSSQLSERVER (this will mean that the instance can be accessed with the shortest host name possible: ".", ".\" or "localhost", but also by your machine name; you may have to change this or remove a previous installation if this name is taken)
      • Database Engine Configuration
        • Server Configuration
          • Authentication Mode -> Windows authentication mode
          • Specify SQL Server administrators -> Add Current User
        • Data Directories: change, if necessary

SQL Server Management Studio 2016

What else to do

Head back to the original article and follow the installation guide from step 9.

2 Comments

  • john said Reply

    Nice article but i found an easy way to install sql server with images here : http://www.topnewsage.com/how-to/how-to-install-sql-server-2014-on-windows-8-1-with-images.html

  • Johnson Weltch said Reply

    Thanks, the article was nice. I have found one more interesting article . http://www.sqlserverlogexplorer.com/installing-sql-server-2016-step-by-step/

Add a Comment