Re: SQL Sever Agent

From: Tibor Karaszi (tibor_please.no.email_karaszi_at_hotmail.nomail.com)
Date: 03/18/04 

Date: Thu, 18 Mar 2004 21:26:40 +0100

Again, the SQL Server service doesn't have permissions to the registry keys
where this setting is stored. When you do the change in EM, EM is logged in
to SQL Server and SQL Server tries to do the changes in the registry. If SQL
Server doesn't have permissions on the registry keys, you get this error. 

-- 
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"Lonnie Rouse" <LRouse@Bizzuka.com> wrote in message
news:ff3401c40d23$07fa7f10$a101280a@phx.gbl...
> 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

  • ADP, Application Role, and objects
    ... The above link is to an atricle on how to implement SQL Server Application ... After you connect with your ADP, fire a bit of code to set the ... third party tools to view the data on the same database. ... Scenario 1 - If I explicitly grant permissions on that object to the user ...
    (microsoft.public.access.adp.sqlserver)
  • Re: field level security question
    ... Vyas, MVP ... listBox control that gets data from a query of the sql server table. ... > recent change in requirement) I see the option to limit permissions right ... > utility opens except their is just no data. ...
    (microsoft.public.sqlserver.security)
  • RE: SQL 2008 - remote connection to the SSIS 2008 - Access denied
    ... SQL Server configures the appropriate rights during the installation process, ... then add users/groups and assign the appropriate permissions. ... user who created the package apply to the writer role. ... I checked DCOM MsDts component and my user rights for the Remote ...
    (microsoft.public.sqlserver.dts)
  • Re: Deny access to all users (including Administrator and DomainAd
    ... permissions on stored procedure override ... applictaion's user account permissions to the stored procedure which will ... Will try to deny access through the query for SQL Server 2005 and 2000. ... Remove everyone that you don't want rom an Administrator Groups ...
    (microsoft.public.sqlserver.security)
  • Re: SQL 2000 Windows Authentication - Same User Multiple Groups
    ... functionality using our WinForm app and read-only functionality using ... SQL Server permissions are not application-aware. ... App1 contains CRUD functionality using stored procs (EXEC perms on ...
    (microsoft.public.sqlserver.security)