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

  • 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)
  • 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)
  • Re: ODBC Connection security
    ... "Erland Sommarskog" wrote in message ... I assume any/all ODBC connections will have to use TCP port 1433 - since ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ... Books Online for SQL Server 2005 at ...
    (microsoft.public.sqlserver.security)
  • ODBC connections
    ... I have been asked to develop some security software that includes detection ... of what ODBC connections to SQL Server databases exist. ... I don't know about SQL Server security enough to be sure, ... attempts to prevent access by limiting ODBC connections. ...
    (microsoft.public.sqlserver.security)
  • Add NT users
    ... After adding NT users as SQL Server logins, ... them up on their PC using ODBC connections but get the ... group via the main DOMAIN server setup) ...
    (microsoft.public.sqlserver.security)