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 |
|
Dave_007
Starting Member
15 Posts |
 Posted - 2008-10-02 : 18:38:29
|
| HiI am trying to find user names linked to IP addresses for invalid logins. I can fins IP addresses from log files. Is anyway to connect those to correct user names?thanks |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-10-02 : 19:36:32
|
| Didn't get it? Can you explain clearly your requirement? |
 |
|
|
Dave_007
Starting Member
15 Posts |
Posted - 2008-10-03 : 13:58:38
|
| Hi Sodeep,I am trying to find user names/id for any invalid login attempts in sql server. I can find the ip address of the invalid logins by running EXEC sp_readerrorlog. Is there a way to find the user id, instead of IP address? I need to find it via TSQL. Hope It make sense! thanks |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-10-03 : 14:01:09
|
| you can enable Failed logins only in Server Properties -Security. |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-10-03 : 14:06:11
|
quote:
Originally posted by Dave_007
Hi Sodeep,I am trying to find user names/id for any invalid login attempts in sql server. I can find the ip address of the invalid logins by running EXEC sp_readerrorlog. Is there a way to find the user id, instead of IP address? I need to find it via TSQL. Hope It make sense! thanks
It should be xp_readerrorlog |
|
|
|
Dave_007
Starting Member
15 Posts |
Posted - 2008-10-03 : 14:29:11
|
| thanks.... |
|
|
|
|
|
|
Find user name linked to an IP