When using AlwaysOn Availability Groups does each SQL Instance need to use the same service credentials?
We are setting up a new SQL2014 deployment and will be using AlwaysOn. If I have 2 SQL servers (call them ServerA and ServerB) then can I use 2 active directory accounts called Domain\ServerA_SQLServerService and Domain\ServerB_SQLServerService (one on each server)?
Or do they need to use the same account so I should just create Domain\SQLServerService
The accounts would be in the same domain and can have access to both servers. Previously we've had the SQL Server Service account locked out which has obviously caused problems. What I'd like to do is have 2 accounts so that the likelihood of both being locked out is reduced.
Is there a requirement and/or what is Microsoft's best practice?