Post reply

Confused with SSIS & SQL Windows Authentication/Service account

  • February 15, 2007 at 5:30 am

    #122983

    Hi All,

     

     

    I have a question about SSIS packages that I would like to clarify, in the database connection section if you are using OLEDB SQL server Connection; it has options for Windows/SQL server login authentication.

     

    My question is are as follows, if I have a connection onto a database using windows authentication, does it use the service account, or the windows account of who ever is logged in ?

    Kindest Regards,

    John Burchel (Trainee Developer)

  • February 16, 2007 at 5:45 am

    #690178

    It will use whatever account is running the package. Thus if the user was running it, it would be the user's account. If sql agent runs it, it will be sql agent's account.

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

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