Can’t Enable Service Broker On MSDB !

After restoring MSDB database to a different server, you may experience a problem configuring Database Mail feature due to the fact that Service Broker is not enabled on MSDB database and you will not be able to enable it.

Resolution :

to resolve this issue you have to create a new broker by executing the script below :

ALTER DATABASE [MSDB] SET NEW_BROKER WITH ROLLBACK IMMEDIATE

Go

ALTER DATABASE [MSDB] SET NEW_BROKER

Go

ALTER DATABASE [MSDB] SET ENABLE_BROKER

Go