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

how to logon to sqlserver database and run report

how to logon to sqlserver database and run report

(OP)
We just started using crystal reports xi and Im trying to make my first couple of reports, but I'm having trouble with logging on to the sqlserver database.  I can go into the CR standard report creation wizard, create an ole db(ado) connection and I have two options.  I can select my server/db and give it a userid and password.  I can then put the completed report out and anybody can run it. No problem so far, but what i want to do is have the report run with the credentials of the user logged on at runtime. I thought the option for "integrated security" might solve that problem, but if i select "integrated security" and have a test user run the report, any user that runs the report gets the table data even if that user has no sqlserver permissions.

I have tried researching this but have gotten nowhere. Am I just misinterpreting what "integrated security" is?  If so, how can I provide for security so that only authorized users can run certain reports?

thanks for any help...

 

RE: how to logon to sqlserver database and run report

So in defining the permissions to logon to the server, is it just sql or windows, or both. This can be found by looking at the security on the database thru the management studo. If it is defined as SQL only. Then you have to setup all the users and their passwords, so they have permissions to get to the data. And they should have read only permission.  

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