Connecting to Server using SQL Server Authentication

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.
Who is Participating?
Goodangel MatopeConnect With a Mentor Software ArchitectCommented:
If you are using SQL Server authentication, you will need to have a Login (see the security node on your SQL Management Studio )

Only when you have created a valid login will you be able to log in using SQL Server authentication.
Do you allow remote connections on the server?

How are you connecting to the server? .NET, SQL Server Management Studio?

Declan_BasileITAuthor Commented:
I allow remote connections, but regardless, I can't login using SQL Server Management Studio on the same computer running the server.  I set up an account "db1" and assigned it to every server role.  Why can I not log in?
What are your SQL Server Configuration Manager: client protocols?

You have performed the usual fix for 18452 - changing it to Mixed Mode. You have stopped and restarted the service (yes?). Maybe SQL Server is not listening to TCP/IP?
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.