sql server reporting services:
I am serving up reports using the web service using the render method. The reports have images on them. The following scenarios work ..Net application and Reporting Services are all on the same workstation. Images show up and everything works well. ..Net application on same workstation and I point to Reporting Services which is on Test environment server A. Images show up and everthing works well. This is not working ..Net application is on server B and Reporting Services is on the same server A. The report shows up but all images show up with the red x. What can be different between the code on my local workstation and the code on the server? I have copied all the neccessary files out there. Is there something on my workstation which has Visual Studio installed that is not on the server B which only has IIS installed? Or is there something else I could be missing in the migration to the server environment?
We have found that the report comes up just fine in the server environment but the image is using different credentials than the user that is logged in. If we run impersonate as user ABC, all reports come up fine under ABC, but the image prompts a login box. The image wants to load under the users that logged in and not the user we use to impersonate. Any thoughts on how to get around this?
Don't see what you're looking for? Try a search.
|