locked
Login failed for user (SQL SERVER 2012) RRS feed

  • Question

  • I am running sql server 2012 in mixed server environment. I have created user to connect with sql server authentication but getting below mention error

    Login failed for user 'usman'. Reason: An attempt to login using SQL authentication failed. Server is configured for Windows authentication only. [CLIENT: <local machine>]

    Any help or suggest

    • Moved by Olaf HelperMVP Monday, June 23, 2014 1:31 PM Moved from "SQL Database Engine" to a more specific forum
    Monday, June 23, 2014 12:41 PM

Answers

All replies

  • IS your SQL Server set to accept both windows and SQL authentication?

    http://bjtechnews.org/2012/03/20/microsoft-sql-server-error-18456-login-failed-for-user/


    Regards, Ashwin Menon My Blog - http:\\sqllearnings.com

    • Marked as answer by Irfan_Lhr_PK Monday, June 23, 2014 12:59 PM
    Monday, June 23, 2014 12:50 PM
  • Server is configured for Windows authentication only.


    Your SQL Server is running in "Windows Authentication only" mode, you cannot use SQL Server; you would have to Change the mode first; see Change Server Authentication Mode

    Olaf Helper

    [ Blog] [ Xing] [ MVP]

    Monday, June 23, 2014 12:51 PM
  • Using below link  change the server authentication mode and try if you are getting the same error, if any error message please post the complete error message from sql error log,

    http://msdn.microsoft.com/en-us/library/ms188670.aspx


    Raju Rasagounder Sr MSSQL DBA

    Monday, June 23, 2014 12:56 PM
  • Login failed for user 'usman'. Reason: An attempt to login using SQL authentication failed. Server is configured for Windows authentication only. [CLIENT: <local machine>]

    Any help or suggest

    As per message I would check whether both SQL server and Windows authentication box is checked for SQL server instance or not. Right click on SQL Server instance properties  a server property page will pop up on that select security and make sure radio button SQL Server and windows authentication mode is checked  it would require SQL server service restart to take affect.

    Please mark this reply as answer if it solved your issue or vote as helpful if it helped so that other forum members can benefit from it.

    My TechNet Wiki Articles

    Monday, June 23, 2014 12:56 PM
  • Issue solved !!!

    Monday, June 23, 2014 12:59 PM