May 29, 2015 at 8:42 am
Hello Experts,
I got this error while I was trying to configure DBMAIL Profile & Account.
Database Mail depends on Service Broker. Service Broker is not active in msdb. Do you want to activate Service Broker in msdb? If you do not activate Service Broker, Database Mail will queue e-mail messages, but will not be able to deliver the messages.
Is this mandatory to enable broker while Agent is ON?
Thnx..
Thanks.
May 29, 2015 at 8:54 am
HI Guys
I found something interesting. I was trying to setup broker in msdb as I got this error msg "Database Mail depends on Service Broker. Service Broker is not active in msdb. Do you want to activate Service Broker in msdb? If you do not activate Service Broker, Database Mail will queue e-mail messages, but will not be able to deliver the messages."
So I tried to enable broker using the below statement:=
ALTER DATABASE msdb SET ENABLE_BROKER
I got another set of error:
Msg 9776, Level 16, State 1, Line 1
Cannot enable the Service Broker in database "msdb" because the Service Broker GUID in the database () does not match the one in sys.databases ().
Msg 5069, Level 16, State 1, Line 1
ALTER DATABASE statement failed.
Finally I fixed the issue using the below script:
ALTER DATABASE msdb SET NEW_BROKER WITH ROLLBACK IMMEDIATE
Still I have the same question, why we need broker to be enabled in msdb??
Is this for message communication purposes??
Thanks.
May 29, 2015 at 8:59 am
Service broker is the messaging technology that db mail implements in order to send messages, as the error states without it db mail will only queue messages and not be able to send any
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply