SharePoint Server 2019 installation has dependencies on Microsoft SQL Server and Active Directory Domain Services (AD DS). Active Driectory stores the user accounts and authenticate user accounts whereas SQL Server stores almost all of the configuration and content of a SharePoint farm.

Microsoft recommends using a minimal number of service accounts in the farm. This is to reduce memory usage and increase performance while maintaining the appropriate level of security. Below is the recommended list of user accounts required for installing a SharePoint server 2019 Farm:

Account Role Description
SQLService Domain user account Service account for the following SQL Server services:

·        MSSQLSERVER

·        SQLSERVERAGENT

 

SQLAdmin ·        Domain user account

·        Local Administrator on the SQL Server

SQL Admin on the SQL Server. It also needs Local Administrator rights to install the SQL server.
SPSetup ·        Domain user account

·        Local Administrator

·        Member of SQL Server roles:

o   Securityadmin

o   DBCreator

o   DBOwner

 

Setup SharePoint Products Configuration Wizard. During setup and configuration, SharePoint 2019 creates SQL databases.
SPFarm ·        Domain user account

·        Local Administrator

·        SecurityAdmin and DB_Creator rights on the SQL Instance

 

·        Configure and manage the server farm.

·        Run the Microsoft SharePoint Founda­tion Workflow Timer Service.

·        The application pool identity for Central Administration.

·        The process account for the SharePoint Timer Service.

 

SPAppliationPool ·        Domain user account Each web application runs inside an Internet Information Server (IIS) site, and an application pool runs each site.

I used standard naming conventions for the farm accounts, you can change the user names as per your organization user account policy.

Adnan, a distinguished professional, boasts an impressive track record as a Microsoft MVP, having achieved this prestigious recognition for the eighth consecutive year since 2015. With an extensive career spanning over 18 years, Adnan has honed his expertise in various domains, notably excelling in SharePoint, Microsoft 365, Microsoft Teams, the .Net Platform, and Microsoft BI. Presently, he holds the esteemed position of Senior Microsoft Consultant at Olive + Goose. Notably, Adnan served as the MCT Regional Lead for the Pakistan Chapter from 2012 to 2017, showcasing his leadership and commitment to fostering growth within the tech community. His journey in the realm of SharePoint spans 14 years, during which he has undertaken diverse projects involving both intranet and internet solutions for both private and government sectors. His impact has transcended geographical boundaries, leaving a mark on projects in the United States and the Gulf region, often collaborating with Fortune 500 companies. Beyond his roles, Adnan is a dedicated educator, sharing his insights and knowledge as a trainer. He also passionately advocates for technology, frequently engaging with the community through speaking engagements in various forums. His multifaceted contributions exemplify his dedication to the tech field and his role in driving its evolution.

Leave a Reply