How to Create an SQL Server Instance on SQL Server Management Studio 2017 (SSMS v17.0)

Question

How do I go about creating a new Local SQL Server Instance for SQL Server Management Studio 2017.

In previous version I have installed it was part of the installation process, but it was removed for some reason. Any ideas?

Thanks in advance

Solution

Since SQL 2016, the database engine and the management tools (SSMS/profiler/etc.) come in separate downloads and are upgraded separately.

Since you already have SSMS, you need to download the DB engine, which can be downloaded from here (SQL Server 2017 currently): https://www.microsoft.com/en-us/sql-server/sql-server-downloads