Cannot login after creating the user in SQL Server

Question

My problem is I cannot login into SQL Server after I've created a user. The user creation is successful, since the new user is listed under security/logins.

How to solve this issue ???

Login failed for user 'sims'. The user is not associated with a trusted SQL Server connection. (Microsoft SQL Server, Error: 18452)

Answer 1

SQL Server was not configured to allow mixed authentication. Here are steps to fix:

1. Right-click on SQL Server instance at root of Object Explorer,
2. click on Properties.
3. Select Security from the left pane.
4. Select the SQL Server and Windows Authentication mode radio button, and
5. click OK.
6. Open up Services and restart the SQL Service (SQLEXPRESS) Windows service.