Home Forums Programming Service Broker Service Broker between database on different instance but same domain. RE: Service Broker between database on different instance but same domain.

  • 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[/url] | Forum Netiquette
    For index/tuning help, follow these directions.[/url] |Tally Tables[/url]

    Twitter: @AnyWayDBA