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 |
|
kid_on_the_block
Posting Yak Master
172 Posts |
 Posted - 2006-07-05 : 06:07:04
|
| Hi What if I have some user , who has access to the SQL Server Client Tools, & he types in sql - L in the command line & gets access to the names of all the SQL Servers on the network .He then tries registering the Servers using the SQL authentication using sa & tries some or the other password.... Now he would definately get an error ... My question is that can we track the IP address or the Hostname of such a user ...Thanks |
|
|
ravilobo
Master Smack Fu Yak Hacker
1184 Posts |
Posted - 2006-07-05 : 09:43:33
|
| >> sql - L in the command What is this?>> can we track the IP address or the HostnYou can run a trace and find this------------------------I think, therefore I am - Rene Descartes |
 |
|
|
Westley
Posting Yak Master
229 Posts |
Posted - 2006-07-10 : 00:24:16
|
| You can also set SQL to log all fail logins, and monitor those in your event viewer. |
|
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2006-07-10 : 01:03:21
|
quote:
>> sql - L in the commandWhat is this?
osql -Lorisql -Lquote:
-LLists the locally configured servers and the names of the servers broadcasting on the network.
KH |
|
|
|
|
|
|
SQL Server Registration Hacking