During the update of our HR.Net system to version 3.0 we also moved from SQL Server 2000 to SQL Server 2005. And this involved loads of changes in setup.
We had our production environment working fine from the day zero, but there were loads of problems with development system.
Finally we managed to resolve almost everything for development and there was a point that we though is is all working fine.. but the last error came up:
“The SQL Server 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.”
Tried to enable SQL Broker in SQL server, but not managed, so asked Vizual a question. In their reply they supplied sql script to run in sql-server: Enable Service Broker SQL
Change variable @DBNAME to name of your database and execute this script. That exercise did sort out my problem.