October 11, 2005 at 1:36 pm
I have a sql reporting services report that is built to get data out of a cube.
I have built the report and the data source on my SQL reporting services box (The analysis server I am hitting is on another box). When I am actually on the reporting services box, my "Use Windows Integrated Security" works fine when I access the report in a browser (I am logged on to the machine as myself).
When I go to any other machine and log on with my credentials, I get an error indicating that the analysis server database that my data source is trying to access does not exist. This leads me to believe I am not being authenticated.
I have confirmed I have access to the cube. Does anyone have any idea why my credentials work on the IIS box that hosts reporting services, but will not work when I log onto another machine?
Any help would be greatly appreciated.
aroney
October 11, 2005 at 5:44 pm
If youre server OS is windows 2000 (and you're not using Kerberos), it's quite possibly the 'double-hop' issue, where the IIS can't (isn't allowed) to pass your credentials on to a server further down the line/chain. If you are on Win2k, possible options are to set a single UID/PWD for the report execution (not so nice); put the AS on the same server, ?.
If you've got win2k3, you can set it up so that it passes the credentials to the next server (I think this is done in IIS).
Steve.
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply