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

Why do I get prompted for username and password every time I run a Crystal Report

I created a Crystal report connecting to a SQL DB using Microsft OLEDB provider.  Everytime I run the report I get prompted for username and password.  How can I get rid of this?
0
shamel9873
Asked:
shamel9873
  • 3
  • 2
1 Solution
 
mlmccCommented:
Crystal doesn't store the userid or password in the report file.

You could try using integrated authentication so your Windows login also logs you into the database
You could run the report through an application that passes the login information to the report and then the database.

Is this when you are trying to edit/design the report?
If so the first idea should work.

mlmcc
0
 
shamel9873Author Commented:
Its when viewing the report--multiple users
0
 
mlmccCommented:
How are they viewing?

Is there an application?
If so did you write it so you can change it to include the username and  password?

mlmcc
0
 
shamel9873Author Commented:
They are viewing it directly in Crystal 10
0
 
mlmccCommented:
The only way is to use the integrated security so you log in using your Windows authentication.

mlmcc
0

Featured Post

[Webinar] Cloud and Mobile-First Strategy

Maybe you’ve fully adopted the cloud since the beginning. Or maybe you started with on-prem resources but are pursuing a “cloud and mobile first” strategy. Getting to that end state has its challenges. Discover how to build out a 100% cloud and mobile IT strategy in this webinar.

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