[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 635
  • Last Modified:

Server Password in Crystal Reports

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
bmessmore
Asked:
bmessmore
  • 2
  • 2
1 Solution
 
GJParkerCommented:
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
 
bmessmoreAuthor Commented:
The DB is SQL (OLE DB (ADO)
0
 
GJParkerCommented:
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
 
bmessmoreAuthor Commented:
Thank you
0

Featured Post

Learn to develop an Android App

Want to increase your earning potential in 2018? Pad your resume with app building experience. Learn how with this hands-on course.

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