SQL Server 2016 Configuration
I haven’t seen any official or unofficial documentation about required features yet so I’ll use the minimum set of features that worked with older versions of SharePoint.
SQL Server 2016 Installation
The following steps apply if you don’t have a SQL Server instance yet. If you have a SQL Server 2016 instance you can skip to the step below: "SQL Server 2016 configuration".
Select a new SQL Server stand-alone installation:
Install product updates, wait until setup files have been installed and run the install rules:
Please select at least the following minimum features:
Keep the default instance.
Add the SQL Server service account (in my case: sqlSvcAcc) plus password and keep the collation settings.
If you create a development environment add the current administrator and SharePoint 2019 Farm Administrator as SQL Server administrators.
Start the SQL Server 2016 installation.
SQL Server 2016 Configuration
Download and install SQL Server Management Studio:
Open SQL Server Management Studio and give the following permissions.
Assign the dbcreator and securityadmin server role to the SharePoint 2019 Farm Administrator which is in my case spAdmin.
SQL Server 2016 Tips
Please also make sure you respect the following SQL Server best practices by Microsoft:
- Do not enable auto-create statistics on SharePoint content databases.
- Do not manually restrict database size in SQL Server.
- Keep max degree of parallelism (MAXDOP) to 1 for instances of SQL Server that host SharePoint databases.
Back to top