spaghettidba (4/18/2014)
If you want to control under which account the collection set runs, you can set up a proxy account.
Because your sql agent account is local system on the secondary, you will need a proxy account(http://technet.microsoft.com/en-us/library/ms175834.aspx)