locked
SQL Server 2012 SP2 NTService Accounts Access Denied starting services RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    We have an SQL Server 2012 SP1 which was running perfectly until we applied the SQL Server 2012 SP2.

    After SP2 was installed and the server rebooted all the associated SQL services that uses NTService\xxxxxxx accounts failed to start with Error 5: Access Denied.

    We were able to change the services to Local System account but I just want to understand why this occurred and is this ok?

    Has anyone had a similar issue or can anyone assist with an explanation?

    Monday, September 15, 2014 1:13 AM

Answers

  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi Giulio,

    Based on your description, I tested the scenario as yours. After applying SQL Server 2012 SP2, I reboot the server , then restart all the associated SQL Server services that use NT SERVICE\<SERVICENAME> accounts successfully.

    According to the error message, it might be caused by that NT SERVICE\<SERVICENAME> accounts don’t have sufficient permissions to access the SQL Server services installation folders. You can post detailed information in the SQL Server Errorlog file for analysis.

    In addition, Local System is a very high-privileged built-in account. It has extensive privileges on the local system and acts as the computer on the network. And it is not recommend to use local system account for running SQL Server services. For more details about configuring SQL Server Service accounts, you can review the following links.

    Configure Windows Service Accounts and Permissions: http://msdn.microsoft.com/EN-US/library/ms143504.aspx#Windows
    Best Practices For Using SQL Server Service Accounts: http://blogs.technet.com/b/canitpro/archive/2012/02/08/the-sql-guy-post-15-best-practices-for-using-sql-server-service-accounts.aspx

    Thanks,
    Lydia Zhang

    Tuesday, September 16, 2014 6:25 AM