December 14, 2011 at 12:50 pm
Can SSB be enable between databases on different instances on same domain/network
without the use of Certificates, Keys etc ?
December 14, 2011 at 12:54 pm
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.
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[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
December 14, 2011 at 1:09 pm
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
December 14, 2011 at 1:49 pm
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.
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[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
December 14, 2011 at 1:56 pm
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?
December 14, 2011 at 2:10 pm
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
December 15, 2011 at 8:23 am
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 ?
December 15, 2011 at 10:25 am
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 ?
February 1, 2012 at 12:24 pm
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.
March 4, 2013 at 5:32 am
Thanks
Viewing 10 posts - 1 through 9 (of 9 total)
You must be logged in to reply to this topic. Login to reply