INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Jobs

Report prompting for password every time

Report prompting for password every time

(OP)
Is there a way to embed database credentials into a report?

My report always prompts for a password when it's first opened, I don't want this to happen.

The other information (database server, database name, username, etc) are populated already. The connection is using the 'Microsoft OLE DB Provider for SQL Server' and has the following 'Advanced Information' (some values are blank):

Locale Identifier: 2057
Connect Timeout: 15
General Timeout: 0
OLE DB Services: -5
Current Language:
Auto Translate: -1
Initial File Name:
Use Encryption for Data: 0
Replication server name connect option:
Tag with column collation when possible: 0

Note that this is just a .rpt file which connects to a SQL 2005 database server. My report data comes from a SQL query to this database and there are two custom parameters (both datetime) that are passed into the SQL query. I don't think we have the Crystal Enterprise server or Business Objects or anything like that. There are many other reports in my company, all of which work without further prompts but none of which use this particular database.

Please help! If any more information is required please let me know.

RE: Report prompting for password every time

One way to avoid having to enter a password is have the database setup for Windows Authentication (of course it assumes that users will be logging into Windows). Other than that I think you would need to write an 'application' wrapper to pass the authentication information to the database.

RE: Report prompting for password every time

(OP)
Windows authentication isn't possible with this database unfortunately. I'll have to try and write a .net application... yay :)

Thanks

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Resources

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close