Logins using windows authentication works but we can't get any SQL server logins to work.
This is for SQL Server 2012 running on Windows Server 2012 RS.
When we try to login we get the following error.
Login failed for user 'test_user'. (.Net SqlClient Data Provider)
Server Name: theservername
Error Number: 18456
Severity: 14
State: 1
Line Number: 65536
I looked at the SQL server logs and found the following had been logged.
Login failed for user 'test_user'. Reason: An attempt to login using SQL authentication failed. Server is configured for Windows authentication only. [CLIENT: ]
This doesn't make sense since it's not configured for Windows authentication only. To confirm this I right clicked the server (in SQL Server Management Studio) selected properties. Then selected the security tab. Then under 'Server Authentication' the option 'SQL Server and Windows Authentication mode' is selected.
I've also confirmed that only one SQL Server instance is in the server.
What could be causing this?
Thanks,
Scott