Home Forums SQL Server 2012 SQL 2012 - General Problem with agent service accounts? RE: Problem with agent service accounts?

  • August 9, 2013 at 1:52 pm

    #1640271

    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 looks more like a file system permissions issue. Have you checked file systems permissions?

    Cheers!

    SQL error log shows nothing.

    I have tried setting that local user full rights to HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL11.MSSQLSERVER\SQLServerAgent - did nothing

    I have tried setting D:\SQLData\data\MSSQL11.MSSQLSERVER\MSSQL\Log full rights to that local user - did nothing

    For what its worth I have tried this on a second Server 2012 machine and it behaves the same. Is anyone here actually running this combo successfully ? Windows Server 2012 + SQL 2012 ? Something must have changed but I cant figure out what.