Database Mail Not starting

  • 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.

  • This was removed by the editor as SPAM

  • 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

  • This last solution must work, but stopping SQL Server Agent works too, at least for me.

    Thank you for the idea.

  • 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