YOU ARE ADMINISTRATING A SQL SERVER CLUSTER THAT IS RUNNING THREE...

14. - 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
14. You are administrating a SQL Server cluster that is running three instances of Microsoft SQL Sever 2008. Each instance uses SQL Service Broker to send messages to other instances both on the cluster and on other machines in the Enterprise. After patching and rebooting the host machines you see that one of the instances is not getting its service broker messages. One of the instances is using TCP port 1433, and the other two are using dynamic port numbers. The server that is not receiving SQL Service broker messages is using a dynamic TCP port number. You examine the SQL Server ERRORLOG and find the following relevant messages: