Sign in
 
Home20122008 R2200820052000LibraryForums
SQL Server >
> 
> 
Authentication Errors

Answered Authentication Errors

  • Thursday, March 01, 2012 2:06 AM
     
     
    Sign In to Vote
    0

    Hi,

    I notice there are lots of the below entries in the sql errorlog :

    Date  1/3/2012 9:24:54 AM
    Log  SQL Server (Current - 1/3/2012 9:21:00 AM)

    Source  Logon

    Message
    Login failed for user ''. Reason: An attempt to login using SQL authentication failed. Server is configured for Windows authentication only. [CLIENT: 192.168.27.222]

    Date  1/3/2012 9:24:54 AM
    Log  SQL Server (Current - 1/3/2012 9:21:00 AM)

    Source  Logon

    Message
    Error: 18456, Severity: 14, State: 58.

    The instance has been running in Mixed mode since installation. There is a connection coming from an application using sql authentication but the instance replied saying that it's configured for Windows authentication only. Any clue ?

    TIA !

     

All Replies

  • Thursday, March 01, 2012 2:11 AM
     
     
    Sign In to Vote
    0
    Are you sure that the server is still using both authentication methods? 

    When you see answers and helpful posts, please click Vote As Helpful, Propose As Answer, and/or Mark As Answer

    Jeff Wharton
    MSysDev (C.Sturt), MDbDsgnMgt (C.Sturt), MCT, MCPD, MCSD, MCITP, MCDBA
    Blog: Mr. Wharty's Ramblings
    Twitter: @Mr_Wharty
    MC ID: Microsoft Transcript

     
  • Thursday, March 01, 2012 3:31 AM
     
     
    Sign In to Vote
    0

    Yes, the sql errorlog indicates Mixed mode when it starts up.

    I'm also able to login using Windows and sql authentication.

     
  • Thursday, March 01, 2012 3:59 AM
     
     
    Sign In to Vote
    0

    Yes, the sql errorlog indicates Mixed mode when it starts up. :  Starts up means After restarting the SQL services in the SQL Error Log

    it says Mixed mode?

    Nag Pal MCTS/MCITP (SQL Server 2005/2008) :: Please Mark Answer/vote if it is helpful ::

     
  • Thursday, March 01, 2012 4:03 AM
     
     
    Sign In to Vote
    0
    Must be using SQL Server 2000

    When you see answers and helpful posts, please click Vote As Helpful, Propose As Answer, and/or Mark As Answer

    Jeff Wharton
    MSysDev (C.Sturt), MDbDsgnMgt (C.Sturt), MCT, MCPD, MCSD, MCITP, MCDBA
    Blog: Mr. Wharty's Ramblings
    Twitter: @Mr_Wharty
    MC ID: Microsoft Transcript

     
  • Friday, March 02, 2012 10:06 AM
     
     
    Sign In to Vote
    0
    Check the connection string for the application to ensure it doesn't include trusted_connection=true.  If it does, delete it.

    When you see answers and helpful posts, please click Vote As Helpful, Propose As Answer, and/or Mark As Answer

    Jeff Wharton
    MSysDev (C.Sturt), MDbDsgnMgt (C.Sturt), MCT, MCPD, MCSD, MCITP, MCDBA
    Blog: Mr. Wharty's Ramblings
    Twitter: @Mr_Wharty
    MC ID: Microsoft Transcript

     
  • Monday, March 05, 2012 1:43 AM
     
     
    Sign In to Vote
    0

    Hi,

    It's SQL 2008. The application that is connecting to it is SAP B1. Not sure how they connect, but they are using SQL authentication.

     
  • Monday, March 05, 2012 1:56 AM
     
     Answered
    Sign In to Vote
    0

    Hi,

    It's SQL 2008. The application that is connecting to it is SAP B1. Not sure how they connect, but they are using SQL authentication.

    You will need to find out how they are conencting

    When you see answers and helpful posts, please click Vote As Helpful, Propose As Answer, and/or Mark As Answer

    Jeff Wharton
    MSysDev (C.Sturt), MDbDsgnMgt (C.Sturt), MCT, MCPD, MCSD, MCITP, MCDBA
    Blog: Mr. Wharty's Ramblings
    Twitter: @Mr_Wharty
    MC ID: Microsoft Transcript

     
  • Wednesday, April 25, 2012 7:34 AM
     
     
    Sign In to Vote
    0

    Hi,

    It's SQL 2008. The application that is connecting to it is SAP B1. Not sure how they connect, but they are using SQL authentication.

    You will need to find out how they are conencting

    When you see answers and helpful posts, please click Vote As Helpful, Propose As Answer, and/or Mark As Answer

    Jeff Wharton
    MSysDev (C.Sturt), MDbDsgnMgt (C.Sturt), MCT, MCPD, MCSD, MCITP, MCDBA
    Blog: Mr. Wharty's Ramblings
    Twitter: @Mr_Wharty
    MC ID: Microsoft Transcript

    Can you please elaborate on this. We are also having same issue and everybody keeps suggesting us to keep the server in mixed mode but that is not the solution here. That may apply to cases where some new DBA or accidental DBA has faced this problem. It does not solve the purpose for us:-(

    Here is my scenario:

    My SQL Server engine is hosted on a server in my domain but the services run under a local account: Server\App

    where App is a local account defined on the system and has sysadmin access.

    My client is hosted on a server in the same domain and it uses SQL authentication to avoid any SPN issues or Kerberos errors.

    But we keep getting error intermittently:

    Source        Logon

    Message
    Login failed for user ''. Reason: An attempt to login using SQL authentication failed. Server is configured for Windows authentication only. [CLIENT: xxxxxxx]

    Source        Logon

    Message
    Error: 18456, Severity: 14, State: 58.

    I will appreciate some pointers because I am not able to find any help regarding this.

    Regards

    Chandan

     
  • Wednesday, April 25, 2012 12:45 PM
     
     
    Sign In to Vote
    0

    Hi,

    Definitely looks like a client configuration error.

    SAP is connecting to the database with a wrong connection string (probably stating SSPI or Integrated Security while it should be providing an

    SQL Login and its Password).

    Sebastian Sajaroff Senior DBA Pharmacies Jean Coutu