Configuring SQL Server services
In Chapter 4, Installation Concepts, we learned how to install HOSTs and VMs in order to support our environment before installing the main applications for our farm configuration on SQL Server 2017 and SharePoint Server 2019. Although we have done this, there is so much more to do, as we will see in this chapter and others to come. We still have some server configurations to finish and services to configure in the farm before we can create some web applications and test them.
SQL Server is the main component and the foundation of the SharePoint Server Farm. Without it, we cannot support SharePoint in any way. So, since this server supports all the data that will be used for configuration, services, content, and security, we really need to make sure that this part of our farm is performing up to par and has been configured to support the farm through growth, redundancy, and performance.Â
We have compiled a list of areas we want to change and...