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 |
|
jp2code
Posting Yak Master
175 Posts |
 Posted - 2008-11-07 : 11:25:33
|
On our SQL Server (2000 w/SP4 I believe), we have an account called "codeonly" with the password "codeonly" and it is set up in our WORKAPP (Windows NT) SQL Server Group with Database Roles of public (I think this is a company account), db_datareader and db_datawriter.This is the connection string I am using:"Data Source=WORKAPP;Initial Catalog=CO_PARTS;Integrated Security=False;User Name=codeonly;Password=codeonly"With this background, I can explain our problem:Out on our factory production floor, all of the computers that are logged in using an account with Group Membership of "Restricted user (Users Group)" can access the data; however, anyone logged in with "Standard user (Power Users Group)" or "Other: Administrator" is refused connection. The error message is:"EXECUTE permission denied on object 'sp_sdidebug', database 'master', owner 'dbo'."The first line of the StackTrace says:" at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)"How do I fix this? Why is a Restricted user allowed access using this string whereas anything above is not?
Avoid Sears Home Improvement |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-11-07 : 11:30:27
|
| check if you've given execute rights for sps to members of standard user group in database |
 |
|
|
|
|
|
SQL Access Account fails