Before you can do anything with SharePoint 2019 you have to install SQL Server. You have a couple of options available as both SQL Server 2016 and 2017 can be used. I want to go with SQL Server 2017 (all the latest features right?). So in this post I will be demonstrating how to install and configure SQL Server 2017 for SharePoint 2019. If you are wondering why you should bother with SharePoint 2019 at all, review my previous post to review a lot of the features you gain and others you lose. This series doesn’t cover the AD and server configuration. There are a couple of posts I did when building out SharePoint 2013 that can assist with this.
If you are interested in checking out the other items in this series click on the links below:
- Install and Configure SQL Server 2017 for SharePoint 2019 (This one)
- Preparing Servers for SharePoint 2019
- Install SharePoint 2019 with AutoSPInstaller
Install and Configure SQL Server 2017 for SharePoint 2019
In your VM, mount the SQL Server 2017 image. While I don’t really need a config or unattend file this configuration I am going to go through the steps anyways in case I need to install SQL Server again somewhere else. First I am going to copy the necessary binaries to the server.
#Assumes 'E' is your DVD drive. Change as required
Copy-Item E:\ C:\Install\SQLBinaries\ -Recurse
Build the Config File
The first step is to build the config file. This way you can re-use it elsewhere with PowerShell and the binaries. Just a quick note: PowerShell could be used entirely here, but I wanted to create a more general method of doing it since everyone has different configurations. By creating your own config file you can create it to your requirements.
- Execute the setup file where you saved the binaries
- Click on the Installation tab (left frame) and click on New SQL Server stand-alone installation or add features to an existing installation
- Enter the product key for the SQL Server. Click Next.
- Accept the license. Click Next.
- Place a checkmark to allow Microsoft Update to keep the installation up to date. Click Next.
- At the Feature Selection screen select the Database Engine Services option. Don’t really need anything else for a basic SharePoint 2019 installation. Change the installation location as needed or leave at defaults. Click Next.
- At the Instance Configuration screen enter in a name for your instance. You can leave it as the default, but if you ever add more instances, you are going to want to ensure you have meaningful names. Click Next.
- At the Server Configuration screen enter the accounts and passwords you created to run the SQL Agent and Database Engine. Click Next.
- I always ensure the SQL and SP admin accounts are added as SQL Administrators. I also use mixed mode so I can utilize both domain and SQL accounts for connection and admin. Also, unless you actually have multiple drives within your VM I don’t usually modify the default directories. Click Next.
- Review the installation settings at the “Ready to Install” screen.
- Most importantly, the “Ready to Install” screen contains the location of the config file we want. If you want to install by command line I suggest you move it into your SQL Binaries folder.
From here you can select Install and let the server install. I am actually going to finish the installation with PowerShell to show you how to do so.
Install SQL Server 2017
In the script we will run, we make use of the “/Q” option for a silent install. This interferes with the UIMode setting in the config file. Open up ConfigurationFile.ini and look for the entry “UIMODE = “Normal”. Place a semicolon (“;”) in front to comment it out.
To install SQL Server with our required options run the following commands:
.\SQLBinaries\Setup.exe /ConfigurationFile=.\SQLBinaries\ConfigurationFile.INI /Q /Action=Install /IAcceptSQLServerLicenseTerms /SQLSVCPASSWORD=<password> /AGTSVCPASSWORD=<password> /sapwd=<password>
Once the installation is complete you are ready to move onto the next step… Installing SharePoint 2019!
Thanks for reading!