Ipsec & SQL Server

msn_at_jrbrady.com
Date: 05/20/05

  • Next message: Andrew J. Kelly: "Re: SQL Permissions question - SQL Server 2000" 
    Date: Fri, 20 May 2005 11:21:12 -0700

    I, too, am coming under constant attack from hackers attempting to use brute
    force techniques to log into my SQl Server.

    A significant number of these attacks seem to be coming from APNIC:
    specificially, IP addresses in the range 210.0.0.0 to 211.255.255.255. Also,
    I get 50 or so SQL Slammer Worm propagation attempts a week, most of these
    coming from IP addresses beginnign with 61 and 68 (also APNIC, BTW).

    My question is how, exactly, using IPSEC, can I block all IP address
    begining with, say, 61, and all address between 210.0.0.0 to 211.255.255.255.
     I set up a filter defined for "A Specific IP Subnet" as Source Address
    61.0.0.0 with Source Mask, 255.255.255.0, but Ip addresses starting with 61
    are not being filtered out. What am I doing wrong?

    BTW, please don't reply to msn@jrbrady.com as this address is bloked due to
    a surge in viruses being emailed to me there. Please use
    bNrOaSdPyA@Msenior-direct.com instead, but remove the capital letters first.

    TIA!

  • Next message: Andrew J. Kelly: "Re: SQL Permissions question - SQL Server 2000"

    Relevant Pages

    • Re: SQL renamed expression name not recognised in WHERE
      ... OP's original query and my nested table expression ... directive as a filter on a derived value only. ... The corrected version (which run equally well under SQL Server and Oracle ...
      (comp.sys.ibm.as400.misc)
    • Re: 2005 Log Reader
      ... I am thinking 'filter' too, ... Looking for a SQL Server replication book? ... execute 'sp_replcmds' on 'PASASERV\PASLIVE'.'. ... construct replicated command from LSN.'. ...
      (microsoft.public.sqlserver.replication)
    • Re: Linked and Virtual Cubes in SSAS 2005
      ... You should not use DSO to develop new applications instead AMO is available ... Collapse AllExpand All Language Filter: AllLanguage Filter: ... This feature will be removed in the next version of Microsoft SQL Server. ... As per the SQL Server 2005 Books Online, Linked Cubes and Virtual Cubes ...
      (microsoft.public.sqlserver.olap)
    • Re: Views Show Up in SQL Server Tables List
      ... The code I gave was to filter using a TSQL statement. ... I am using the release version of the SQL Server 2005 'SQL Server ... > Microsoft Analysis Services Client Tools 2005.090.1399.00 ... >> lists of objects. ...
      (microsoft.public.sqlserver.clients)
    • Re: SQL Statement Class Helper request
      ... SQL Server will do this as well for regular queries issued ... > connection (there is also the notion of "preparing" a query for use multiple ... One advantage of using Java for the connection pool - this doesn't seem ... > I agree with you that there are ways you might want to filter the query. ...
      (microsoft.public.dotnet.languages.csharp)