Error using the Report Viewer

[AJDN03_(Guest)]

When accessing R&R reports using an ODBC connection through another application an error is generated:____DB access: [Microsoft][ODBC SQL Server Driver][SQL Server] Login failed for user ^[null]^. Reason: Not associated with a trusted SQL Server connection.____The users are not connected to the database using a trusted connection. Do they need to be in order to preview the reports? ____Please let me know when you have a chance. ____Thanks!

[kfleming]

What version of R&R are you using?____Kathleen__R&R Support

[AJDN03_(Guest)]

I am using R&R Report Writer SQL Edition version 10.0. Thanks.

[AJDN03_(Guest)]

Hi Kathleen. Any update regarding this issue?

[kfleming]

Within the report R&R does save the name of the data source and stored whether use trusted data source is enabled.__Are you changing the data source at runtime?____Kathleen__R&R Support

[AJDN03_(Guest)]

The datasource is not being changed at runtime. The report should be using the datasource it is saved with. Thanks.

[kfleming]

When the report was originally saved, did the saved data source use a trusted connection? If so R&R would save that flag in the report file.____Kathleen__R&R Support