"CCA3054N The ODBC DSN could not be registered" when adding a database from Configuration Assistant on Windows Vista, 7, or 2008
When trying to add a database using the Configuration Assistant on Windows Vista, 7, or 2008, the CCA3054N error will occur if the option to create a system DSN was selected during the add database wizard.
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.
Resolving The Problem
To resolve the problem, the Configuration Assistant must be explicitly launched with administrative privileges. To do this, right-click on the Configuration Assistant icon in the start menu and select the option to "Run as Administrator". Once the Configuration Assistant is launched, retry the previous steps that caused the CCA3054N error and it should complete successfully and create a system DSN on the machine.
16 June 2018