Mail unsent.

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Riyaz Mansoor - 17 Jun 2008 12:39 GMT

SQL Server 2005 Express / Management Studio Express. I was adviced
that this might be a service broker problem.

sysmail_event_log says : Activation Failure
surface area configuration -> service broker -> "This instance does
not have a service broker endpoint."

How can i configure service broker to send database mail?
Is service broker / database mail available in the Express version?

Pls help

http://groups.google.com/group/microsoft.public.sqlserver.servicebroker/browse_t
hread/thread/7e1f92f6d0c801e9/e780279645e08f3e?lnk=gst&q=broker+endpoint#e780279
645e08f3e

Reply to this Message

Riyaz Mansoor - 20 Jun 2008 06:18 GMT

I'll answer myself :)

It seems service broker is not available for the Express version.

http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx

Reply to this Message

Roger Wolter[MSFT] - 28 Jun 2008 20:41 GMT

Close. Service Broker is available on SQL Server Express but Database Mail
isn't.

Signature

This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm

> I'll answer myself :)
>
> It seems service broker is not available for the Express version.
>
> http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx

Reply to this Message

Riyaz Mansoor - 10 Jul 2008 19:03 GMT

Then how come Express has Database Mail in its configuration? If what
you say is true, then this seems like deceptive practice from
Microsoft. There is absolutely no documentation available on this.

On Jun 29, 12:41 am, "Roger Wolter[MSFT]"
<rwol...@online.microsoft.com> wrote:

> Close. Service Broker is available on SQL Server Express but Database Mail
> isn't.
[quoted text clipped - 8 lines]
>
> >http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx

Reply to this Message