What Host Name is my application connecting to SQL Server on We have this 1 node broken cluster that I have been given the joy of fixing. Wont go into the reasons why its only got one node but I am planning on migrating this off onto a newly built cluster.

So the broken cluster is running on a single node "NODE1" on IP "10.1.1.10".

The old SQL Cluster Name has been added as a static entry into DNS "SQLClusterName" and its pointing to NODE1's IP address 10.1.1.10.

For the Migration I am going to use the old cluster name "SQLClusterName" so that we don't need to change a bunch of applications connection details.

The issue I have is that there is an application that uses a database on this server and we are unable to change the app at all. I am trying to make sure that said app is connecting on "SQLClusterName" and not "NODE1".

Is there a way without checking the actual application to see what Host Name the application is connecting through to SQL Server on? For the life of me I cant seem to find this information anywhere.

Thanks.
Assuming you can install the app on a Windows 7 (or higher) workstation you can perform the following steps to determine exactly what server and IP address the app is using:


Start a cmd.exe prompt "As Administrator"
Run "ipconfig /flushdns"
Run the app, and ensure it connects to the server
From the cmd.exe prompt, run "ipconfig /displaydns" 


The output from step 4 will show all host names, along with the IP address(es) for those hosts that have been resolved in step 3.  Try to ensure nothing else is running between step 2 and step 4 to narrow down the results displayed in step 4.