SQL Server Login Dialogue Box problems

[antivirus22]

I have created a Crystal Report and placed in on the server. Many different users access this crystal report which uses SQL tables. The problem is when they go to set the new paramaters, the Sql login box pops up and the only password that seems to be accepted is the SA password. How can I fix this??

 

[SQLSister]

I would say your users don;t have the correct permissions to run the stored procedure or query the crystal report is based on.

 

[antivirus22]

The Crystal report just uses the Sql tables on one database (Data_01). How do I set up user rights? When I look at Data_01 (Users) the users seem to be set up.

 

[mikeyb540]

Check the SELECT and EXECUTE permissions on the SP or the objects refrenced in the SP.

Since, all users are added to the public role just grant EXECUTE for the SP

 

[antivirus22]

I use Enterprise manager... What is SP?

 

[SQLBill]

SP is Stored Procedure.

Your users are accessing via Crystal Reports and it keeps asking for the SA password.

Have you checked the ODBC connection? That may have been set up using the SA account. If so, your users just need to 1) change the login to their login or 2) create a new ODBC connection using their login.

If that's not it, in Enterprise Manager go to the database, expand the database and find Stored Procedures. Click on that and find the stored procedure. Right click and select Properties. Click on Permissions. Find the user(s) who need to execute the stored procedure and put a CHECK mark in the box for EXECUTE.


-SQLBill