Microsoft SQL Server is one of the most popular professional database servers on the market. In this guide, we’ll help you install SQL Server on the Windows operating system together with SQL Management Studio.
How to Install SQL Server 2017
We’ll install SQL Server 2017 in this guide. 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.
Follow these steps to install Microsoft SQL Server 2017:
- 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! SQL Server is now 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.
That’s it! You’re done.
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
Questions? Drop us a line at firstname.lastname@example.org!