Re: Service Broker and SQL Server Express
You need to configure the broker endpoint (CREATE/ALTER ENDPOINT ) on the
SQLExpress to use a different port. Your Express ERRORLOG (and also the
system event log) should contain an entry about the fact that it could not
actually start listenning on the port 4022 because it's in use by another
and then you configure the route to use the new port:
CREATE ROUTE [rem_s3_route] AUTHORIZATION [dbo] WITH SERVICE_NAME
= N'rem_s3' , ADDRESS = N'TCP://192.168.0.2:<someotherportforsqlexpress>'
As about the servicebroker newsgroup is not the first time I hear that is no
longer showing. You can also try the forum, at
is running fine.
This posting is provided "AS IS" with no warranties, and confers no rights.
~ Remus Rusanu
SQL Service Broker
<[email protected]> wrote in message
> thank you for your reply.
> one more question :
> Server_2 == Server_3
> so I set up a route for db2:
> CREATE ROUTE [rem_s2_route] AUTHORIZATION [dbo] WITH SERVICE_NAME
> = N'rem_s2' , ADDRESS = N'TCP://192.168.0.2:4022'
> to create route for db3 (sql express) I tried
> CREATE ROUTE [rem_s3_route] AUTHORIZATION [dbo] WITH SERVICE_NAME
> = N'rem_s3' , ADDRESS = N'TCP://192.168.0.2\sqlexpress:4022'
> this failed, what am I doing wrong or did I lost the plot? How do I
> diff beteen more than one instance of sql server on the same server?
> And can the port be the same on each instance of SQL Server?
> thank you in advance
> p.s. I did look for microsoft.public.sqlserver.servicebroker but can
> not find it?? (never mind google do not allow posting to this group at
> this moment)