• Hi.

    Here is the command I executed for ssbdiagnose

    # ------------- Configuration --------------------

    $TargetServer = "MyServ"

    $TargetDbName = "TestServiceBroker"

    $SSBSourceServiceName = "SampleServiceSource"

    $SSBTargetServiceName = "SampleServiceTarget"

    $SSBContract = "SampleContract"

    $SSBDiagnoseLogDest = ".\ssbdiagnose.log"

    # ------------- End of Configuration -------------

    $TargetHostAddressObj = [System.Net.Dns]::GetHostAddresses("$TargetServer")

    if($TargetHostAddressObj -eq $null -or $TargetHostAddressObj.Count -lt 1) {

    throw "Target Server with name [$TargetServer] not found on network"

    }

    $TargetHostIP = $TargetHostAddressObj[0].IPAddressToString

    #ssbdiagnose.exe -u username -p password -s "$TargetHostIP" -d "$TargetDbName" CONFIGURATION FROM SERVICE "$SSBSourceServiceName" TO SERVICE "$SSBTargetServiceName" ON CONTRACT "$SSBContract"

    # Report on configuration issues

    ssbdiagnose.exe -s "$TargetHostIP" -d "$TargetDbName" CONFIGURATION FROM SERVICE "$SSBSourceServiceName" TO SERVICE "$SSBTargetServiceName" ON CONTRACT "$SSBContract" > "$SSBDiagnoseLogDest"

    and here is its output

    Microsoft SQL Server 11.0.2100.60

    Service Broker Diagnostic Utility

    D 29912 192.168.96.90 TestServiceBroker Service SampleServiceTarget was not found

    D 29973 192.168.96.90 TestServiceBroker No valid certificate with a private key was found for user dbo

    D 29977 192.168.96.90 TestServiceBroker The user dbo from database TestServiceBroker on 192.168.96.90 cannot be mapped into this database using certificates

    D 29971 192.168.96.90 TestServiceBroker Dialog security requires a remote service binding for service SampleServiceTarget

    D 29933 192.168.96.90 TestServiceBroker The routing address TCP://192.168.98.93:4022 for service SampleServiceTarget does not match any of the IP addresses for 192.168.96.90

    5 Errors, 0 Warnings