March 6, 2006 at 3:16 pm
SSRS 2005
No matter how many times I redeploy my report and data sources from my project to Report Manager, I keep getting this error when trying to run the report from Reprt manager. It runs fine in VS 2005 though. I don't know what else to do. I see no way to delete the report from Report Manager in attempts to try to redeploy it from scratch either.
"An error has occurred during report processing.
Cannot create a connection to data source 'myservername'.
For more information about this error navigate to the report server on the local server machine, or enable remote errors "
March 6, 2006 at 4:04 pm
I'm making a few assumptions here but i assume you are using integrated authentication and the data source you are trying to connect to is remote from from the server reportingservices is running on.
If this is the case you are probably running in a 2003 domain that is using mixed authentication i.e. it's not running in native server 2003 mode which means that security delegation will not work.
If my assumptions are correct change you're data source so that it connects using a windows password stored in the reportingservices database and tell it use the credentials as windows credentiasbt do not check the impersonation box and see if it works.
hth
David
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply