Re: Service Broker and SQL Server Express
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