I am trying to restart an old application that is hard-coded to use a specific SQL login and password. My client did not transfer this login when it moved to a new server. I re-established the login and ran sp_change_users_login, but short of a lucky guess I will probably not be able to recreate the password.
Is there any way to intercept the password? I believe it's encrypted between the application and SQL Server, but maybe there's another approach? Or, is there a way to have SQL Server always authenticate the login? Security is low-priority at the moment.