Error 'Data source name not found' when using ODBC connection with Telerik Report Server.

Environment

Product	Progress® Telerik® Reporting, Report Server
Report Designer	Standalone Report Designer
Report Item	SqlDataSource

Description

The error ppears 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.

Error Message

 'Data source name not found and no default driver specified.'

Possible Cause

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.

Solution

The solution is to register the DSN as System DSN in ODBC Data Source Administrator, so it will be available to all users.