Error Accessing Reporting Services Reports from GP 2010

(0) Share

Report

Posted on by kuroneko1313

2,119

Hello,

We have deployed the SQL Reporting Services reports to GP 2010. The GP database and Report server database reside on different SQL 2005 database.

We can successfully run the reports from the Report Manager. However we see that if we try to run the reports from GP (from Home, Administratation, Reports List), we get an error "Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'

We're thinking if this is an Impersonation issue. However we check in the web.config that the Impersonation is set to true:

<identity impersonate="true" />

We also set the authentication for Data Source in the Report Manager as follow:

We are connecting to a custom data source SQL server with a connection string instead of using the default shared data source from the deployed reports.

Could anyone please help us with this problem? Thanks in advanced for your help, greatly appreciate it!

*This post is locked for comments

All responses (1)

Answers (0)

kuroneko1313 2,119 on at

Like (0)

Report

Re: Error Accessing Reporting Services Reports from GP 2010

Just tried connecting to a Report Server that is located on the same database as the GP 2010 database. Running the SRS reports from GP 2010 is fine here... could it be that there is a problem when the Report Server is remote, separate from the GP database?

We would like to deploy the SRS in a different, already existing Report Server database in the system.

Greatly appreciate your help in this!

-Elizabeth K.