Post reply

Windows Authentication question

  • October 4, 2011 at 9:01 am

    #99485

    Hi Guys,

    Just wondering... I've changed packages to run using windows authentication and i've changed the dtsrun script in the jobs to use windows authentication also. So when a job is scheduled to run, what windows authentication does it use or what account? i.e. how does it run if no one is logged into the server at the time?

    Thanks

    G

  • October 4, 2011 at 10:56 am

    #1390252

    If the package is scheduled to run through SQL Agent, then this will be executed under the security context of the service account used for SQL Agent.

  • October 28, 2011 at 8:13 am

    #1400641

    Oh yeah.. thanks. Should have known that!

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

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