Re: ODBC Connection security


Great info Erland - it works like a charm. Thank you very much.





"Erland Sommarskog" <esquel@xxxxxxxxxxxxx> wrote in message news:Xns9A3DF3C7E2756Yazorman@xxxxxxxxxxxx
SFB EIM (sfbeim@xxxxxxxxxxx) writes:
I have a need to find out when any ODBC connection is made to a certain
SQL Server.

I assume any/all ODBC connections will have to use TCP port 1433 - since
SQL uses only TCP 1433 in this server's case.

Well, a local connection would typically use shared memory.

Is there any SQL method to detect a new ODBC connection and perhaps send a
notification or else log it to some SQL log file?

I need to pick up the remote client's IP address for immediate
notification to Management.

If you are on SQL 2005 SP2, you can set up a login trigger. You can
get the client API from sys.dm_exec_sessions.client_interface_name if you
really only want to report ODBC connections, but ignore OLE DB or .Net.


--
Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

.

Relevant Pages

  • Re: IDENT_CURRENT and empty table
    ... >> And there is no definition what the result will be after fixing the bug. ... Books Online for 2005 is wrong and will be updated. ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ...
    (comp.databases.ms-sqlserver)
  • Re: sorting twice?!
    ... So I run a query to select the top 20 when ordered by datemodified ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ... Books Online for SQL Server 2005 at ...
    (comp.databases.ms-sqlserver)
  • Re: Rolling up spans without breaks between them
    ... CREATE TABLE periods (start datetime NOT NULL, ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ... Books Online for SQL Server 2005 at ...
    (comp.databases.ms-sqlserver)
  • Re: Error: 16954, Severity: 10, State: 1 and Timeout problem
    ... On this DB are runing lot of threads from different applications. ... Probably, other aplication are locking resources, so the first one need ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ...
    (comp.databases.ms-sqlserver)
  • Re: Systematically determine DRI problem(s)
    ... "the original designer probably meant to link them via customer_ID" ... Erland Sommarskog wrote: ... >> of effort to find data problem for the given situation, ... > Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ...
    (comp.databases.ms-sqlserver)