YOU HAVE TWO INSTANCES ON A SERVER THAT NEED TO BE ABLE TO SEND ME...

18. You have two instances on a server that need to be able to send messages

between the instances. Your corporate IT policies say that SQL Service Broker

Endpoints must be created on TCP port 5600. You create and bring online the

first Endpoint, but you cannot get the second Endpoint to come online. What

should you do to correct the issue?

A. Add a second IP to the server. Configure the first instance to use the first

IP for the Endpoint, and the second instance to use the new IP for the

Endpoint. Start the Endpoint on the second instance.

B. Change the port number of the second instance to a different port number

using the ALTER QUEUE command and bring the Endpoint online.

C. Restart the SQL Server instance that has the Endpoint that will not

come online.

D. Use the ALTER ENDPOINT command with the FORCE_ONLINE

switch to force the Endpoint to come online.

The correct answer is A. Because your IT policy states that the Service Broker

Endpoint must be created on TCP port 5600, a second IP address must be

added to the server so that each Endpoint can have its own IP to listen on.

Restarting the instance will not help bring the Endpoint online as the port

number is locked by the other instance. There is no FORCE_ONLINE switch

for the ALTER ENDPOINT command.