Forum Discussion
How Get Application name in a Login Failure
MicrosoftHi Nei_Bala -- This is not possible without writing a bit of code to capture that information and output to the SQL errorlog. Take a look at the RAISERROR function. Take care.
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/- You can not get the application name in the error message, and even if, anyone can "fake" the app name within the connection string.
And it is not possible to get a password in clear text.
OlafAs 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.
