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

[tuonni]

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

[Former Member]

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

[tuonni]

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

[Former Member]

You may check this: http://connect.microsoft.com/SQLServer/feedback/details/435782/sever-login-failure-storm-for-sql-ser...

[Former Member]

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

[kothandaraman_nagarajan]

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