This problem frequently occurs when you just restored a database, but service brokers are broken or lost.
To resolve this problem.
alter database xxxx set NEW_BROKER
Alternatively,
1. Go to Programs -> Microsoft Sql Server 2005 -> Configuration Tools -> Sql Server Surface Area Configuration -> Surface Area Configuration for Features.
2. Locate "Service Broker" under the database engine and enable it.
Showing posts with label Service Broker. Show all posts
Showing posts with label Service Broker. Show all posts
Subscribe to:
Posts (Atom)
Posts
