SQL Server is configured for Windows authentication only. Lies.
posted 4 years ago
Me again. Anybody know why one might get a "Login failed for user <suchandsuch>. Reason: An attempt to login using SQL authentication failed. Server is configured for Windows authentication only." message despite having it setup for both SQL logins and windows logins.
This is SQL server express 2012 and I've been fiddling with it for ages. Googled all over the place. Usually the response to people's questions is "change your authentication mode!" but as I say, it's already set to mixed.
Being pretty new to SQL server I am totally confused.