Multipe Accounts with master/target relationship

  • I am running a mixture of SQL 2000, SQL 2005, and SQL 2008. My security team has come to me and told me they do not like how the SQL service accounts are setup. O.K., I'll change it. Here's my problem. They are wanting unique accounts on each server to run the SQL server Agent service. When I set this up I am not able to connect to my master server for job scheduling. Is there a way to allow each target server to run the SQL Server Agent service under a different windows account and still connect to a master agent service?

    Thanks,

    Dep

  • Never mind. I had never seen the TargetServersRole in MSDB security, that seems to have resolved my issue.

    Thank you,

    Dep

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

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