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.
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.
Secify the location to download the media too.
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.
We are going to jump over to the Installation section and get right to it.
For the Product Key we are going to just select Developer. If you have a key, this is the time to enter it.
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. :)
You have the option to check for updates to this installer or not.
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.
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.
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.
The Server Configuration sections alows you to specify different accounts for the services listed.
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.
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.
Specify the size and location of TempDb, Should be on a different drive/LUN.
If you would like to enable Filestream (storing documnets), check the box.
Take a look at your summary of the options you selected to install.
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 Management Tools Install
Now that you have your engine installed, its time to install SQL Server Management Tools.
This is a seperate install and you will need to download SSMS.
After you have downloaded, install to begin.
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.