SQL Server 2017 Install

Microsoft SQL Server 2017 has many new features. Some of the features are the ability to install on Linux and Linux based Docker containers, SSIS Scale Out Master and Scale Out Worker, resumable online index rebuilds and Machine Learning Service language supporting R/ Python. Some other improvements to SSMS, SSAS and SSRS.

First Steps

You need to download the SQL Server 2017 installer here.

Free trial eval, Devloper and Express edition

Free edition is a 180 day trial and includes all the features of a complete version.
SQL Server Developer edition is free, however, you can not use this version in a production environment.
SQL Server Express edition is free and can be used in a production environment but has some storage limitations 10 GB. It also does not have SQL Server Agent or DTA. This is a good option for the system that is not heavly dependant on resources.

This article is focused on the installation of SQL Server 2017 and not on the different versions. You can find a complete list of versions here.

Start the install by running the setup file you just downloaded.

If you select the basic version it will install the DB Engine with a few basis components. I always like to select custom install so i can choose what i need for this installation. Other option would be to Download Media for installation later or to install on a different server.

 

SQL SERVER Install Image

 

Secify the location to download the media too.

 

SQL SERVER Install Image

 

Downloading....

 

SQL SERVER Install Image

 

The installation center will appear with many different options on it. If this is the first time seeing this, it can be intimidating at first. The Planning section has many different options to check your system for hardware and software requirements as well as documentation and other helpful links.

 

SQL SERVER Install Image

 

We are going to jump over to the Installation section and get right to it.

 

SQL SERVER Install Image

 

For the Product Key we are going to just select Developer. If you have a key, this is the time to enter it.

 

SQL SERVER Install Image

 

You should read word for word here and have a complete understanding of the License Terms. lol, or just check the box and hit next. :)

 

SQL SERVER Install Image

 

You have the option to check for updates to this installer or not.

 

SQL SERVER Install Image

 

We are now half way down the list at Install Rules. This section will check to see if there are potential issues and report on them if found. Windows firewall seems to always show up on this list.

 

SQL SERVER Install Image

 

Now the fun part, the Feature selection. Here you will select what you need to install. Every system and need is different. We are going to select Database Engine Services.

 

SQL SERVER Install Image

 

Feature Rules. Don't like the title of this one but this is where the installer will determine if there will be any processes blocked.

Here you can have several installations (Instances) of SQL Server. This section will show all that is currently installed. You would have a few different instances if you wanted to practice mirroring or replication. With that said, you can only have one default instance on the server.

 

SQL SERVER Install Image

 

The Server Configuration sections alows you to specify different accounts for the services listed.

 

SQL SERVER Install Image

 

Database Engine Configuration
Server Configuration Tab
Here you will have two options when it comes to security and how to connect to your SQL Server. Windows authentication and/or Mixed Mode (Windows and SQL authentication). Pending what your requirements are, i prefer Windows Authentication. You also need to specify your Administrators. Carefull who you give admin access.

 

SQL SERVER Install Image

 

Data Directories
Here you can specify what directories you would like for each area. We will be good DBAs and not use the Windows partition for the data and log files.

 

SQL SERVER Install Image

 

TempDB
Specify the size and location of TempDb, Should be on a different drive/LUN.

 

SQL SERVER Install Image

 

Filestream
If you would like to enable Filestream (storing documnets), check the box.

 

SQL SERVER Install Image

 

Take a look at your summary of the options you selected to install.

 

SQL SERVER Install Image

 

Pending what you selected how your hardware, should take 5-45 min. Yes thats a big range, but the real answer is "it depends".

 

SQL SERVER Install Image

 

SQL Server Management Tools Install

Now that you have your engine installed, its time to install SQL Server Management Tools.

 

SQL SERVER Install Image

 

This is a seperate install and you will need to download SSMS.

After you have downloaded, install to begin.

 

SQL SERVER Install Image

 

 

SQL SERVER Install Image

 

 

 

Conclusion
SQL Server is a robust database engine that has several options depending on your needs. Learning this software can lead to many different careers like Database Administration (DBA), Database Engineer (DBE) and many others.