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