Hi, thanks for this article.
While running the code you provided, there is a little syntax error at
CREATE ENDPOINT ServiceBrokerEndpoint AUTHORIZATION $(LoginName)
STATE= STARTED AS TCP
( LISTENER_PORT=4022, LISTENER_IP= ALL ) FOR SERVICE_BROKER
( AUTHENTICATION = WINDOWS, ENCRYPTION= REQUIRED, ALGORITHM= RC4 )
This should be
CREATE ENDPOINT ServiceBrokerEndpoint AUTHORIZATION $(LoginName)
STATE= STARTED AS TCP
( LISTENER_PORT=4022, LISTENER_IP= ALL ) FOR SERVICE_BROKER
( AUTHENTICATION = WINDOWS, ENCRYPTION= REQUIRED ALGORITHM RC4 )
Cheers