We help IT Professionals succeed at work.

Issue with DB_Owner of Secondary Replica in SQL 2012 Availability Group

778 Views
Last Modified: 2016-01-07
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
Comment
Watch Question

Operational DBA
Commented:
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION
Jeff PerryDirector of IT

Author

Commented:
That worked for me.  Much appreciated.
Unlock the solution to this question.
Join our community and discover your potential

Experts Exchange is the only place where you can interact directly with leading experts in the technology field. Become a member today and access the collective knowledge of thousands of technology experts.

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.