Configuring SQL Server 2017
The foundation of SharePoint is SQL Server. The database server holds all the data related to your SharePoint installation. SQL Server 2019 is also available for us to test during this proof of concept installation. There are big differences in the two versions of SQL due to updates in the 2019 version that support big data.
Let's talk about the differences for a minute to get you up to speed on SQL Server 2016, 2017, and 2019. SQL Server is supported if installed on the same server as SharePoint 2019. SQL Express is not supported as an automatic installation to support your single server installation. In production environments, we like to see SQL on a separate server for performance reasons.Â
Installation of SQL Server 2017 can be done on a new platform, which is exciting to see. Linux is now a platform that will support SQL Server 2016, 2017, and 2019, which you can now run on the Linux operating system. What does this mean to me? This...