• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 424
  • Last Modified:

Windows auth for Crystal reports

Hello All,
How can I connect crystal reports to the database through windows authentication.Is there a way other than creating an ODBC connection.
Thanks all.
  • 2
1 Solution
You can use the ado connection with an integrated user account.  This of course relies upon that user having db access under their windows account as well.

In Crystal, it is the one labeled "OLE DB (ADO)"
Star79Author Commented:
Iam able to login to the DB via the management studio via the windows auth,but when I do the same using crystal "OLE DB (ADO)"  its doesnt allow me.
When you configure the connection use:
OLE db for SQL server
For Connection Information, tick the "integrated security" box and then enter your sql server and database name

Don't type in a user name and password though.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now