Need to view the username and password a program is using to access a sql database
Posted on 2007-12-02
Hey there, I had one of my team members compile a custome installer for a reporting program that accesses a SQL database. My team member is gone now and we had an issue with the sql server needing to be reloaded.
We have access to the DB through the manager and know the SA password.
We know the SQL user account being used to query the database (is shows up in the event viewer log as logon filed for user 'username') when the application is run and trying to connect to the database.
How can we find out the PW the compiled program is trying to use so we can change the sql password for the user?
Is there anyway to sniff or is there an app withing the sql2005 tools to monitor usernames and passwords being used by incoming connections?