Skip to Content
avatar image
Former Member

Error: 18456, Severity: 14, State: 8 on sql server 2008 R2 and SAP Business one

Dear Expert,

i have trouble about error log server, the error are

02/19/2014 11:29:19,Logon,Unknown,Login failed for user 'sa'. Reason: Password did not match that for the login provided. [CLIENT: 61.132.220.2] 02/19/2014 11:29:19,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 8. 02/19/2014 11:29:18,Logon,Unknown,Login failed for user 'sa'. Reason: Password did not match that for the login provided. [CLIENT: 61.132.220.2] 02/19/2014 11:29:18,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 8. 02/19/2014 11:29:17,Logon,Unknown,Login failed for user 'sa'. Reason: Password did not match that for the login provided. [CLIENT: 61.132.220.2] 02/19/2014 11:29:17,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 8. 02/19/2014 11:29:16,Logon,Unknown,Login failed for user 'sa'. Reason: Password did not match that for the login provided. [CLIENT: 61.132.220.2] 02/19/2014 11:29:16,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 8. 02/19/2014 11:29:15,Logon,Unknown,Login failed for user 'sa'. Reason: Password did not match that for the login provided. [CLIENT: 61.132.220.2] 02/19/2014 11:29:15,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 8. 02/19/2014 11:29:14,Logon,Unknown,Login failed for user 'sa'. Reason: Password did not match that for the login provided. [CLIENT: 61.132.220.2] 02/19/2014 11:29:14,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 8. 02/19/2014 11:29:13,Logon,Unknown,Login failed for user 'sa'. Reason: Password did not match that for the login provided. [CLIENT: 61.132.220.2] 02/19/2014 11:29:13,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 8. 02/19/2014 11:29:12,Logon,Unknown,Login failed for user 'sa'. Reason: Password did not match that for the login provided. [CLIENT: 61.132.220.2] 02/19/2014 11:29:12,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 8. 02/19/2014 11:29:12,Logon,Unknown,Login failed for user 'sa'. Reason: Password did not match that for the login provided. [CLIENT: 61.132.220.2] 02/19/2014 11:29:12,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 8. 02/19/2014 11:29:11,Logon,Unknown,Login failed for user 'sa'. Reason: Password did not match that for the login provided. [CLIENT: 61.132.220.2] 02/19/2014 11:29:11,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 8. 02/19/2014 11:29:10,Logon,Unknown,Login failed for user 'sa'. Reason: Password did not match that for the login provided. [CLIENT: 61.132.220.2] 02/19/2014 11:29:10,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 8. 02/19/2014 11:29:09,Logon,Unknown,Login failed for user 'sa'. Reason: Password did not match that for the login provided. [CLIENT: 61.132.220.2] 02/19/2014 11:29:09,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 8. 02/19/2014 11:29:08,Logon,Unknown,Login failed for user 'sa'. Reason: Password did not match that for the login provided. [CLIENT: 61.132.220.2] 02/19/2014 11:29:08,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 8. 02/19/2014 11:29:07,Logon,Unknown,Login failed for user 'sa'. Reason: Password did not match that for the login provided. [CLIENT: 61.132.220.2]

02/19/2014 11:29:07,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 8.

after 8 hours sap business one not responding, or database in sql server suspended and user cannot run transaction.

when i check the ip on ip-lookup, show location country is chiness, did any one has experience about this problem

this error using SQL Server 2008 R2 and SAP Business one 9.0 PL 7.

Please for feedback

i attach log file sql server

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Feb 21, 2014 at 05:03 AM

    Hi Tony,

    1. login SQL server management studio by Window authentication mode instead of SQL authentication mode

    2. If you log in through SQL authentication mode, you should have correct password. This password determined when installing Data base server logon window.

    3. Please refer link Microsoft SQL Server Error 18456 Login Failed for User - YouTube

    Thanks & Regards,

    Nagarajan

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Feb 21, 2014 at 04:45 PM

    Hi,

    This error need to be handled through firewall. Someone is trying to access your SQL server. Your firewall setting should not allow all other publick IP to access SQL port. Only IP used by your company should allow connect.

    Thanks,

    Gordon

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Feb 24, 2014 at 05:07 AM

    Hi Ngaranjan K,

    thanks for the reply my thread, the sql server has already SQL Server and Windows authentication mode, and success login with user sa, but this log error is every second with 2 -4  error message.

    Gordon,

    thanks for replay my thread,

    the server already has physical Firewall and already set trusted IP Public, when i Close internet connection the error are

    02/20/2014 09:47:21,Logon,Unknown,Login failed for user 'sa'. Reason: Failed to open the explicitly specified database. [CLIENT: 127.0.0.1] 02/20/2014 09:47:21,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 38. 02/20/2014 09:47:20,Logon,Unknown,Login failed for user 'sa'. Reason: Failed to open the explicitly specified database. [CLIENT: 127.0.0.1] 02/20/2014 09:47:20,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 38. 02/20/2014 09:47:19,Logon,Unknown,Login failed for user 'sa'. Reason: Failed to open the explicitly specified database. [CLIENT: 127.0.0.1] 02/20/2014 09:47:19,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 38. 02/20/2014 09:47:18,Logon,Unknown,Login failed for user 'sa'. Reason: Failed to open the explicitly specified database. [CLIENT: 127.0.0.1] 02/20/2014 09:47:18,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 38. 02/20/2014 09:47:17,Logon,Unknown,Login failed for user 'sa'. Reason: Failed to open the explicitly specified database. [CLIENT: 127.0.0.1] 02/20/2014 09:47:17,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 38. 02/20/2014 09:47:16,Logon,Unknown,Login failed for user 'sa'. Reason: Failed to open the explicitly specified database. [CLIENT: 127.0.0.1] 02/20/2014 09:47:16,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 38. 02/20/2014 09:47:15,Logon,Unknown,Login failed for user 'sa'. Reason: Failed to open the explicitly specified database. [CLIENT: 127.0.0.1] 02/20/2014 09:47:15,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 38. 02/20/2014 09:47:14,Logon,Unknown,Login failed for user 'sa'. Reason: Failed to open the explicitly specified database. [CLIENT: 127.0.0.1] 02/20/2014 09:47:14,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 38. 02/20/2014 09:47:13,Logon,Unknown,Login failed for user 'sa'. Reason: Failed to open the explicitly specified database. [CLIENT: 127.0.0.1] 02/20/2014 09:47:13,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 38. 02/20/2014 09:47:12,Logon,Unknown,Login failed for user 'sa'. Reason: Failed to open the explicitly specified database. [CLIENT: 127.0.0.1] 02/20/2014 09:47:12,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 38. 02/20/2014 09:47:11,Logon,Unknown,Login failed for user 'sa'. Reason: Failed to open the explicitly specified database. [CLIENT: 127.0.0.1] 02/20/2014 09:47:11,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 38. 02/20/2014 09:47:10,Logon,Unknown,Login failed for user 'sa'. Reason: Failed to open the explicitly specified database. [CLIENT: 127.0.0.1] 02/20/2014 09:47:10,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 38. 02/20/2014 09:47:09,Logon,Unknown,Login failed for user 'sa'. Reason: Failed to open the explicitly specified database. [CLIENT: 127.0.0.1] 02/20/2014 09:47:09,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 38. 02/20/2014 09:47:08,Logon,Unknown,Login failed for user 'sa'. Reason: Failed to open the explicitly specified database. [CLIENT: 127.0.0.1] 02/20/2014 09:47:08,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 38.

    please to advice to this problem

    Regards,

    Tony

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jun 28, 2016 at 06:33 AM

    To fix this problem you need to enable SQL Server Authentication


    >In the Object Explorer, right click on the server and click on "Properties

    >Select "Security" option

    >Change "Server authentication" to "SQL Server and Windows Authentication mode"

    >Restart the SQL Server service


    If this doesnt help you then you can also take the help of MS SQL Server password recovery tool

    Add comment
    10|10000 characters needed characters exceeded