Problem: During a logon process to SQL server the following error may appear: “Login failed for user ‘username’. The user is not associated with a trusted SQL Server connection. (Microsoft SQL Server, Error: 18452)”.
Cause (for me anyway): The SQL server has been configured to operate in “Windows Authentication Mode (Windows Authentication)” and doesn’t allow the use of SQL accounts.
Solution: Change the Authentication Mode of the SQL server from “Windows Authentication Mode (Windows Authentication)”
to “Mixed Mode (Windows Authentication and SQL Server Authentication)“.
How:
- Open SQL Management Studio and log in
- Right-click the Server, Select Properties, Select Security
- Switch to SQL Server and Windows Authentication Mode.
- Restart server: Right click server, select Restart