I'm trying to enable Service Broker on a SQL Server 2012 database that is part of an availability group and keep getting this error message:
The operation cannot be performed on database "dbname" because it is involved in a database mirroring session or an availability group. Some operations are not allowed on a database that is participating in a database mirroring session or in an availability group.
ALTER DATABASE statement failed. (Microsoft SQL Server, Error: 1468)
Even attempting to enable
Trustworthy on the database generates the same error. According to this article, it seems that Service Broker could be enabled on databases configured for AG. What could I be missing?
The listener has been configured, endpoints created with public permission, targets reference the listener name. The error occurs when I try to enable service broker or set
Trustworthy via management console or T-SQL.
I wanted to add that the database is a restore from a SQL Server 2005 version with a existing Service Broker implementation.