How can I set up SQL Server to use SQL Server Authentication and grant one user read only access to all the tables in a database and another user write access to all the tables in the database?
Note: I changed the Authentication in SQL Server 2005 Express from "Windows NT" to "SQL Server" Authentication and added a user to every server role but still get the following error message when I test the connection with that user: "Testing the registered server failed. Verify the server name, login credentials, and database, and then click Test again. Login failed for user 'db1'. The user is not associated with a trusted SQL Server connection. (Microsoft SQL Server, Error: 18452)". Enabling the sa account and trying to log in under it didn't work either.