July 6, 2006 at 10:39 am
I've installed SQL Server 2005 on 3 different servers and have finally installed it on my production server. I went to configure Database Mail and get the expected dialog "Database mail depends on Service Broker...Do you want to enable Service Broker on msdb"?
I select yes and then nothing happens. It just hangs. I've let it run for over an hour. I've tried the Surface Area Configuration tool and in the logs I see the following,
"Setting database option ENABLE_BROKER to ON for database msdb."
Still everytime I go to setup a profile I get the same, "do you want to enable Service Broker" message and then hang.
I've done this on all my other servers without problem.
Thanks.
July 10, 2006 at 8:00 am
This was removed by the editor as SPAM
August 24, 2006 at 3:06 pm
Enabling the broker requires exclusive rights to the database.
Put MSDB in single-user mode and then fire the command:
ALTER DATABASE [msdb] SET ENABLE_BROKER
September 14, 2007 at 1:04 am
This last solution must work, but stopping SQL Server Agent works too, at least for me.
Thank you for the idea.
June 30, 2011 at 3:15 pm
We ended up with a corupt msdb after a power outage. Restored the msdb backup, and noticed that emails were not going out after jobs completed. Went into database mail, got the "must enable service broker" message, and experienced the hangup described above. Simply stopping SQL Server Agent before going back into setup Mail fixed the problem.
Why wouldn't Service Broker be enabled in the backed up copy of msdb? All was working for months before, and a the backup was a few hours old.
Student of SQL and Golf, Master of Neither
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply