Solved

Server Password in Crystal Reports

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

NAS Cloud Backup Strategies

This article explains backup scenarios when using network storage. We review the so-called “3-2-1 strategy” and summarize the methods you can use to send NAS data to the cloud

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
SHOWPLAN permission denied in database 'AdventureWorks'. 13 111
Printing duplex pages and have a page break 6 50
Crystal Formula to "conditionally count/sum" 3 58
Query 14 57
Introduction: When running hybrid database environments, you often need to query some data from a remote db of any type, while being connected to your MS SQL Server database. Problems start when you try to combine that with some "user input" pass…
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.
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …
In a recent question (https://www.experts-exchange.com/questions/29004105/Run-AutoHotkey-script-directly-from-Notepad.html) here at Experts Exchange, a member asked how to run an AutoHotkey script (.AHK) directly from Notepad++ (aka NPP). This video…

828 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