i have a quest to capture the IP ADDRESS of any ODBC connections coming into a high-profile SQL Server.
since this server is TCP/IP 1433 only (No NamedPipes) I can easily see all 'Established' TCP 1433 sessions with NETSTAT.
but i can't find these same sessions in the Registry. otherwise i would script them out.
has anyone ever scripted something like this or seen a feature within SQL to capture or log these ODBC sessions?
many thanks,
e.i.m.
since this server is TCP/IP 1433 only (No NamedPipes) I can easily see all 'Established' TCP 1433 sessions with NETSTAT.
but i can't find these same sessions in the Registry. otherwise i would script them out.
has anyone ever scripted something like this or seen a feature within SQL to capture or log these ODBC sessions?
many thanks,
e.i.m.