Note:  This is an old article, citing an issue with legacy systems or providers. Some troubleshooting tips may still be applicable to newer versions.  However, this article has not been tested with newer releases after 2016.

Symptoms

You receive an error message similar to the following:

Requested registry access is not allowed

Cause

The account used by TX does not have permission to get a list of all System DSN entries on the machine. TX needs this permission when you create a ODBC data source.

Resolution

Grant permission to read the list of System DSN entries in the registry by following the steps below.

You need administrative rights to complete this guide.

1. Determine which account is used by TX.
2. From the Start menu, click Run, type "regedit", and then click OK to start Registry Editor.
3. In the HKEY_LOCAL_MACHINE window, browse to the HKLM\SOFTWARE\ODBC\ODBC.INI key. The ODBC.INI key contains a subkey for each ODBC system DSN that is registered on the machine.
4. Right-click the ODBC.INI key and from the context menu, click Permissions.
5. Add the user account that you identified in step 1 to the list of users who can access this key, and select the Read check box for this user.
6. Click Apply, and then close Registry Editor.

Disclaimer

As stated in any Microsoft knowledge base article involving changes to the registry, if you use Registry Editor incorrectly, you may cause serious problems that may require you to reinstall your operating system. We cannot guarantee that you can solve problems that result from using Registry Editor incorrectly. Use Registry Editor at your own risk.