Re: SQL Sever Agent

From: Lonnie Rouse (LRouse_at_Bizzuka.com)
Date: 03/18/04 

Date: Thu, 18 Mar 2004 11:55:58 -0800

Tibor,
Thanks, I went to the services manager for windows 2000
server and set the server agent to automatic instead of
manual. It then posted the correct settings to the
properties tag. I am not sure what user account is
controling the tab, I still get the error when I try to
change it back, but at least I have it running as an
automatic service now! Thanks again, my databases are
being backup now by the agent what a relief!
>-----Original Message-----
>Seems like the SQL Server service account doesn't have
appropriate
>permissions in the registry. Search BOL for "level token"
and I think you
>find the page about required permissions.
>
>--
>Tibor Karaszi, SQL Server MVP
>http://www.karaszi.com/sqlserver/default.asp
>
>
>"Lonnie Rouse" <LRouse@Bizzuka.com> wrote in message
>news:b01c01c40d06$60d1bee0$a001280a@phx.gbl...
>> I am trying to set the option "Auto Start SQL Server
>> Agent" on the database properties "General" tab. When I
>> check (enable) the selection and press "OK" I get the
>> error: Error 22002:RegCreateKey() returned error
>> 5, 'Access is denied'. Any suggestions as to how to fix
>> the error?
>
>
>.
>

Relevant Pages