May 10, 2010 at 10:21 pm
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
May 10, 2010 at 11:13 pm
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