Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Service Broker between database on different instance but same domain.


Service Broker between database on different instance but same domain.

Author
Message
WangcChiKaBastar
WangcChiKaBastar
SSC-Enthusiastic
SSC-Enthusiastic (105 reputation)SSC-Enthusiastic (105 reputation)SSC-Enthusiastic (105 reputation)SSC-Enthusiastic (105 reputation)SSC-Enthusiastic (105 reputation)SSC-Enthusiastic (105 reputation)SSC-Enthusiastic (105 reputation)SSC-Enthusiastic (105 reputation)

Group: General Forum Members
Points: 105 Visits: 485
Can SSB be enable between databases on different instances on same domain/network
without the use of Certificates, Keys etc ?
Evil Kraig F
Evil Kraig F
SSCertifiable
SSCertifiable (5.7K reputation)SSCertifiable (5.7K reputation)SSCertifiable (5.7K reputation)SSCertifiable (5.7K reputation)SSCertifiable (5.7K reputation)SSCertifiable (5.7K reputation)SSCertifiable (5.7K reputation)SSCertifiable (5.7K reputation)

Group: General Forum Members
Points: 5697 Visits: 7660
Not really. Two instances are two servers, and between two servers you need to generate endpoints and routes. This is most often done via certificates.


- Craig Farrell

Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

For better assistance in answering your questions | Forum Netiquette
For index/tuning help, follow these directions. |Tally Tables

Twitter: @AnyWayDBA
Eddie Wuerch
Eddie Wuerch
Mr or Mrs. 500
Mr or Mrs. 500 (508 reputation)Mr or Mrs. 500 (508 reputation)Mr or Mrs. 500 (508 reputation)Mr or Mrs. 500 (508 reputation)Mr or Mrs. 500 (508 reputation)Mr or Mrs. 500 (508 reputation)Mr or Mrs. 500 (508 reputation)Mr or Mrs. 500 (508 reputation)

Group: General Forum Members
Points: 508 Visits: 1932
if the two instances are on the same domain, then just set up the endpoints with Windows Authentication:


CREATE ENDPOINT BrokerEndpoint
STATE = STARTED
AS TCP(LISTENER_PORT = <port_number_goes_here>, LISTENER_IP = (<ip_address_goes_here>Wink)
FOR SERVICE_BROKER(AUTHENTICATION = WINDOWS)



that lets you dodge all the certificate/login stuff

-Eddie

Eddie Wuerch
MCM: SQL
Evil Kraig F
Evil Kraig F
SSCertifiable
SSCertifiable (5.7K reputation)SSCertifiable (5.7K reputation)SSCertifiable (5.7K reputation)SSCertifiable (5.7K reputation)SSCertifiable (5.7K reputation)SSCertifiable (5.7K reputation)SSCertifiable (5.7K reputation)SSCertifiable (5.7K reputation)

Group: General Forum Members
Points: 5697 Visits: 7660
Eddie Wuerch (12/14/2011)
if the two instances are on the same domain, then just set up the endpoints with Windows Authentication:


CREATE ENDPOINT BrokerEndpoint
STATE = STARTED
AS TCP(LISTENER_PORT = <port_number_goes_here>, LISTENER_IP = (<ip_address_goes_here>Wink)
FOR SERVICE_BROKER(AUTHENTICATION = WINDOWS)



that lets you dodge all the certificate/login stuff

-Eddie


From what I had researched on it, the queue security if your servers don't all run under the same login can be a real PITA for windows security over endpoints.


- Craig Farrell

Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

For better assistance in answering your questions | Forum Netiquette
For index/tuning help, follow these directions. |Tally Tables

Twitter: @AnyWayDBA
WangcChiKaBastar
WangcChiKaBastar
SSC-Enthusiastic
SSC-Enthusiastic (105 reputation)SSC-Enthusiastic (105 reputation)SSC-Enthusiastic (105 reputation)SSC-Enthusiastic (105 reputation)SSC-Enthusiastic (105 reputation)SSC-Enthusiastic (105 reputation)SSC-Enthusiastic (105 reputation)SSC-Enthusiastic (105 reputation)

Group: General Forum Members
Points: 105 Visits: 485
ServerA and ServerB are on same domain/Network.
ServerA is the Initiator and ServerB is the Target.
Endpoint should be set on both A and B or only Target?
Eddie Wuerch
Eddie Wuerch
Mr or Mrs. 500
Mr or Mrs. 500 (508 reputation)Mr or Mrs. 500 (508 reputation)Mr or Mrs. 500 (508 reputation)Mr or Mrs. 500 (508 reputation)Mr or Mrs. 500 (508 reputation)Mr or Mrs. 500 (508 reputation)Mr or Mrs. 500 (508 reputation)Mr or Mrs. 500 (508 reputation)

Group: General Forum Members
Points: 508 Visits: 1932
You'll need endpoints on both, because Broker conversations are two-way (send-ack). You also need the following routes:

1. On Initiator database: Route to target Service and instance IP, with Broker_GUID of target database
2. On Target instance MSDB database: Route to target Service and database (ADDRESS = 'LOCAL')
3. On Target instance database: Route to sending Service and instance IP, with BROKER_GUID of sending database (for acknowledgement of received message and Conversation activity)
4. On Initiator instance MSDB database: route to sending Service and Broker_GUID of sending database (ADDRESS = 'LOCAL')

Eddie Wuerch
MCM: SQL
WangcChiKaBastar
WangcChiKaBastar
SSC-Enthusiastic
SSC-Enthusiastic (105 reputation)SSC-Enthusiastic (105 reputation)SSC-Enthusiastic (105 reputation)SSC-Enthusiastic (105 reputation)SSC-Enthusiastic (105 reputation)SSC-Enthusiastic (105 reputation)SSC-Enthusiastic (105 reputation)SSC-Enthusiastic (105 reputation)

Group: General Forum Members
Points: 105 Visits: 485
Thanks, I am troubleshooting an existing service broker in our DEV env.
How do I find out what certificate was attached. I cant find it in the Object Explorer.
Is there a system table that stores this information ?
WangcChiKaBastar
WangcChiKaBastar
SSC-Enthusiastic
SSC-Enthusiastic (105 reputation)SSC-Enthusiastic (105 reputation)SSC-Enthusiastic (105 reputation)SSC-Enthusiastic (105 reputation)SSC-Enthusiastic (105 reputation)SSC-Enthusiastic (105 reputation)SSC-Enthusiastic (105 reputation)SSC-Enthusiastic (105 reputation)

Group: General Forum Members
Points: 105 Visits: 485
I found the table its sys.certificates.

When I send a message to the target queue, messages appears on sys,transmission_queue table with error message 'DNS lookup failed with error: '11001(No such host is known.)'. '

any thoughts ?
anand_vanam
anand_vanam
SSC-Addicted
SSC-Addicted (400 reputation)SSC-Addicted (400 reputation)SSC-Addicted (400 reputation)SSC-Addicted (400 reputation)SSC-Addicted (400 reputation)SSC-Addicted (400 reputation)SSC-Addicted (400 reputation)SSC-Addicted (400 reputation)

Group: General Forum Members
Points: 400 Visits: 343
WangcChiKaBastar (12/15/2011)
I found the table its sys.certificates.

When I send a message to the target queue, messages appears on sys,transmission_queue table with error message 'DNS lookup failed with error: '11001(No such host is known.)'. '

any thoughts ?


The host name you have mentioned, while creating the Route may be incorrect. Please check that.
praddy.malik
praddy.malik
Forum Newbie
Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)

Group: General Forum Members
Points: 1 Visits: 7
Thanks
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search