March 30, 2007 at 2:56 pm
I have a report in reporting services that prior to now passed a SQL login for authentication to run; however now we must monitor the processing of the report and capture Windows username information since the persons running the report cannot have a SQL login for our main application.
When I change it to Windows Auth, it displays this error:
Claiming it cannot open the data source as well. The Windows logins for these persons as been granted access to the report and to the ReportServer database and the database used by our main application.
The odd thing is we have another installation of Reporting Services were this works. We've examined IIS, the report XML, and other things for comparison to the installation that works. No joy. There seems to be no difference.
SQL Server is running in Mixed Auth mode. The connection strings in the data sources seem to be identical. It seems most likely that the credentials are not passing to SQL Server from IIS.
Does anyone have an inkling why this would happen?
Thanks
Charles
April 2, 2007 at 2:06 am
If the SQL Server data source is on a different server to the ReportServer then you would get this result, its a Kerberos double-hop thing.
You can still use SQL Authentication but in your Report refer to USERID which will contain the username of the person running the report, if the IIS set is set to requires Windows Auth and not to allow Anonymous connections.
Hope this helps
Neil.
April 2, 2007 at 8:05 am
Thanks Neil. Using your information we pointed the data source to one on the same server. It fixed the problem.
Charles
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply