Skip to Content
avatar image
Former Member

Crystal Report & SQL Server Windows Authentication

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Dec 20, 2011 at 04:28 PM

    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.

    Add comment
    10|10000 characters needed characters exceeded

  • Dec 20, 2011 at 06:18 PM

    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]

    Add comment
    10|10000 characters needed characters exceeded