If you are just moving the database to a new server, you will need to make sure network service account has permission to access the new database. And then enable the service broker on the new database by running the following script.
alter database dotshoppingcart SET ENABLE_BROKER
ALTER AUTHORIZATION ON DATABASE::[dotshoppingcart] TO [sa];
DotShoppingCart Staff
|