Intercept password?

• mtrac

  SSC Veteran

  Points: 233

  More actions

  January 11, 2013 at 12:14 pm

  #96992

  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.