Solved

Server Password in Crystal Reports

Posted on 2011-03-03
4
615 Views
Last Modified: 2012-05-11
I have created a report in Crystal Reports the pulls up via "hotspots" in my database software (E2).  Before the report will run the user is prompted for the server password.  Is there a way to save this password somewhere in crystal reports so this prompt does not come up?
0
Comment
Question by:bmessmore
  • 2
  • 2
4 Comments
 
LVL 19

Expert Comment

by:GJParker
ID: 35029513
What DB are you using ? If you're usiung SQL Server then you could use single sign and get the db to authenticate otherwise this is not possible in the report designer software,

You would need to use a 3rd party viewer that can hold the password or create you're own viewer using ASP, VB, .NET etc.

|HTH
0
 

Author Comment

by:bmessmore
ID: 35029705
The DB is SQL (OLE DB (ADO)
0
 
LVL 19

Accepted Solution

by:
GJParker earned 250 total points
ID: 35029748
In that case you could get your DBA to create the user(s) an account that uses windows authentication and give them read only access to the necessary tables.

That way SQL server will autenticate against their windows account and they won't  be asked for a password.
0
 

Author Closing Comment

by:bmessmore
ID: 35030574
Thank you
0

Featured Post

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

by Mark Wills Attending one of Rob Farley's seminars the other day, I heard the phrase "The Accidental DBA" and fell in love with it. It got me thinking about the plight of the newcomer to SQL Server...  So if you are the accidental DBA, or, simp…
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
Migrating to Microsoft Office 365 is becoming increasingly popular for organizations both large and small. If you have made the leap to Microsoft’s cloud platform, you know that you will need to create a corporate email signature for your Office 365…
Internet Business Fax to Email Made Easy - With eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…

910 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

24 Experts available now in Live!

Get 1:1 Help Now