Re: Change sql agent login user

From: Dejan Sarka (dejan_please_reply_to_newsgroups.sarka_at_avtenta.si)
Date: 02/08/04


Date: Sun, 8 Feb 2004 10:24:56 +0100

Hi!

Do please check if the article at
http://support.microsoft.com/default.aspx?scid=kb;en-us;283811 is helpful
for you.

-- 
Dejan Sarka, SQL Server MVP
Associate Mentor
Solid Quality Learning
More than just Training
www.SolidQualityLearning.com
"shivi" <infor@villageideas.com> wrote in message
news:c2b901c3ed05$20714760$a501280a@phx.gbl...
> In keeping with the microsoft suggestion, I changed the
> mssql agent login to a user. Now My application does not
> run, the error log reports the following
> RegOpenKeyEx of "SOFTWARE\Microsoft\MSSQLServer\" failed:
> Result Code = 0x00000005
>
> I have tried adding users, and domain users. it only works
> if I add the administrators from the built in group.
> Please help!


Relevant Pages

  • Re: best way to scrub data
    ... Dejan Sarka, SQL Server MVP ... This message does not imply endorsement from Solid Quality Learning, ... > sensitive data like user info,credit card info,etc.. ...
    (microsoft.public.sqlserver.security)
  • Re: clearing concept
    ... and Extents" chapter. ... >> Dejan Sarka, SQL Server MVP ... >> Solid Quality Learning ...
    (microsoft.public.sqlserver.clients)
  • Re: predetermine size of differential
    ... You can try with the undocumented DBCC PAGE command - see ... Dejan Sarka, SQL Server MVP ... Solid Quality Learning ...
    (microsoft.public.sqlserver.server)
  • Re: how to order by string data type that is actually numeric?
    ... Dejan Sarka, SQL Server MVP ... Solid Quality Learning ... "Bobby" wrote in message ...
    (microsoft.public.sqlserver.programming)
  • Re: switching from CAL to Processor license
    ... thank you soooooo much for your response - you can't imagine how much work ... You're right the MS knowledge base didn't help but your ... > Dejan Sarka, SQL Server MVP ...
    (microsoft.public.sqlserver.setup)