on 02-21-2014 4:27 AM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
99 | |
11 | |
10 | |
6 | |
5 | |
5 | |
4 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.