installation of sharepoint 2019

Question

I need to install the above with shared services like search, user profiles, and others.

I need to create the NT logon and what permission in AD group and SQL do they need to be?

e.g

The SP Farm account needs a local admin account for installation and ???? in AD and ??? in SQL

The SP Search account needs to be ???? in AD and ??? in SQL

What would you recommend for quick development on Sharepoint without using Power Automate and Powerapps?

Can I install workflow manager and use Sharepoint designer , if so are they any articles ?

thanks

Answer 1

Hi @nellie ,

For the SP Farm account, it needs to have local administrator privileges during installation because it needs to be able to install and configure SharePoint on the server. In Active Directory, it should be added to the Domain Admins group because this group has full control over all domain-joined computers. In SQL Server, it should be added as a sysadmin because this role has full administrative privileges over the SQL Server instance and all databases.

For the SP Search account, it needs to be added to the domain user group in Active Directory because this group has the necessary permissions to access resources on the domain. In SQL Server, it should be added as a db_owner for the search database because this role has full control over the database and can perform all tasks related to managing the search service.

For quick development on SharePoint without using Power Automate and PowerApps, you can use SharePoint Framework (SPFx). This is a client-side development framework that allows you to create custom web parts and extensions for SharePoint.

Yes, you can install Workflow Manager and use SharePoint Designer.

There are some articles for your reference:

https://learn.microsoft.com/en-us/sharepoint/dev/general-development/set-up-and-configure-sharepoint-workflow-manager

https://learn.microsoft.com/en-us/sharepoint/dev/general-development/creating-a-workflow-by-using-sharepoint-designer-and-the-sharepoint-wo

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

Hi there what about user profiles, I presume there will be a dedicated AD logon and SQL permission. If so what would it be ?

thanks