Solved

Server Password in Crystal Reports

Posted on 2011-03-03
4
617 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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

Suggested Solutions

Crystal Reports: 5 Tests for Top Performance It is complete, your masterpiece report.  Not only does it meet your customer’s expectations, it blows them out the water, all they want is beautifully summarised and displayed in a myriad of ways. …
When writing XML code a very difficult part is when we like to remove all the elements or attributes from the XML that have no data. I would like to share a set of recursive MSSQL stored procedures that I have made to remove those elements from …
This Micro Tutorial will give you a basic overview how to record your screen with Microsoft Expression Encoder. This program is still free and open for the public to download. This will be demonstrated using Microsoft Expression Encoder 4.
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…

810 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