How to install SQL Server 2016 (and SSMS 2016)
SQL Server, How-to, SQL Server 2016, SQL Server Management Studio, SQL Server Management Studio 2016As 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
- Server Configuration
- Product key
SQL Server Management Studio 2016
- Go the MSDN download page of the product to get the installer.
What else to do
Head back to the original article and follow the installation guide from step 9.
john said
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
Thanks, the article was nice. I have found one more interesting article . http://www.sqlserverlogexplorer.com/installing-sql-server-2016-step-by-step/