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 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.