Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Intercept password? Expand / Collapse
Author
Message
Posted Friday, January 11, 2013 12:14 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Thursday, August 29, 2013 9:17 AM
Points: 60, Visits: 50
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.
Post #1406218
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse