Back to articles list October 8, 2018 - 4 minutes read Microsoft SQL Server 2017 Installation Step by Step Dorota Wdzięczna Dorota is an IT engineer and works as a Data Science Writer for Vertabelo. She has experience as a Java programmer, webmaster, teacher, lecturer, IT specialist, and coordinator of IT systems. In her free time, she loves working in the garden, taking photos of nature, especially macro photos of insects, and visiting beautiful locations in Poland. Tags: SQL basics learn sql MS SQL Server get started installation guide Microsoft SQL Server is one of the most popular professional database servers on the market. In this guide, I’ll show you all SQL Server 2017 installation steps to help you install it on the Windows operating system together with SQL Management Studio. How to Install Microsoft SQL Server 2017 In this guide, I’ll show you the SQL Server 2017 installation step by step. You can download it for Windows and Linux, but you can’t install Microsoft SQL Management Studio on Linux at the moment, so we recommend you stick to Windows. How to install Microsoft SQL Server 2017? Follow these steps: Visit Microsoft’s official SQL Server 2017 download page. Select the edition you want to download. For free use, the Express edition is a good choice. Click Download now below your selected edition. This will download the installation wizard. The wizard will prompt you to select an installation type. We recommend a Custom installation, as this allows you to choose what you want to install from the extended tools. On the next page, select a directory for the installation folder. You can leave this as the default or select a custom installation directory. Click the Install button to download the installation packages. After the installation package is downloaded, select New SQL Server stand-alone installation, as shown below. On the next screen, you’ll see a setup process. Once it completes, click Next. You should now see the license terms. Review these if you’d like, and click Accept. You’ll then be taken to the Feature Selection screen, where you can choose custom SQL Server 2017 features you would like to install. For example, you can choose to install machine learning services for R and Python. Click the Next button. You’ll be taken to a screen where you may specify a Named instance for your installation. Basically, in SQL Server, you can have more than one instance (a collection of databases run by a single service) of the server. In our example, we’ve chosen SQLExpress as our named instance. You can also go with the Default instance name. Click Next. You’ll be taken to the Server Configuration screen. You can leave these settings untouched. Click Next. You’ll now see the Database Engine Configuration settings. If you’d like to have the option to connect to databases through both Windows and SQL Server authentication, check Mixed Mode. Mixed Mode allows you connect to SQL Server using both your Windows account password and also a custom password you can set for SQL Server admin privileges. Click Next to see a summary of the installation process. Once the installation is complete, click Close to finish. You’re done! You’ve gone through all the SQL Server 2017 installation steps and it’s ready to run on your system. How to install SQL Server Management Studio The SQL Server Management Studio is a GUI program that allows you to manage your databases quickly and easily, create users, set database permissions, make backups, and much more. You can install this tool separately by visiting Microsoft’s download page and getting the latest binary for the installation wizard. As of this writing, the latest version is 17.5. Simply run through the steps and click the Install button at the end. After the installation, the SQL Server Management Studio is ready to launch: First, you’ll see the Connect to Server window. Select the name of the server you’d like to connect to, and enter the login and password for it. Click the Connect button. Congratulations! That’s it! You’re done. You know how to install Microsoft SQL Server 2017 together with SQL Server Management Studio on your Windows. There are plenty of other database servers on the market. For small companies, Microsoft SQL Server Express is a free and professional tool. You can use also SQL Server Management Studio to manage your database and users. Interested in learning more about T-SQL? We offer the following courses: SQL Basics in MS SQL Server Common Functions in MS SQL Server Window Functions in MS SQL Server Recursive Queries in MS SQL Server How to Insert, Update, or Delete Data in MS SQL Server GROUP BY extensions in MS SQL Server Tags: SQL basics learn sql MS SQL Server get started installation guide You may also like How to Install PostgreSQL on Windows 10 in 5 Minutes It may look like a complicated task to install database software on your PC. In this article, I’ll show you how to install PostgreSQL on Windows 10 easily. Read more How SQL supports data-driven organization Businesses face many decisions. Most of them are driven by intuition, but organizations that make the most business impact use data-driven decision-making. Read more Advanced SQL Courses for Data Analysts – A Complete Review Data analysts, do you want to improve your skills and move to a higher level of SQL? Here’s an overview of 8 online SQL courses for advancing analysts. Read more Advanced SQL Interview Questions (and Answers) Here are ten common questions you might hear during an advanced SQL interview. We also have the answers for you. Read more Subscribe to our newsletter Join our weekly newsletter to be notified about the latest posts.