Service Broker and SQL 2005 Express

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Michael MacGregor - 22 Feb 2007 18:46 GMT

I was just checking the SQL 2005 Features Comparison and for Service Broker
on SQL 2005 Express Edition it has a footnote saying that it is for
Subscriber only. Does this mean that it is not possible to initiate a
Service Broker application from a machine runing 2005 Express?

Michael MacGregor
Database Architect

Reply to this Message

Roger Wolter[MSFT] - 22 Feb 2007 19:37 GMT

No, it means that a Service Broker remote dialog can't be established
between two SQL Server Express databases unless the message is routed
through a licensed copy of SQL Server. So for example you can create a
dialog from Express to Standard or Standard to Express or Express to
Standard to Express but not Express to Express.

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 was just checking the SQL 2005 Features Comparison and for Service Broker
>on SQL 2005 Express Edition it has a footnote saying that it is for
[quoted text clipped - 3 lines]
> Michael MacGregor
> Database Architect

Reply to this Message

Michael MacGregor - 22 Feb 2007 19:46 GMT

Ah! So I can initiate a conversation from Express to Enterprise, but if I
want the messages in that conversation to then go to another Express
installation, it has to be done via the Enterprise installation?

BTW I now have your book but haven't read much of it yet. I'm reviewing
Service Broker for our application and will need to test it soon but the
whole encryption/certificate part of 2005 really confuses me right now.

Anyway, thanks again for your prompt response.

MTM

Reply to this Message

Roger Wolter[MSFT] - 23 Feb 2007 00:49 GMT

Good luck! If reading the book doesn't clarify the security thing I've
failed badly. The thing to remember is there are two kinds of Service
Broker security - dialog security and transport security. They have some
similarities but they're two different things that are pretty much
orthogonal. If you haven't seen it, I have some more SSB thoughts here:
http://msdn2.microsoft.com/en-us/library/aa964144.aspx

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

> Ah! So I can initiate a conversation from Express to Enterprise, but if I
> want the messages in that conversation to then go to another Express
[quoted text clipped - 7 lines]
>
> MTM

Reply to this Message