How to enable the Transport protocol while communicating between two different servers

Whenever I start my SQL Express 2005 database, I get the following in the logs :

<SNIP>
2005-11-20 19:04:11.92 spid8s Starting up database 'tempdb'.
2005-11-20 19:04:11.99 spid5s Error: 8355, Severity: 16, State: 1.
2005-11-20 19:04:11.99 spid5s Service Broker is disabled in MSDB or MSDB failed to start. Server level event notifications can not be delivered. Event notifications with FAN_IN in other databases could be affected as well.
2005-11-20 19:04:11.99 spid11s The Service Broker protocol transport is disabled or not configured.
2005-11-20 19:04:11.99 spid5s Recovery is complete. This is an informational message only. No user action is required.
2005-11-20 19:04:11.99 spid11s The Database Mirroring protocol transport is disabled or not configured.
2005-11-20 19:04:12.04 spid11s Service Broker manager has started.
</SNIP>

I also get "Service Broker is disabled in MSDB or MSDB failed to start. Server level event notifications can not be delivered. Event notifications with FAN_IN in other databases could be affected as well." in the event logs.

This is on a Windows 2003 SP1 server, and was an upgrade to an existing MSDE 2000 database.

Does anyone have any ideas what causes this, and how to fix it?

If you don't care about Service Broker functionality or any other functionality dependent on it (Event Notifications, Query Notifications, SqlDependency, SQL database mail etc) then you can simply ignore the message.

If you need Service Broker functionality, you should enable back the broker in MSDB:

ALTER DATABASE [msdb] SET ENABLE_BROKER;

HTH,
~ Remus

|||Thanks for the quick reply! Everything seems to be working despite this message, meaning my application can connect to the database and query/update it, so I think I'll just ignore the message for now. If something starts acting up, I'll enable it to see if that helps.
|||If i want to exchange message between two different instances or databases in two different servers, then I have to enable the transport protocol which wil be disabled by default in service broker.I read in some article that some registry settings has to be changed.So can someone suggest on the same.|||When I try to execute this statement, the query just continues to run and run. If I use the GUI, it instantly hangs the task. Any thoughts as to why and how to fix would be great. Thx, Cin|||

You need to stop SQL Agent for this statement to complete.