- Repost - originally posted 14-05-2012
SQL Server 2012 Availability Groups Lessons Pt 1
We recently set up a production SQL Server 2012 system with AlwaysOn Availability Groups (AG) to provide High Availability (HA). During installation we encountered a number of issues. The purpose of this blog (and others to follow) is to give you some tips that may make your setup go seamlessly. Tip 1: Make sure the account under which you are creating the AG has permission to create an AD object.
Another option would be to create a SQL Server installation only account that would have full administrative privileges. When not required it could be locked and the password changed each time it needs to be used.