I understand this is a quite old thread, but I have combated exactly the same situation before, and in my case the network configuration was the culprit. For some reason, the initiator has sent its messages from one IP address, but another IP has been opened to accept incoming replies (and this second IP has … Read more
keep a note of these options ALTER DATABASE mydb SET ENABLE_BROKER ALTER DATABASE mydb SET DISABLE_BROKER ALTER DATABASE mydb SET NEW_BROKER if youre getting something like this is already an enabled Service Broker with the same ID, go for the NEW_BROKER
You can use a transformation broker without a service bus, and vice versa. In terms of specific products I don’t think any one is purely one or the other because of the way each complements the other. Some products are stronger in the one area, other stronger in another. Perhaps a choice needs to be … Read more
How long should I expect ALTER DATABASE … SET ENABLE_BROKER to run? alter database [<dbname>] set enable_broker with rollback immediate;