When does SQL Server service is a local user account?
This error usually happens when the service running the SQL Server service is a local user account. Let’s see the service user under which the MSSQLSERVER service is running from Services.msc. It is running under the user NT ServiceMSSQLServer. We will have to change it to a domain account/Local System/Network Service.
How to troubleshoot when SQL Server services don’t start?
If we try to start SQL via services, we will get below error. Windows could not start the SQL Server (MSSQLSERVER) on Local Computer. For more information, review the System Event Log. If this is a non-Microsoft service, contact the service vendor, and refer to service-specific error code 17113.
Can a logon account be a SQL Server service?
One of the issues that can come up during the prerequisite check is shown below: The logon account for the SQL Server service cannot be a local user account, NT SERVICE\\ or LOCAL SERVICE. You must configure the SQL Server service to use a valid domain account, NETWORK SERVICE, or LOCAL SYSTEM.
When does SQL Server service use a valid domain account?
You must configure the SQL Server service to use a valid domain account, NETWORK SERVICE, or LOCAL SYSTEM. This error usually happens when the service running the SQL Server service is a local user account. Let’s see the service user under which the MSSQLSERVER service is running from Services.msc.
Can a SQL Server Agent service account be a Windows user?
We recommend choosing a Windows user account that is not a member of the Windows Administrators group. However, there are limitations for using multiserver administration when the SQL Server Agent service account is not a member of the local Administrators group.
What kind of user account would you recommend running the SQL?
Depending on if the server instance will need to access other domain resources or not should determine which type of low privilege account it should run under.