65 SERVER SERVER IS LISTENING ON [ 127

2008- - THE REAL MTCS SQL SERVER 2008 EXAM 70 432 PREP KIT P52 PPTX
THE REAL MTCS SQL SERVER 2008 EXAM 70 432 PREP KIT P52 PPTX

2008-11-05 23:14:23.65 Server Server is listening on [ 127.0.0.1

<ipv4> 49551].

You know that the SQL Service Broker Endpoint is configured on port 5200. How should you resolve this issue with the least impact to the users of the databases hosted by this instance?A. Move one or more instances to the other node, then restart this instance so that the endpoint can take the TCP port number it has been assigned.B. Change the port number of the ENDPOINT to a free TCP port number that is not configured for use by the other instances by using the ALTER ENDPOINT command, changing the state from stopped to started at the same time. Reconfigure the routes on the machines that send SQL Service Broker messages to this server to use the new TCP port number.C. Restart the problem instance hoping that it gets access to its port number.D. Use the Cluster Administrator to move the problem instance to its own node so that the service can gain access to the port number in question.