Wednesday, March 7, 2012

routing to diff instance of SQL Server on same server

Remus,

thank you for your reply on (microsoft.public.sqlserver.notificationsvcs).

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

solved my own problem:

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'

changed to :

CREATE ROUTE [rem_s3_route] AUTHORIZATION [dbo] WITH SERVICE_NAME = N'rem_s3' , ADDRESS = N'TCP://192.168.0.2:4023'

and I changed the endpoint on sqlexpress to listen on 4023

so ports between sql server instances need to diff on same server.

No comments:

Post a Comment