malraff
asked on
SSRS 2005: wont run over web portal
hi all
i have a an ssrs report that points to a sql 2005 datasource,
locally on server i have visual studio installed the report runs fine
when i try to run it over the \\sqlserver\reports address is fails with the error:
An error has occurred during report processing.
Cannot create a connection to data source 'AchItil01'.
For more information about this error navigate to the report server on the local server machine, or enable remote errors
any ideas?
mal
i have a an ssrs report that points to a sql 2005 datasource,
locally on server i have visual studio installed the report runs fine
when i try to run it over the \\sqlserver\reports address is fails with the error:
An error has occurred during report processing.
Cannot create a connection to data source 'AchItil01'.
For more information about this error navigate to the report server on the local server machine, or enable remote errors
any ideas?
mal
How do you "run it over the \\sqlserver\reports address " and with what NT credentials? Are you using exactly the same NT login as when you run it "locally on server i have visual studio installed the report runs fine"
ASKER
i am running with the same logon credentials in each scenario
i have the report setup to use windows integrated security
it works locally eg
\\localhost\reports when on the actual server works fine
i have the report setup to use windows integrated security
it works locally eg
\\localhost\reports when on the actual server works fine
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.