WHEN YOU ARE SETTING UP YOUR CLIENTS TO CONNECT TO A CLUSTERED SQL...

12. When you are setting up your clients to connect to a clustered SQL Server

database, to which hostname should they be connecting?

A. The hostname of the node that is actively running the SQL Service

B. The hostname of the node that is not actively running the SQL Service

C. The hostname that was used when setting up the Windows Cluster

D. The hostname that was used when installing SQL Server

The correct answer is D. You will want to have your clients connect to the

hostname that was used when installing SQL Server. Although you can

connect to the hostname that is running the SQL Service, there is no way

to know which host this is. Although you can connect via the hostname that

was set up when configuring the Windows cluster it will work only if both the

Windows Cluster and the SQL Instance are currently on the same node.

As they are in different resource groups it is entirely possible that they will

be on different nodes.