Results 1 to 6 of 6
  1. #1
    Join Date
    Mar 2004
    Posts
    14

    Unanswered: Help DTS Job programming

    Hello:
    I'm scheduling DTS packages to run as a job but when I do that, the job siply does not works, someone tolds me that it's a problem with the SQL and Windows NT authentication and security and he gaves me this URL http://support.microsoft.com/default...EN-US;Q269074.
    but it not so clear to me, i'm working with SQL Server 200 and Windows Server 2000.

    What can I do?

  2. #2
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    The job simply does not work ....
    This means what are you getting any error?
    If so review information from DTS package log and SQL error log or use PROFILER to monitor the activity.

    That is the only KBA information available if you want to schedule a dts package.

    Come with complete details about issue and setup.
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

  3. #3
    Join Date
    Oct 2001
    Location
    Naples, FL
    Posts
    273
    Always make sure you have the same drivers on the server as you do on your local machine if applicable. Don't know if that helps or not
    ---------------
    Ray Higdon MCSE, MCDBA, CCNA

  4. #4
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    If you schedule the DTS package it will run in the context of sqlagent privileges and drivers on that server. And also the same fashion even though if you execute the package manually.
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

  5. #5
    Join Date
    Oct 2001
    Location
    Naples, FL
    Posts
    273
    I've seen this as a common problem when people are connecting to the server but running the package from a machine that does have appropriate drivers.

    For poster - this may help, these guys are the bet in the biz with DTS - http://www.sqldts.com/default.aspx?222
    ---------------
    Ray Higdon MCSE, MCDBA, CCNA

  6. #6
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    someone tolds me that it's a problem with the SQL and Windows NT authentication and security
    BTW what is the current authentication set on SQL Server?
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •