Win a copy of The Little Book of Impediments (e-book only) this week in the Agile and Other Processes forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

SQL Server is configured for Windows authentication only. Lies.

 
Ash Duckett
Greenhorn
Posts: 3
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi there,

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.
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic