Cannot login after creating the user in SQL Server
sql-server
Solution
Try setting your authentication mode to `mixed mode`. Your server does probably not accept logins using sql server accounts.
- Open properties
- Go to "Security"
- Select "SQL Server and Windows Authentication mode"
Problem
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)