ERROR
Msg 1468, Level 16, State 1, Line 1
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.
Msg 5069, Level 16, State 1, Line 1
ALTER DATABASE statement failed.
Below are the steps I did to resolve the error.
Remove DBName from AAG
Enable Service Broker
ALTER DATABASE DBName SET ENABLE_BROKER;
Verify Service Broker Enabled
SELECT is_broker_enabled FROM sys.databases WHERE name = 'DBName';
Add DBName to AAG
