Post reply

JOB Failed to run VB app using DTS

  • September 3, 2002 at 10:10 pm

    #78865

    Hi folks

    I'm facing a strange problem. I've made an application that runs fine when run independently. But when I schedule that to run as a job in sql server it fails.

    Some detail about the environment:

    1. SQL Server 7.0 (installed as a local system a/c, mixed mode security)

    2. DTS packages (security: NT authentication)

    The user running the job is in NT admin group and also belong to SysAdmin group in DB

    thanks!

    Fawad Irfan Sheikh

    Conclusion is the place when u get tired of thinking 😉

  • September 4, 2002 at 3:55 am

    #435892

    What account does SQL Server Agent run under and what does the package do (ex. Retrieves data from remote share on AS400, imports to staging table, cleans the data, moves to final table, turncates staging table.)?

    "Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)

  • September 7, 2002 at 1:42 am

    #436144

    I've checked SQL Server agent was running under system account and MSSQL Server was also running under the same a/c.

    I 've tried to change it to NT user (the same user) for MSSQLServer and Agent but it also doesnt work.

    Would you suggest what policy one should adopt in this case, I mean authentication of DTS pkgs, SQL server installation etc.

    Thanks

    Fawad Irfan Sheikh

    Conclusion is the place when u get tired of thinking 😉

  • September 15, 2002 at 9:51 pm

    #436566

    Problem is solved.

    Solution: Very simple, I remove the SQL Server and install it again with the NT user as a owner of it.

    Thanks

    Fawad Irfan Sheikh

    Conclusion is the place when u get tired of thinking 😉

Viewing 4 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply