xp_sqlagent_proxy_account and post sp2

From: Brian Smith (bsmith@REMOVEMEjob1usa.com)
Date: 09/12/02 

From: "Brian Smith" <bsmith@REMOVEMEjob1usa.com>
Date: Thu, 12 Sep 2002 09:48:03 -0400

Hello,

  I updated my sql 2000 sp2 with the most current security roll up package
and now my sql server agent proxy no longer will run xp_cmdshell. How do I
re-instate it? Or should I be looking somewhere else. Thank you for any
help.

Brian Smith

Relevant Pages

  • Re: SQL 2000 DTS Permissions
    ... Microsoft Data Transformation Services (DTS) Package ... Error Source= Microsoft OLEDB Persistence Provider ... another server with a different SQL Server Agent account. ...
    (microsoft.public.sqlserver.dts)
  • RE: File specified in the connection was not valid
    ... SSIS Package Execution authority using that Admin Credentials. ... Agent job to use your new Proxy. ... Todd Chittenden ... However, when I set this package up as a step in SQL Server Agent Job, I get ...
    (microsoft.public.sqlserver.dts)
  • Re: Global Variables
    ... When you right click and execute a dts package, ... > permissions the sql server agent has on the operating system. ... > the package will fail since you are trying to read the file system. ...
    (microsoft.public.sqlserver.dts)
  • Re: Error running DTS package on a schedule (only!)
    ... Also, if you are using ODBC, create System DSN, and delete User DSN. ... > | When I try to schedule a job for this DTS package under SQL Server Agent ... > security connection is made using the account you used to start SQL Agent ...
    (microsoft.public.sqlserver.dts)
  • Re: Error running DTS package on a schedule (only!)
    ... My DTS packages do use ODBC to connect to an SQLAnywhere 5.0 database. ... > Also, if you are using ODBC, create System DSN, and delete User DSN. ... >> | When I try to schedule a job for this DTS package under SQL Server Agent ...
    (microsoft.public.sqlserver.dts)
Quantcast