Pay particular attention to the first paragraph abut the ramiifications of changing the Server name in the ODBC DSN, (wish I had earlier today).

This means if you change the name you are referencing the SQL Server with, even though it resolves back to the same server, that ODBC definition will not work with their current GP password.