Crystal Report & SQL Server Windows Authentication

[Former Member]

HI All!

I am having trouble using Windows Authentication with Crystal report.

I have web Application that will display the report on the browser at runtime

It works fine when I used Sql server authentication, but we need to support windows authentication as well.

And when i am trying to do Windows Authentication, it is prompting me again and again for DB creadintials.

If I give the windows Domain user credintials it works, I don't really understand why it is not working without userid and pass.

But the same is working if am using it on windows desktop application.

I would like to know is it possible to work with crystal reports using windows authentication on web application?

I am using VS 2010 & CR run time 13.0

[Adam_Stone · Accepted solution]

It is possible. If the SQL Server is on a different machine than your IIS server, you will need to look at setting up Kerberos. You also need to make sure that impersonation is setup and working correctly and that anonymous access is denied to your application so that it forces users to be authenticated.

[former_member183750]

Also, see the article [Using Integrated and SQL Authentication in .NET Applications|https://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/b021e47e-be1d-2b10-c6b2-efa9db3abd6b].

And, don't forget to use the search box inthe top right corner of this web page. It will search Kbases, blogs, wikis, forum threads, etc., etc.

Ludek

Follow us on Twitter http://twitter.com/SAPCRNetSup

Got Enhancement ideas? Try the [SAP Idea Place|https://ideas.sap.com/community/products_and_solutions/crystalreports]