|
|
|
Valued Member
      
Group: General Forum Members
Last Login: Yesterday @ 12:21 PM
Points: 73,
Visits: 336
|
|
Can SSB be enable between databases on different instances on same domain/network without the use of Certificates, Keys etc ?
|
|
|
|
|
SSCertifiable
       
Group: General Forum Members
Last Login: Saturday, May 18, 2013 10:09 PM
Points: 5,658,
Visits: 6,100
|
|
|
|
|
|
SSC-Addicted
      
Group: General Forum Members
Last Login: Saturday, May 11, 2013 12:25 PM
Points: 433,
Visits: 1,048
|
|
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
|
|
|
|
|
SSCertifiable
       
Group: General Forum Members
Last Login: Saturday, May 18, 2013 10:09 PM
Points: 5,658,
Visits: 6,100
|
|
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
|
|
|
|
|
Valued Member
      
Group: General Forum Members
Last Login: Yesterday @ 12:21 PM
Points: 73,
Visits: 336
|
|
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?
|
|
|
|
|
SSC-Addicted
      
Group: General Forum Members
Last Login: Saturday, May 11, 2013 12:25 PM
Points: 433,
Visits: 1,048
|
|
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
|
|
|
|
|
Valued Member
      
Group: General Forum Members
Last Login: Yesterday @ 12:21 PM
Points: 73,
Visits: 336
|
|
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 ?
|
|
|
|
|
Valued Member
      
Group: General Forum Members
Last Login: Yesterday @ 12:21 PM
Points: 73,
Visits: 336
|
|
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 ?
|
|
|
|
|
SSC-Addicted
      
Group: General Forum Members
Last Login: Wednesday, May 08, 2013 12:32 PM
Points: 400,
Visits: 330
|
|
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.
|
|
|
|
|
Forum Newbie
      
Group: General Forum Members
Last Login: Tuesday, March 12, 2013 3:20 AM
Points: 1,
Visits: 7
|
|
|
|
|