+ Post New Thread
Results 1 to 15 of 15
Windows Thread, ISA Queries... in Technical; 1) How do you setup ISA 2004 to use MS SQL Server 2000 for the web proxy logs? 2) How ...
  1. #1

    Gatt's Avatar
    Join Date
    Jan 2006
    Posts
    6,678
    Thank Post
    861
    Thanked 650 Times in 431 Posts
    Rep Power
    499

    ISA Queries...

    1) How do you setup ISA 2004 to use MS SQL Server 2000 for the web proxy logs?

    2) How do you change the "Error Code: 502 Proxy Error. The ISA Server denied the specified Uniform Resource Locator (URL). (12202) " page to a custom one - in our case - bright red background with big bold white lettering saying "WEBSITE HAS BEEN BLOCKED - WHO'S A NAUGHTY PUPILL THEN?"

  2. #2

    Ric_'s Avatar
    Join Date
    Jun 2005
    Location
    London
    Posts
    7,592
    Thank Post
    109
    Thanked 769 Times in 598 Posts
    Rep Power
    181

    Re: ISA Queries...

    Can't remember off the top of my head... something about destination sets and redirect to a page.

    You can also add sound... watch them squeel when they have headphones on and a siren goes off :twisted:

  3. #3

    Gatt's Avatar
    Join Date
    Jan 2006
    Posts
    6,678
    Thank Post
    861
    Thanked 650 Times in 431 Posts
    Rep Power
    499

    Re: ISA Queries...

    :mrgreen:

    Lol, we were talking about that today - though we were gonna see if we could use the PC Speaker!

    This is the page we want them to see...
    blocked page

  4. #4

    Ric_'s Avatar
    Join Date
    Jun 2005
    Location
    London
    Posts
    7,592
    Thank Post
    109
    Thanked 769 Times in 598 Posts
    Rep Power
    181

    Re: ISA Queries...

    @Gatt: BROKEN LINK!

    I hope you can decipher my vague instructions

  5. #5

    Gatt's Avatar
    Join Date
    Jan 2006
    Posts
    6,678
    Thank Post
    861
    Thanked 650 Times in 431 Posts
    Rep Power
    499

    Re: ISA Queries...

    Yeah - im hearing 2 sides - one is as you talk about - which i thnk you need to set up an explicit deny rule for so will prob need to reverse the rule i have at the moment...

    Re link: was working last night - got a feeling my folks may have been messing with stuff again (they keep getting "booted" offline - so reset the router! night before last they switch off my Linux Box! didn't shut it down - just killed the power! )

  6. #6

    Ric_'s Avatar
    Join Date
    Jun 2005
    Location
    London
    Posts
    7,592
    Thank Post
    109
    Thanked 769 Times in 598 Posts
    Rep Power
    181

    Re: ISA Queries...

    @Gatt: It sounds like you deny everything barr a whitelist. If you simply change your default rule from 'deny access' to 'redirect to URL' you should be able to do it with ease

  7. #7

    Gatt's Avatar
    Join Date
    Jan 2006
    Posts
    6,678
    Thank Post
    861
    Thanked 650 Times in 431 Posts
    Rep Power
    499

    Re: ISA Queries...

    Cheers Ric_ - think I got it working now

  8. #8

    Join Date
    Mar 2006
    Location
    Bradford
    Posts
    99
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0

    Re: ISA Queries...

    Mine just redirects to a page saying 'Sorry, pupil access to this site is banned'

    It used to also say 'I'll make this page prettier when I get the time, I'm sure some of you will see a lot of it! :P '

    But I got tired of them asking me when I would make it look better, as I never got round to it lol.

  9. #9

    Gatt's Avatar
    Join Date
    Jan 2006
    Posts
    6,678
    Thank Post
    861
    Thanked 650 Times in 431 Posts
    Rep Power
    499

    Re: ISA Queries...

    ok its not quite working - i get the new blocked.htm page when a banned url is hit - but now i cant get allowed sites to open up..

    my rule is ..

    Deny
    Protocols: FTP/HTTP/HTTPS
    from: Internal
    To: blocklist.xml
    condition: All Pupils

    I have tried with a sep rule allowing external, which gets the errror above

    Do i add the External as an exclusion to the above rule?

  10. #10

    Join Date
    Mar 2006
    Location
    Bradford
    Posts
    99
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0

    Re: ISA Queries...

    So is it blocking all sites now, even those you want to allow?

  11. #11

    Gatt's Avatar
    Join Date
    Jan 2006
    Posts
    6,678
    Thank Post
    861
    Thanked 650 Times in 431 Posts
    Rep Power
    499

    Re: ISA Queries...

    no its working now dunno what was wrong tho..
    Now need to figure out how to integrate with SQL for the proxy logs :-S
    Last timei tried it kept killing the firewall service!!

  12. #12

    Join Date
    Mar 2006
    Location
    Bradford
    Posts
    99
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0

    Re: ISA Queries...

    Can't help at all there, just log to files here.

  13. #13

    Gatt's Avatar
    Join Date
    Jan 2006
    Posts
    6,678
    Thank Post
    861
    Thanked 650 Times in 431 Posts
    Rep Power
    499

    Re: ISA Queries...

    Argh - followed instructions from Microsoft to the letter and still the firewall service falls over after about 5 mins.

    Created the database in SQL using the sql script, added the user, created the DSN in ODBC.

    Only thing i can think of is the system policy - i did enable the remote logging (NetBIOS and SQL) and reboot but still no joy

  14. #14

    Ric_'s Avatar
    Join Date
    Jun 2005
    Location
    London
    Posts
    7,592
    Thank Post
    109
    Thanked 769 Times in 598 Posts
    Rep Power
    181

    Re: ISA Queries...

    Never actually done this myself. It doesn't work like IAS does it, where if a write to the database fails, it borks?

    Do the event logs indicate anything and is anything written to the database before the firewall service dies?

  15. #15

    Gatt's Avatar
    Join Date
    Jan 2006
    Posts
    6,678
    Thank Post
    861
    Thanked 650 Times in 431 Posts
    Rep Power
    499

    Re: ISA Queries...

    No - on both counts

SHARE:
+ Post New Thread

Similar Threads

  1. DNS Queries excessive ?
    By Scruff in forum Wireless Networks
    Replies: 12
    Last Post: 16th October 2007, 06:08 PM
  2. Joomla Queries
    By bensewell in forum Web Development
    Replies: 2
    Last Post: 20th July 2007, 09:32 AM
  3. Active Directory saved queries question.
    By tosca925 in forum Windows
    Replies: 4
    Last Post: 2nd May 2007, 03:17 PM
  4. LimitLogin Queries
    By Gatt in forum Windows
    Replies: 11
    Last Post: 29th January 2007, 12:46 PM
  5. One||Zero queries
    By Gatt in forum Windows
    Replies: 18
    Last Post: 23rd May 2006, 02:23 PM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •