CODEWITHSUNDEEP
sqlsql-server-2008service-broker
Bassam Gamal
Bassam Gamal

Reputation: 701

Routes Address Issue in Broker Service

While I was configuring Broker Service on the Customer site. I faced a confusing problem with the Route Address. The customer has a SQL Default instance and a named instance as below: ADDRESS = N'TCP://SQLInst/SQLNamed1:4882'

I tried to Command Shell the DB to get the IP so work around the issue, but could only get the Default Instance IP I used below link.

So what is the solution to this issue

Upvotes: 0

Views: 295

Answers (2)

mrdenny
mrdenny

Reputation: 5078

The syntax that you should be using is:

N'TCP://SQLInst:4882'

You are sending it to a server name and a specific TCP port which is being listened to by the SQL Server instance so that instance name isn't used in the connection.

Upvotes: 1

Diego
Diego

Reputation: 36166

If you are having issues accessing a SQL Server instance by name, you need to enable SQLServer browser enable on the client

Upvotes: 0

Related Questions