The SQL Server Service Broker for the current database is not enabled, and as a result query notifications are not supported. Please enable the Service Broker for this database if you wish to use notifications.

Problem:

Loading the web application and received the following error:

The SQL Server Service Broker for the current database is not enabled, and as a result query notifications are not supported.  Please enable the Service Broker for this database if you wish to use notifications.

The database is installed and running but having issues bringing up the website.


Solution:

Option 1

ALTER DATABASE [DBNAME] SET ENABLE_BROKER WITH ROLLBACK IMMEDIATE

Option 2

Source:
http://stackoverflow.com/questions/2758976/enabling-service-broker-in-sql-server-2008