Proxy Accounts to execute stored procedure

  • I have requirement to create sql agent job on server A to execute stored procedure on server B, i am opting proxy account rather creating sql account for this need ,but wondering if this is the correct solution or something better can be used here , also if proxy account is the best solution ,what is the password change procedure for Windows domain account on which proxy account is based on, will i need to change the password on SQL server as well when i change the password for this windows account or it get updated from Active directory itself?

    Additional Info

    Both Servers A and B running with SQL 2005 SP3

    SQL Services on both A and B running on Network service account

  • I just checked and i dont find proxy account option from drop down if i choose job type as T-SQL so not sure what is the other way? also can i utilize "execute as" while calling the server B proc?

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

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