Link to home
Start Free TrialLog in
Avatar of Jeff Perry
Jeff PerryFlag for United States of America

asked on

Issue with DB_Owner of Secondary Replica in SQL 2012 Availability Group

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
Avatar of PadawanDBA
PadawanDBA

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Jeff Perry

ASKER

That worked for me.  Much appreciated.