Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Service Broker between database on different instance but same domain. Expand / Collapse
Author
Message
Posted Wednesday, December 14, 2011 12:50 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, June 2, 2014 11:14 AM
Points: 103, Visits: 450
Can SSB be enable between databases on different instances on same domain/network
without the use of Certificates, Keys etc ?

Post #1221974
Posted Wednesday, December 14, 2011 12:54 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 1:46 PM
Points: 5,384, Visits: 7,458
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
Post #1221981
Posted Wednesday, December 14, 2011 1:09 PM


SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Yesterday @ 2:32 PM
Points: 441, Visits: 1,134
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>))
FOR SERVICE_BROKER(AUTHENTICATION = WINDOWS)

that lets you dodge all the certificate/login stuff

-Eddie


Eddie Wuerch
MCM: SQL
Post #1221991
Posted Wednesday, December 14, 2011 1:49 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 1:46 PM
Points: 5,384, Visits: 7,458
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>))
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
Post #1222024
Posted Wednesday, December 14, 2011 1:56 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, June 2, 2014 11:14 AM
Points: 103, Visits: 450
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?
Post #1222030
Posted Wednesday, December 14, 2011 2:10 PM


SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Yesterday @ 2:32 PM
Points: 441, Visits: 1,134
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
Post #1222038
Posted Thursday, December 15, 2011 8:23 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, June 2, 2014 11:14 AM
Points: 103, Visits: 450
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 ?
Post #1222484
Posted Thursday, December 15, 2011 10:25 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, June 2, 2014 11:14 AM
Points: 103, Visits: 450
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 ?
Post #1222618
Posted Wednesday, February 1, 2012 12:24 PM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Thursday, October 3, 2013 5:13 PM
Points: 400, Visits: 339
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.
Post #1245268
Posted Monday, March 4, 2013 5:32 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, March 12, 2013 3:20 AM
Points: 1, Visits: 7
Thanks
Post #1426195
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse