I'm not sure if this belongs here or in a SQL Server forum. It's an ADO.NET application though so I'm posting it here first.
Here is our environment. XP workstations. SQL Server 2005 Enterprise Edition, on Windows 2003 server.
We are putting together our first C# windows-based SQL application. We want to install it on 50 to 100 workstations. The first piece is very simple. It starts by running a stored procedure which adds the user name and the
current time to a table.
If I put a test user into the SQL Server role [sysadmin] it works flawlessly. If the user is not assigned that role I get the error "Login failed for Domain\User". When I looked at the SQL Server logs, I see [Error :18456, Severity:14, State:
11.] which is telling me that the Login is valid, but server access failed. Obviously, I don't want to give all our users sysadmin rights.
Essentially, we're trying to figure the minimum security settings that will allow our windows users to read, write, and delete from tables in a database, and execute stored procedures. We thought we understood the security settings but we're missing
something. I don't know how to start with "sysadmin" and remove priveleges one at a time.
Here are a few things w
View Complete Post