Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
maagt
Starting Member
20 Posts |
 Posted - 2008-10-08 : 22:13:32
|
| I'm newly joined a company, and facing a problem that the sa password is hardcoded in the programs to do the execution. Not knowing which applications or people are using the sa login as all staff known the sa password. Regardless of my situation, how can I find out which application is using the sa login? Or any tools can be recommended? Thanks. |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2008-10-09 : 03:08:47
|
Yes. Use SQL Profiler and do a trace for login events.
E 12°55'05.63"N 56°04'39.26" |
 |
|
|
maagt
Starting Member
20 Posts |
Posted - 2008-10-09 : 07:01:19
|
| HiPeso, thanks for the reply.The situation is, i need to change the sa password after finding which application is using the sa password. I can only trace the login event perhaps on the daily modules, i afraid i might left out others if there is no execution to be done. Please advise. thanks a lot. |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2008-10-09 : 07:13:54
|
You can run SQL Profiler running for weeks!And during the trace when you find new logins made by SA, change that account and wait for next trace line.
E 12°55'05.63"N 56°04'39.26" |
|
|
|
maagt
Starting Member
20 Posts |
Posted - 2008-10-09 : 20:17:58
|
Got it. Thank you so much, Peso.  |
|
|
|
|
|
|
finding sa login