November 16, 2006 at 9:14 am
Good morning,
When you are connecting to a SQL server from a linked table in Access, the user can spoof the host name and application name. So when they are connected to a DB, the process info will show whatever host name was entered.
Is there a way to see the actual IP or host name of that user? Is there a tool for win2k to view actual connections for the SQL server?
Thanks
November 20, 2006 at 8:00 am
This was removed by the editor as SPAM
November 21, 2006 at 4:39 am
You need to look outside the SQL process for best results, so something like Profiler or an IP related tool such as NetMon.
There is also the ODBC trace utility in ODBCAD32 but off the top of my head, I couldn't tell you whether you'll get reliable host aname info from that.
Essentially though, there is only one way to be absolutely sure of who, and what machine, is connecting to SQL server - Windows Authentication plus IPSec.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply