RE: master..xp_cmdshell Error 997 from GetProxyAccount

• Previous message: khanson2k: "SQL Login from NTDOMAIN account"
• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]

Date: Thu, 29 Jul 2004 17:49:04 -0700

- Start SQL Enterprise manager
- Open your server
- open the Management folder
- right mouse on SQL Server Agent and select properties
- select Job System tab
- UNCHECK the box in the section 'Non SysAdmin job step proxy account'
  which says 'Only users with SysAdmin priveleges can ...'
- when the dialog comes up enter the username, password, [domain] of
  some defined Windows user with sysAdmin priveleges (create one if needed first).
- click Apply and OK

"Phil" wrote:

> Hello all,
>
> I have an aspx page that inserts a record in a table via a stored
> procedure. That table has a trigger which gets fired on an insert. The
> trigger has the following code
> EXEC master..xp_cmdshell 'C:\MyApp\try.exe'
> This all works when the stored procedure is fired inserting the record
> in turn firing off the trigger; but when the ASPX page runs the stored
> procedure I get the following error.
>
> A severe error occurred on the current command. The results, if any,
> should be discarded. xpsql.cpp: Error 997 from GetProxyAccount on line
> 472
>
> The Guest login has permissions to the extended stored procedure
> xp_cmdshell on the master db, but this has not helped.
>
> Any help would be greatly appriciated.
> Phil
>

• Previous message: khanson2k: "SQL Login from NTDOMAIN account"
• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]