microsoft.public.sqlserver.notificationsvcs
[Top] [All Lists]

Re: Service Broker and SQL Server Express

Subject: Re: Service Broker and SQL Server Express
From:
Date: 3 Aug 2006 23:12:01 -0700
Newsgroups: microsoft.public.sqlserver.notificationsvcs
Remus,

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)


<Prev in Thread] Current Thread [Next in Thread>