Multipe Accounts with master/target relationship

• MichaelDep

  Ten Centuries

  Points: 1374

  More actions

  March 9, 2010 at 6:14 am

  #96969

  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

• MichaelDep

  Ten Centuries

  Points: 1374

  More actions

  March 9, 2010 at 6:40 am

  #1130603

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

  Thank you,

  Dep