A while ago I documented how to connect
CCA3054N The ODBC DSN could not be registered
After checking and re-checking my Database configuration and deciding I had all the information correct I started searching and found the anwer
The error is caused by the Microsoft UAC (User Account Control) feature included in Windows Vista, 7, and 2008. In order to create a system DSN, local administrative privileges are required. Even if the logon user is a local administrator, the UAC feature causes the logon user to only include the standard user token. As a result, Configuration Assistant will not be able to detect the administrative authority and the process of trying to add the system DSN will fail.
I quit the Configuration Assistant, ran it again using “Run as Administrator” and magically it worked.