Re: ODBC Connection security

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

  • ODBC --Call Failed Error
    ... settings and originally did not change any ODBC connections. ... Within one procedure I execute 2 SQL ... I have profiled SQL Server and I see the successful ...
    (microsoft.public.access.forms)
  • Re: Query stops working with ODBC to SQL Server. Help!
    ... When I started using sql server with Access I too ... But ODBC connections, as you are experiencing, have limitations ... If you have not used ADO before but your back end is going to be Sql ...
    (comp.databases.ms-access)
  • ODBC SQL Server
    ... What is the demand on SQL Server when running a client ... mdb which uses many ODBC connections? ...
    (microsoft.public.sqlserver.odbc)
  • Problems sharing a workbook created from External source
    ... I recently upgraded our SQL Server from SQL2005 to SQL2008. ... retrieved data from the SQL server using ODBC connections and brought the ... After the upgrade, ...
    (microsoft.public.excel.misc)
  • Install SQL Server 2000 on home network
    ... I'm a web developer who is trying to expand my database knowledge by ... I've kept it bare bones and am trying to install SQL Server 2000. ... Server to start when I start the computer and I can create ODBC connections ...
    (microsoft.public.sqlserver.setup)