none
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.

    Thursday, July 12, 2012 4:43 PM

Answers

  • 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

    • Marked as answer by ps0118mj Thursday, July 12, 2012 6:13 PM
    Thursday, July 12, 2012 4:47 PM

All replies

  • 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

    • Marked as answer by ps0118mj Thursday, July 12, 2012 6:13 PM
    Thursday, July 12, 2012 4:47 PM
  • Yes I'm pretty sure it is, but how can I verify?
    Thursday, July 12, 2012 4:49 PM
  • 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. 

    Thursday, July 12, 2012 6:15 PM