Error: 18456, Severity: 14, State: 16
This error is caused based on the user password is not correct from the client system. This message appears in the log file in this location C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG
This error also appears on the event viewer.
Error: 18456, Severity: 14, State: 16
Login failed for user 'sa'. [CLIENT: 192.168.x.xxx]
If this message appears continously check with client system if there is any sql job running and trying to attempt to connect to the server and password is not set right.
In our case we had a diagnostic tool running from this client and the password was changed, this has caused this error message
thanks. do not hesitate trying various recovery database tools, it is often the only choice to retrieve the data from corrupted documents
ReplyDelete