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