Deploying a SharePoint 2019 Development Environment – Install and Configure SQL Server 2017 for SharePoint 2019

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

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.Copy SQL Binaries to ServerPowerShell

12#Assumes ‘E’ is your DVD drive.  Change as requiredCopy-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.

  1. Execute the setup file where you saved the binaries

Install and Configure SQL Server 2017 for SharePoint 2019 - Launch SQL Setup

  1. Click on the Installation tab (left frame) and click on New SQL Server stand-alone installation or add features to an existing installation
  2. Enter the product key for the SQL Server.  Click Next.
  3. Accept the license.  Click Next.
  4. Place a checkmark to allow Microsoft Update to keep the installation up to date.  Click Next.
  5. 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.

Install and Configure SQL Server 2017 for SharePoint 2019 - Select Features

  1. 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.

Install and Configure SQL Server 2017 for SharePoint 2019 - Instance Configuration

  1. At the Server Configuration screen enter the accounts and passwords you created to run the SQL Agent and Database Engine.  Click Next.

Install and Configure SQL Server 2017 for SharePoint 2019 - Server Configuration

  1. 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.
  2. Review the installation settings at the “Ready to Install” screen.
  3. 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.
Install and Configure SQL Server 2017 for SharePoint 2019 - Server Configuration

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:Install SQL Server 2017 from Command LinePowerShell

cd C:\Install\SQLBinaries
.\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!

About the Author:

David is a Senior Manager with Protiviti Canada, and a 3 time Office Apps and Services MVP. Over the last 18 years, David has worked in a wide variety of areas in IT ranging from Desktop\Server support to developing in C++ and .NET technologies. During that period, David has been able to add value to a wide variety of clients in several sectors, including utilities, government, banking, and agriculture. For over the past eight years, David has been working exclusively in the SharePoint and Office 365 domain. He has helped stand up multiple Enterprise SharePoint environments as well as designed and built numerous solutions utilizing PowerApps, Microsoft Flow and SharePoint. He is a knowledgeable and sought-after international speaker within IT circles and consulted regularly by companies formulating their Digital Workplace strategies.”

Reference

Drever, D. (2019). Deploying a SharePoint 2019 Development Environment – Install and Configure SQL Server 2017 for SharePoint 2019. Available at:
http://prairiedeveloper.com/2019/03/install-and-configure-sql-server-2017-for-sharepoint-2019/

Share this on...

Rate this Post:

Share: