Sql-server – SQL Server Agent – Service Failed to Start (Access is Denied)

sql-server-2012

I have a server running Server 2012 R2 with SQL Server 2012 installed. The SQL Server Agent works fine if it is running under Local System. I changed the SQL Agent service account to a domain account and the service will not start. Checking the event viewer the only error message available is the one below.

The SQL Server Agent (NEPO) service failed to start due to the
following error: Access is denied.

If I add the domain account to the local admin group on the server the service starts normally. I don't want to leave that account as a local admin. I have also gone through and manually granted all the permissions Microsoft outlines in this article. Still getting the same error and not sure where to turn next.

Best Answer

I hope you are using Configuration Manager to change the Service account.Using the service.msc applet does not grant required permission

Refer the link : https://social.msdn.microsoft.com/Forums/sqlserver/en-US/975c86b9-3622-418a-8e19-6720a51d7549/access-denied-starting-sql-server-agent?forum=sqlgetstarted

Other way could be to add the Service account in SQL Server as sysadmin and then configure it to run under the required service account.

Related Solutions

Sql-server – Start service error code 3417 with SQL Server 2012

That error is usually associated with the Master database, so you are on the right track. Does the service account have access to the directory where the Master database resides?

There should be some additional errors in either the SQL Server error log or the Windows event log that may narrow down the issue. Look for access denied messages or cannot find file messages associated with the master database and other system databases.

One other thing I have found on other sites is folder compression being a problem. Make sure SQL Server does not reside on a compressed folder or drive.

If that doesn't work, then rebuild as suggested.

Sql-server – SQL Server Service Account login or password is not valid error

The issue isn't with the account you are attempting to use, but your account. If you look in the setup log file, which is created during the installation of the SQL Server application, you will see the details of the issue, with technical jargon that will indicate the issue is probably a permission issue with your account having permission to perform a check on the service account credentials:

Slp: Sco: Attempting to check if container ‘WinNT://DOMAIN’ of user account exists
Slp: UserSecurity.ValidateCredentials — Exception caught and ignored, exception is Access is denied.
Slp: UserSecurity.ValidateCredentials — user validation failed

Rebooting usually fixes this issue, as does changing the service account value after installation is complete. A minor issue that sometimes appears.

Best Answer

Related Solutions

Sql-server – Start service error code 3417 with SQL Server 2012

Sql-server – SQL Server Service Account login or password is not valid error

Related Question