Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
tchavez
Starting Member
2 Posts |
 Posted - 2008-10-30 : 12:31:33
|
| Hi All,I am having an issue where I can only access data in a SQL table via Crystal Reports as SA and not the user. I do not want the user having the SA password. Is there someplace I need to change the access to be SA and users? I looked at the ODBC setting and it is set to With SQL Server authentication using a login ID and password entered by the user. The User ID lsited is SA. Do I need to enter the users name and password and try testing the connection aftewards?Thanks.Tammy |
|
|
DavidChel
Constraint Violating Yak Guru
474 Posts |
Posted - 2008-10-30 : 12:52:50
|
| Tammy,I think you may have better luck on a Crystal Board such as BOB http://www.forumtopics.com/busobj/index.php. However, I created a SQL Login called "Reports" with read only rights to the databases and I use that login for Crystal Reports. |
 |
|
|
tchavez
Starting Member
2 Posts |
Posted - 2008-10-30 : 13:30:53
|
| Thank you. I have posted a topic on the BOB.Tammy |
|
|
|
|
|
|
Crystal Reports and SQL