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, http://msdn.microsoft.com/en-us/library/hh710058.aspx, it seems that Service Broker could be enabled on databases configured for AG. What could I be missing?
Thanks so much for your help.