SQL Server Performance

Unable to Schedule DTS, Giving error (Not Associte

Discussion in 'SQL Server DTS-Related Questions' started by jainashish, Nov 21, 2005.

  1. jainashish New Member

    I have created one DTS in sql server 2000 (using OS Windows 2003 server) that will copy records into database on another system (Windows XP).

    When i execute this DTS from enterprise manager it works fine but when i schedule this DTS to run in every 1 minute from enterprise manager only, then it will give me an error in log file "Step Error Description:Login failed for user 'sa'. Reason: Not associated with a trusted SQL ".....


    Plz help me out as i am creating this DTS first time and it's very urgent as i am trying to found the solution since last 1 week but in vain...

    any help is highly appreciated.

    with regards
    ashish


  2. surendrakalekar New Member

    quote:Originally posted by jainashish

    it will give me an error in log file "Step Error Description:Login failed for user 'sa'. Reason: Not associated with a trusted SQL ".....

    Add this statement: "Integrated Security=SSPI;" after Initial Catalog and try.


    Surendra Kalekar

  3. jainashish New Member

    Hi Surendra,

    Thanks for such a quick response, plz can u ellaobrate in detail as i am not much aware of sql server itself. where can i find initial Catalog and what does it do.

    thanks in advance
    with regards
    ashish
  4. surendrakalekar New Member

    quote:Originally posted by jainashish

    Hi Surendra,

    Thanks for such a quick response, plz can u ellaobrate in detail as i am not much aware of sql server itself. where can i find initial Catalog and what does it do.

    thanks in advance
    with regards
    ashish
    That you have to add in the connection string. Read BOL for more about DTS and connection string.



    Surendra Kalekar

  5. Argyle New Member

    Sounds like you are running your sql server in Windows Authentication mode and not Mixed SQL / Windows. So it works when you run it manually as MYSERVERAdministrator but not scheduled as 'sa'.

    Either switched to mixed authentication mode or schedule the job to run with the sql service windows account.
  6. jainashish New Member

    Hi Argyle,

    On both of the computer's i am using Mixed mode only.

    thanks in advance
    ashish
  7. Madhivanan Moderator

    See if connection string is correct www.ConnectionStrings
    and also check the DTS Coding at www.sqldts.com


    Madhivanan

    Failing to plan is Planning to fail
  8. ranjitjain New Member

    You can even try this.
    Create a procedure to run the DTS using dtsrun utility and then create a job to run the procedure using T-SQL task in job.

    Check whether this SP runs DTS perfectly or not.
  9. jainashish New Member

    Now i made a DTS and creating the job to run that DTS file using dtsrun utility(dtsrun /F
    "C:DTS
    ew_ashish.dts" /n "testing") but still i am getting the error..

    "The job failed. The Job was invoked by User sa. The last step to run was step 1 (DTS package)"

    plz help me out with these errors.

    Regards & Thanks
    ashish

Share This Page