(Updated)

I got an error on the second statement:

ALTER

DATABASE MyDatabase SET ENABLE_BROKER

GO

The database does have Trustworthy set to True. This database was upgraded by restore process from 2000 database. 2 databases that were created in 2005 don't have this problem.

When I try to run the above statement on the database that was restored /upgraded from 2000, I am getting a message:

Msg 15581, Level 16, State 3, Line 1

Please create a master key in the database or open the master key in the session before performing this operation.

Msg 28053, Level 16, State 2, Line 1

Service Broker could not upgrade conversation session keys in database 'DBA' to encrypted format (Error: 15581). The Service Broker in this database was disabled. A master key is required to the database in order to enable the broker.

Msg 5069, Level 16, State 1, Line 1

ALTER DATABASE statement failed.