Page 1 of 1

Error using the Report Viewer

Posted: Wed Sep 03, 2003 10:56 am
by 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!

=> RE: Error using the Report Viewer

Posted: Thu Sep 04, 2003 7:25 am
by kfleming
What version of R&R are you using?____Kathleen__R&R Support

==> RE: Error using the Report Viewer

Posted: Thu Sep 04, 2003 9:23 am
by AJDN03_(Guest)
I am using R&R Report Writer SQL Edition version 10.0. Thanks.

===> RE: Error using the Report Viewer

Posted: Tue Sep 09, 2003 3:37 pm
by AJDN03_(Guest)
Hi Kathleen. Any update regarding this issue?

====> RE: Error using the Report Viewer

Posted: Wed Sep 10, 2003 7:20 am
by 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

=====> RE: Error using the Report Viewer

Posted: Wed Sep 10, 2003 9:25 am
by AJDN03_(Guest)
The datasource is not being changed at runtime. The report should be using the datasource it is saved with. Thanks.

====> RE: Error using the Report Viewer

Posted: Wed Sep 10, 2003 2:54 pm
by 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