Re: xp_sqlagent_proxy_account

From: Richard Waymire [MSFT] (rwaymi@online.microsoft.com)
Date: 03/10/03 

From: "Richard Waymire [MSFT]" <rwaymi@online.microsoft.com>
Date: Mon, 10 Mar 2003 11:41:12 -0800

Is the sql agent account an administrator? Proxy account credentials are
stored in the LSA Secrets part of the registry and you must be an NT admin
to get to that part of the registry... 

--
Richard Waymire, MCSE, MCDBA
This posting is provided "AS IS" with no warranties, and confers no rights.
"mkumri" <mroopdaska@hotmail.com> wrote in message
news:002701c2e4d8$ba73df20$a501280a@phx.gbl...
> I have server running sql2k sp3.
>
> When i try to excute the xp_sqlagent_proxy_account i get
> the following error.
>
> Error executing extended stored procedure: Specified user
> can not login
>
>
> I have the following local policies set for the SQL agent
> account .
>
>
> 1.Act as part of the operating system
>
> 2.Bypass traverse checking
>
> 3.Increase quotas
>
> 4.Log on as a batch job
>
> 5.Log on as a service
>
> 6.Replace a process level token.
>
> any help??
>
> Thanks,
> MK
>

Relevant Pages

  • Re: writing to registry in vista from guest account
    ... My application fails to write into registry key. ... After the installation I create new user/guest account and runs the ... The Standard user can have its rights elevated to admin level by giving a admin user-id a psw, which is only at the moment of escalation and is not maintained for the user. ... If the user account is a non-admin account, then it's not going to have admin rights as an designated user admin account, and the access is denied. ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: registry hacked under XP limited account
    ... >> The thing I want to know is that the registry can be modified ... Running as limited account does VERY LITTLE to stop ... running with administrative rights is a VERY BAD HABIT. ... This tactic will NOT be effective against future malware. ...
    (microsoft.public.security)
  • Re: How good is Comodo Internet Security?
    ... You don't even have to delete the account. ... Currently iam logged in on windows vista as standard user "nik" but ... I'm a member of admin groups. ... altered on the system afterwards (files and registry), ...
    (comp.security.firewalls)
  • Re: SP2 Wont Install - "Access Denied"
    ... How to back up, edit, and restore the registry in Windows XP and Windows Server 2003 ... Read all of it and many of the related links (like how to go about editing the registry). ... My client told me yesterday that his computer used to have two admin user accounts and that my predecessor deleted one of them...which, I'm guessing, was probably the "main" administrator account. ...
    (microsoft.public.windowsupdate)
  • Re: Registry problem: "Error while deleting key"
    ... Could not open key ) etc. ... It seems like something is corrupted in the registry, ... Are you an administrator in a domain login for your host, or are you logging on under a local admin account? ... Being an admin for your host under a domain doesn't necessarily give you *full* admin privileges. ...
    (microsoft.public.windowsxp.general)
Quantcast