Sending a message through SQL Server Service Broker from one machine to another.
Sender - Windows Server 2012 R2 with SQL Server 2012 NAT standard that has port forwarding for Service Broker from open IP: port to the local IP port of SQL Server. Say for example a port 26223, and it forwards SQL Server 4022.
The recipient is CentOS 7 with SQL Server 2017 RC2 Express as a web server with the same specific port open for Service Broker.
I sent a message from the sender to the receiver and, first of all, I received an error in sys.transmission_queuethe wrong alghoritm, then I found out that I have alghoritms of the encryption key different on the endpoints of the sender and the recipient, and the recipient endpoint key alghoritm was changed to match the sender.
After that, the sent message appeared in sys.transmission_queuewith another error - Service Broker/Database Mirroring network protocol error occurred.In SQL Profiler I found more detailed information:
Broker: corrupted message - received a corrupted message. The binary message preamble is invalid.
On the receiver side, SQL Profiler shows that:
Broker's audit Login: 4 - Negotiation error - An error occurred while receiving data: '996 (Event with overlapping I / O is not in alarm state.)'.
Broker Audit Login: 5 - Authentication Failure
:
Login: 4 - Negotiate Failure - : '24 ( , .) '.
, sys.transmission_queue .
UPDATE:
ssbdiagnose :
D 29835 MainServer MainDatabase Messages on conversation handle 13c07ab1-6b8d-e711-80c5-002590cb2a25 (conversation id 3a7d0dd0-c957-4fe8-a98e-1cb56713023c) from service sbSenderService to service sbReceiverService cannot be transmitted dues to the following problem: Service Broker/Database Mirroring network protocol error occurred.
An internal exception occurred: No such host is known
D 29933 WebServer WebDatabase The routing address TCP://[NAT ip address was here]:26223 for service sbSenderService does not match any of the IP addresses for MainServer
An internal exception occurred: Value cannot be null.
Parameter name: value
An internal exception occurred: No such host is known
P 29945 Cannot parse the routing address: unknown
, : TCP://[IP- NAT ]: 26223 sbSenderService IP- MainServer
, MainServer () IP- NAT, TCP , TCP , ? ?
UPDATE2: VPN , . CentOS Selinux. , Service Broker CentOS Windows.