SQL account used for SharePoint
When we plan to build the SharePoint,
The first and most important part is the account used for the SQL admin. Please
find the details below that provide you more information on the account.
1. SQL Admin Account
SQL Admin account would be use to install SQL
Server for your SharePoint and would be created in AD. This account should be a
domain user and must be a local administrator on database server. These rights
are enough to successfully install SQL Server. Do not use any other domain
admin account or never make this as a domain admin account. I have seen people
using domain admin account to install SQL and SharePoint which is a mistake and
a threat to security. You can name this account as "sql_install" or
"sql_admin".
2. SQL Service Account
This is the account that runs the SQL Server
instance. This should be a domain user but do not make this as a local
administrator for security reasons. You can name this as "sql_user"
or "sql_services". While installing SQL Server with SQL Admin
account, necessary permission would be granted to this account for running the
SQL Server instance. At Server Configurations step during SQL Server
installation, mention your SQL Service account as the account for SQL Server Database
Engine and SQL Server Browser and automatically necessary rights would be
granted to this account to run the SQL Server instance.
3. SharePoint Setup Account
Create an account "sp_install" (a
recommendation, you can name it anything) in your AD and put this account in
local administrator group on all SharePoint Servers. Make sure you do not put
this account in domain administrator account. You should never use a domain
admin account to install SharePoint and its services.
I hope the above information will help you to resolve the issue, in case of any queries/questions regarding the above mentioned information then please let me know. I would be more than happy to help you as well as resolves your issues, Thank you.