I'm running SQL Server 2008 R2 a Windows 2008 Enterprise Hyper-V virtual. The MSSQLSERVER service will start using the NetworkService account. I've configured and want to use a domain service account to run the SQL Server process. When I login
to the machine with the domain service account and set the "Log on as" to the service account, the SQL service starts up fine.
When I logon on to the machine as any other domain user, set the "Log on as" to the domain service account I want to use, the service does not start.
I have the SPN correctly MSSQLsvc/<machine name>:1433 and with FQDN.
The service account has been granted "log on as service" and some other local policy privilages.
The Force Protocol Encryption is set to NO.
The VIA protocal is disabled.
I've done on this in a 2003 environment with SQL Server 2005 with no problems for years now. But this is throwing me for a loop.
The following is from the System Event log when the service fails to start
The LoadUserProfile call failed with the following error: Access is denied.
The SQL Server (MSSQLSERVER) service terminated with service-specific error 2148081668 (0x80092004).
This is from the
View Complete Post