Solved

Server Password in Crystal Reports

Posted on 2011-03-03
4
629 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

Revamp Your Training Process

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action.

Question has a verified solution.

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

In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
Monitoring a network: how to monitor network services and why? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the philosophy behind service monitoring and why a handshake validation is critical in network monitoring. Software utilized …
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…

630 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