Re: Security

Tech-Archive recommends: Speed Up your PC by fixing your registry

From: Uri Dimant (urid_at_iscar.co.il)
Date: 12/13/04 

Date: Mon, 13 Dec 2004 13:43:36 +0200

mat
When you execute the DTS by clicking on the package it is running under
permissions that defined on your workstation (local account probably) , as
opposite when it runs with a job ,it should be run under SQL Server Agent
account (It should be most likely a domain account)

"mat" <mat@discussions.microsoft.com> wrote in message
news:5520F76E-AE6E-4B14-AE67-2CCBBC4179DC@microsoft.com...
> I have a dts package that transfers data from one sql server to another.
it
> uses a SQL login to connect to the second server. When the DTS package is
> executed it runs fine but if it is executed from a job or using the dtsrun
> utility it always fails
>
> Can anyone help?

Relevant Pages

  • Re: Execute Persmission denied on object sp_OACreate
    ... > I logged in as that user, tried to execute the DTS ... which then launches the DTS package using the sp_OA* procs? ... account is used during proc execution. ... > proxy account to use in the Job Systems tab of SQL Server Agent ...
    (microsoft.public.sqlserver.security)
  • Not all steps in DTS package execute
    ... When run through DTS Designer, all steps execute except the last one (Step ... DTSRun OnFinish: DTSStep_DTSActiveScriptTask_2 ... Microsoft Data Transformation Services Package ...
    (microsoft.public.sqlserver.dts)
  • Re: Import and Schedule DTS on MSDE
    ... The dtsrun utility executes a package created using Data Transformation Services. ... Displays the command prompt options. ... Displays the encrypted command used to execute the DTS package without executing it. ...
    (microsoft.public.sqlserver.tools)
  • Cross post recommended on this seemingly sinple problem
    ... >I have an ActiveX Script task in a DTS package which executes fine ... Why does the scheduled job not execute ... > schedule and the account is a domain account with windows ... even with both the package and the job owned by the same account (I ...
    (microsoft.public.sqlserver.dts)
  • Re: dts or xp_cmdshell permissions
    ... You could have the users execute the package ... Change the SQL Server or SQL Server Agent Service ... >> Account Without Using SQL Enterprise Manager in SQL Server ...
    (microsoft.public.sqlserver.tools)