Thursday, February 16, 2012

Accessing SQL Server database from Crystal Reports - being prompted to log on every time?

Hello, this is my first time posting here.
I've never really worked with SQL Server much, but I'm in the process of learning. Please forgive my ignorance.
Anyways, here's my dilemma.
A user at the office uses Crystal Reports (I'm not too familiar with this program either). Crystal Reports pulls data from SQL Server. However, every single time it does so, it prompts her to log into the database.
While there is no serious problem, this has gotten very annoying. She wants to be able to work without being prompted to log on to the database every single time Crystal Reports retrieves data.
How would I go about doing this? The office has no real security issues, so I'm open to "less-than-perfectly-secure" options as well.

I assume that by the log on prompt, you mean a request to enter a password. If that's the case, then your database application is using SQL Authentication. If Crystal Reports does not provide a "remember the password" option, you have to re-enter it each time. If you could use Windows Authentication, the need for entering a password would go away, but this would require changing the application.

Thanks
Laurentiu

No comments:

Post a Comment