Win a copy of Java Mock Exams (software) this week in the Programmer Certification (OCPJP) 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.
 
What are you doing? You are supposed to be reading this tiny ad!
the new thread boost feature brings a LOT of attention to your favorite threads
https://coderanch.com/t/674455/Thread-Boost-feature
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!