Experts,
In our production server we already configured mirroring with trusted domain service account and its working perfectly.
currently service account and SQL agent account is same.
My question now i want to change another trusted domain account to SQL agent, if change is there any impact for mirroring configuration.
Example:
Current Status :
Mirror service Account SQL Agent account
test\account1 test\account1
To change :
Mirror service Account SQL Agent account
test\account1 test\account2
Pls advice on this.