Re: Executin DTSrun Utility under the xp_cmdshell

The error 80004005 would suggest either permission problems or that the thing for which you look does not exist.

This is from BOL.

xp_cmdshell operates synchronously. Control is not returned until the command shell command completes.

When you grant execute permissions to users, the users can execute any operating-system command at the Microsoft Windows NTR command shell that the account running Microsoft SQL ServerT has the needed privileges to execute.

By default, only members of the sysadmin fixed server role can execute this extended stored procedure. You may, however, grant other users permission to execute this stored procedure.

When xp_cmdshell is invoked by a user who is a member of the sysadmin fixed server role, xp_cmdshell will be executed under the security context in which the SQL Server service is running. When the user is not a member of the sysadmin group, xp_cmdshell will impersonate the SQL Server Agent proxy account, which is specified using xp_sqlagent_proxy_account. If the proxy account is not available, xp_cmdshell will fail. This is true only for MicrosoftR Windows NTR 4.0 and Windows 2000. On Windows 9.x, there is no impersonation and xp_cmdshell is always executed under the security context of the Windows 9.x user who started SQL Server




"rallbee" <rallbee@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:rallbee@xxxxxxxxxxxxxxxxxxxxxxxxx:

I am attempting to execute a DTS package from Query Analyzer using the DTSrun
utility under xp_cmdshell. When I execute the package, I receive the
following error:

"DTSRun OnError:  Copy Data from Results to
J:\IDEAS40\TRISQL44\MJE\Data\MJE065d.txt Step, Error = -2147467259 (80004005)
   Error string:  Error opening datafile: Logon failure: unknown user name
or bad password."

However, when I excute the same package under a DOS prompt, the package
executes successfully.  The same is true when the package is executed via
Enterprise Manager.  Can someone help?


.

Relevant Pages

  • Re: SQL CLR Sproc isnt running right
    ... did you grant rights using the SQL Server 2005 Surface Area Config tool? ... and I got a permissions error back saying DBO doesn't have permission to insert records into the table... ... but the assemblie's stored procedures do all have execute permissions set for the role that the executing user is in... ... "William Vaughn" wrote in message ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: user to execute nothing but SP in 2005
    ... What explicit permission I need to give. ... permission and then just grant Execute (I also tried to grant connect ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ...
    (microsoft.public.sqlserver.security)
  • Re: Execute Persmission denied on object sp_OACreate
    ... > SQL Server is creating a job behind the scenes. ... > permissions. ... > SA account password and gaining access to the database. ... >>> How can get a user permissions to execute these stored procedures ...
    (microsoft.public.sqlserver.security)
  • RE: exec sp_help_job user account rights
    ... wrapper in which u can call original stored procedure sp_help_job using “WITH ... EXECUTE AS “ clause and then give execute permission of external stored ... Database Administrator, SQL Server 2005 ... the sysadmin fixed role can use sp_help_job to view only the jobs he/she owns. ...
    (microsoft.public.sqlserver.security)
  • Re: Stored Procedure Security/Permissions
    ... Cross-Database Ownership Chaining Behavior Changes in SQL Server 2000 ... > permission to read either table; ... > permission to execute the stored procedure, ...
    (microsoft.public.sqlserver.security)