Forum Discussion
How Get Application name in a Login Failure
bake13
This as I would need at the end (+/-) to know the password that would be incorrect, even if it is in a format ( hash / hex or something like that ), it can be a way, so that after I have the password, I can upload the user with this password and try to get the script after execution.
To check which script could be there, I have a connection problem, even before getting to its execution.
Example : As if it were an old process of an application with an old password that has not been updated to the current password.
See based on the script below, where I was able to identify the name of the application, but so far I could not identify the password.
https://www.mssqltips.com/sqlservertip/2581/sql-server-error-18456-finding-the-missing-databases/
And it is not possible to get a password in clear text.
Olaf
As the process would be specifically linked to a company, so in this part of the application's name, there is a certain rule and this part with the link sent earlier has already helped to partially solve the problem.
Now on the question of the password for being a local SQL Server user, by some sniffer tool I would not be able to capture at least the password in hash format, which would already suit me.
Because then the user with this password that was identified would be going up, not needing to know the password because it is in hash format and there would be capturing the execution script.Nei_Bala ,the answer is still you can't get the app name nor the password (hash) in the error message.
Olaf
You would know of any sniffer application that could identify the password that was getting into SQL Server incorrectly.