When you restore a database, TRUSTWORTHY is automatically set to OFF. For Service Broker, if you don’t use encryption and do use cross-database message transmission, TRUSTWORTHY needs to be set to ON.
ALTER DATABASE MyDB SET TRUSTWORTHY ON
And in my ever so helpful tradition here is a script that will generate the script for all databases that have trustworthy turned off, are not system databases and not readonly.
select 'ALTER DATABASE ' + name + ' SET TRUSTWORTHY ON' from sys.databases where is_trustworthy_on = 0 and is_read_only = 0 and database_id &gt; 4