Search

SQL Agent cannot start - Access Denied by Vedran Kesegic

Closed
as Not Reproducible Help for as Not Reproducible

1
0
Sign in
to vote
Type: Bug
ID: 766248
Opened: 10/5/2012 12:38:27 AM
Access Restriction: Public
0
Workaround(s)
0
User(s) can reproduce this bug
SQL Agnet cannot start with default virtual account "NT SERVICE\SQLSERVERAGENT", after clean installation with almost all default settings.
It even does not generate SQLAGENT.OUT file, although file and LOG folder permissions are set correctly (Read/Write).
If I change the user to LOCALSYSTEM, SQL Agent starts without problem.
I did not change any permissions on the machine, everything is set by installer.
Some details are here:
http://www.sqlservercentral.com/Forums/Topic1367772-2799-1.aspx#bm1368251
Details (expand)

Product Language

English

Version

SQL Server 2012 - Developer Edition

Category

Tools (SSMS, Agent, Profiler, Migration, etc.)

Operating System

Windows 7 Ultimate (SP1)

Operating System Language

Croatian

Steps to Reproduce

Install SQL 2012 RTM Developer Edition with default settings.

Actual Results

"Access denied" if you try to start SQL Agent. No SQLAGENT.OUT file generated.

Expected Results

SQL Agent running under default virtual account "NT SERVICE\SQLSERVERAGENT"

Platform

X64

Virtualization

 
File Attachments
0 attachments
Sign in to post a comment.
Posted by Microsoft on 11/1/2012 at 3:52 PM
Not yet received setup logs from customer. Please reactivate if you have the setup logs

Thanks
Sethu Srinivasan [MSFT]
SQL Server
Posted by Sethu Srinivasan on 10/26/2012 at 9:31 AM
Also please check related email thread
http://social.msdn.microsoft.com/Forums/en-US/sqldatabaseengine/thread/5b477587-9f5f-4ac3-af54-fba81d0c9bcc/

We would like to know if the issue you are seeing is the same one or a different scenario

Thanks
Sethu Srinivasan [MSFT]
Posted by Sethu Srinivasan on 10/25/2012 at 2:44 PM
Could you please send us SQL Server setup logs?. you can locate setup logs at \Program Files\Microsoft SQL Server\110\Setup Bootstrap\Log

Thanks
Sethu Srinivasan [MSFT]
SQL Server
Posted by Microsoft on 10/15/2012 at 3:52 PM
Thank you for reporting this issue - we are investigating and will update you when we have more information.

Thanks,

Alex Grach [MSFT SQL SERVER]
Posted by Microsoft on 10/15/2012 at 3:52 PM
Thank you for reporting this issue - we are investigating and will update you when we have more information.

Thanks,

Alex Grach [MSFT SQL SERVER]
Sign in to post a workaround.