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
SSRSMicrosoft SQL Server 2005
Last Comment
malraff
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
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.