EdVassie (8/12/2013)

---

Using a domain user account for SQL Agent works fine in SQL 2012 (and SQL 2005, 2008, 2008R2, 2014), you just have to give it the correct rights.

It needs:...

Jacob Wilkins (8/9/2013)

---

I have some Windows server 2012 + SQL Server 2012 combinations both in the lab and in production, and they work without issues (well, without this issue :-D)....

Jacob Wilkins (8/8/2013)

---

Two questions:

1) Does the SQL Server error log show a login failure for that login when you try to start the Agent?

2) The "Access Denied" error you received...

I have granted NT AUTHORITY\NETWORK SERVICE the sysadmin server role. This should give it rights to...

Process Monitor also shows a few ACCESS DENIED entries as I attempt to start the service. Here is one directly related to the agent:

Process Name: SQLAGENT.EXE

Operation: CreateFile

Path: D:\SQLData\data\MSSQL11.MSSQLSERVER\MSSQL\Binn\sqlsvc.dll

Result: ACCESS...

Joie Andrew (8/7/2013)

---

When you try and start the SQL Agent service under a local account and it fails do you get any logon failures in the security log in Event...

Currently its running under LocalSystem. But I have made a local account for it and entered...