Post reply

Accessing data source that only supports Windows Auth

  • August 18, 2004 at 6:44 pm

    #360688

    hi,

    I'm developing a data warehousing application using DTS as the means to extract the data from the data source to my data mart.  The data source application uses SQL Server 7 and up to the latest versions of the application allowed SQL authentication. However, going forward, the application will only allow Windows authentication.  So, what needs to be done to allow the DTS program running on the data mart to be allowed to extract data from the data source?

     

    Thanks,

    Tom

     

  • August 20, 2004 at 8:17 am

    #519996

    How is the DTS data pull being executed?  Is it a SQL job that is scheduled?  Is someone running it from EM DTS Designer, DTS Run Utility, or command prompt?

    Corie Curcillo
    MCT, MCDBA, MCSD

  • August 20, 2004 at 9:39 am

    #520011

    A schedule SQL server agent job on the data mart has each job step defined as a DTSRun command.  On of these commands is used to pull the data from the data source.  So I'd say it's being run from the DTSRun utility.

  • August 20, 2004 at 10:34 am

    #520019

    Since a scheduled package runs under the security context of the Windows login designated as the SQL Service startup account, make sure that that login has permission to access the data source.

    Greg

     

    Greg

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

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