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 |
|
Lindaweb
Starting Member
3 Posts |
 Posted - 2011-05-12 : 08:31:23
|
| HelloOn sql server log I seeLogin succeeded for user 'user name here'. Connection made using SQL Server authentication. [CLIENT: <named pipe>]While this user is off line and on vacation. How this is happening?How I know which object, using this connection? Or how to find out what is going onThanks |
|
|
lionofdezert
Aged Yak Warrior
885 Posts |
|
|
Lindaweb
Starting Member
3 Posts |
Posted - 2011-05-12 : 09:34:39
|
| Thank you, I know about this SP and I have it, but my question is different |
 |
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2011-05-12 : 10:18:25
|
| Someone is using that person's login. Simple as that. She's either given someone her password or the other person has guessed it.With the data returned by the stored procedure that you have, you can get the host name (machine) and use that to try and ID who's using that login.--Gail ShawSQL Server MVP |
|
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2011-05-12 : 11:33:57
|
| or she wrote an automated process that uses her credentials |
|
|
|
Lindaweb
Starting Member
3 Posts |
Posted - 2011-05-12 : 13:18:53
|
| thank you all,looks she left her computer on, just logged off and left ssms logged to the sql server |
|
|
|
|
|
|
Login succeeded for user she is on vacation