I am using WIndows Server 2012 R2 and SQL 2012. I have an always on Availability group setup and all seems to be fine. The thing bugging me though is that the owner of the databases on the primary replica are set to SA. The database owners on the secondary replica are my domain account. I am not able to change the owner on the secondary replica as it is read only. Can any one assist in how I can get the owner to be the sa account as well
ASKER CERTIFIED SOLUTION
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
That worked for me. Much appreciated.