i have been having repeated problems with the SQL Agent. I have two loca
accounts created, one to run SQLServer service and the other for the Agent
service. Neither are members of the Administrators group.
All of my scheduled jobs have the Agent Login set as the owner. I am unable
to run the jobs manually via the Agent GUI, but can run them via TSQL.
I have a large number of errors in the event log that I am pasting in this
post.
What am I doing wrong? Please help.


Event logs:
The data portion of event 17052 from MSSQLSERVER is invalid.

You do not have sufficient operating system permission to open the
SQLServerAgent status event.

Hello

The domain user account you use to start SQL Server Agent must have the
following permissions:

Read/Write to:
HKEY_LOCAL_MACHINE\Software\Microsoft\ MSSQLServer or
HKEY_LOCAL_MACHINE\Software\Microsoft\Microsoft SQL Server,

HKEY_LOCAL_MACHINE\System\CurrentControlset\ Services\MSSQLServer or
HKEY_LOCAL_MACHINE\System\ CurrentControlset\Services\MSSQL$Instancename,

HKEY_LOCAL_MACHINE\Software\Microsoft\ Windows NT\CurrentVersion\Perflib

Change permission for the \Program Files\Microsoft SQL Server\Mssql
directory (this directory will be different if you changed it during the
installation)

Log on with service privileges

Change permissions to the data and log files

Yet again, I am assuming that you have domain user accounts. If you have a
simple network, it's easier to join your users to the local Admins group on
your server. Otherwise, you will run in this kind of problems

Regards,
io

"RKinder" wrote: