Error Data source name not found

Environment

Product	Progress® Telerik® Report Server
Operating System	Windows

Description

The message 'Data source name not found and no default driver specified' appears when Standalone Report Designer tries to open an ODBC connection, registered in Telerik Report Server, although the connection string is valid and ODBC DSN is registered as User DSN.

Solution

When a DSN is registered as User DSN, this means that only the currently logged-in user can access it. The Report Server pool uses LocalSystem built-in account by default, so it probably is unable to access the registered User DSN. The solution is to register the DSN as System DSN in ODBC Data Source Administrator, so it will be available to all users.