Hi folks,
i have an MS SQL Server 2008r2 with Reporting Services, i use a SYSTEM-DSN with the "ISeries Access ODBC Driver" as Datasource.
Windows Users and AS400 Users have the same UserID and the Password.
I want to use this System DSN as published Data Source on the Page http://MyServer/Reports from the MS Reporting Services. If i use fixed credentials in the datasource i receive the data from the db2.
But is it possible to configure a windows pass-through authentication form the client PC / Terminal Server to Datasource on the Reporting Services Server?
Thanks in advance and greetings from Austria
Jürgen
i have an MS SQL Server 2008r2 with Reporting Services, i use a SYSTEM-DSN with the "ISeries Access ODBC Driver" as Datasource.
Windows Users and AS400 Users have the same UserID and the Password.
I want to use this System DSN as published Data Source on the Page http://MyServer/Reports from the MS Reporting Services. If i use fixed credentials in the datasource i receive the data from the db2.
But is it possible to configure a windows pass-through authentication form the client PC / Terminal Server to Datasource on the Reporting Services Server?
Thanks in advance and greetings from Austria
Jürgen