Login failed for user 'xyz', localhost, SQL Server Authentication

Question

I am running SQL Server 2008 R2.

I've set up a new user in the Security\Logins folder, and have mapped this user to the database I want the user to have access to.  I also set this database as the Default database, and gave the new user db_datareader and db_datawriter roles.

When I try to 'Connect...' to 'localhost' using SQL Server authentication using this newly created Login, I always get "Login failed for user 'NewUser'".

How can I determine the issue or further troubleshoot?  Thanks very much.

Answer 1

Hello,

Is the SQL Server running in "Mixed Mode" authentification to allow SQL login and not only Windows logins?

---

Olaf Helper
* cogito ergo sum * errare humanum est * quote erat demonstrandum *
Wenn ich denke, ist das ein Fehler und das beweise ich täglich
Blog Xing

Answer 2

Yes I'm pretty sure it is, but how can I verify?

Answer 3

That was it, I only had Windows logins enabled.

For anyone else's reference, in SQL Server Management Studio, right-click on the server, select 'Properties', then the 'Security' item, and ensure that 'SQL Server and Windows Authentication mode' is selected.