ASP.NET Report Viewer Authentication

[Baptiste]

Hello,

I am currently evaluating the use of Reporting in a project and I got a test page up and running in ASP.NET 4.5.

However, I noticed that my report (which uses a SQL Server Data Source) is executing the query using the application pool identity. Is there any way to run the query using the current user's identity?


Thanks in advance

[Stef]

Hello,

Please check how your connection string (Integrated Security) is declared. In addition you need the settings described in the following MSDN article: How to: Access SQL Server Using Windows Integrated Security.

I hope this information helps you.

Regards,
Stef
Telerik