SQL 2008 install changed firewall settings???
Results 1 to 3 of 3

Thread: SQL 2008 install changed firewall settings???

  1. #1
    AO's Filibustier Cheap Scotch Ron's Avatar
    Join Date
    Nov 2008
    Location
    Swamps of Jersey
    Posts
    378

    SQL 2008 install changed firewall settings???

    Installed SQL2008 X64 on Win2k3 SP2 x64. Got a warning during install to check Windows firewall settings. I took a look at the settings, checked netstat. Everything appeared OK to me.

    A few minutes later, i got a call from one of my admins. She could not establish a terminal services connection(TSC) to this server. She could no longer ping the server either. (She is VPNd in and was able to login just prior to the install). I am able to TSC from within the data center without a problem. wtf?

    If I disable the Windows Firewall, she can connect. Is there some option somewhere to configure the windows firewall to distinguish between local addresses?

    Frickin Bill Gates.

    csr
    In God We Trust....Everything else we backup.

  2. #2
    Super Moderator: GMT Zone nihil's Avatar
    Join Date
    Jul 2003
    Location
    United Kingdom: Bridlington
    Posts
    17,191
    If you cannot do someone any good: don't do them any harm....
    As long as you did this to one of these, the least of my little ones............you did it unto Me.
    What profiteth a man if he gains the entire World at the expense of his immortal soul?

  3. #3
    AO's Filibustier Cheap Scotch Ron's Avatar
    Join Date
    Nov 2008
    Location
    Swamps of Jersey
    Posts
    378
    Update/Case closed...

    You can change the "Scope" of a particular Exception in the Windows Firewall.
    Apparently the SQL 2008 install (or one of the Hotfixes that the install installed) changed the scope to "My Network only" on several port exceptions including RDP.

    Here's the technet link I found that tipped me off.
    http://technet.microsoft.com/en-us/l...1.aspx#BKMK_14

    almost cocktail time...

    csr
    In God We Trust....Everything else we backup.

Similar Threads

  1. Grisoft (AVG) To Release Firewall
    By c0br4 in forum AntiVirus Discussions
    Replies: 9
    Last Post: June 23rd, 2005, 12:06 AM
  2. Firewall Basics by stevecronin
    By stevecronin in forum The Security Tutorials Forum
    Replies: 7
    Last Post: January 23rd, 2005, 03:47 AM
  3. Windows Firewall for XP SP2
    By Computernerd22 in forum The Security Tutorials Forum
    Replies: 3
    Last Post: December 27th, 2004, 10:14 AM
  4. Windows XP Tips
    By Nokia in forum Tips and Tricks
    Replies: 4
    Last Post: June 18th, 2004, 04:24 PM
  5. Proxies and Packet Filters in Plain English
    By Remote_Access_ in forum Security Archives
    Replies: 3
    Last Post: December 13th, 2001, 09:58 PM

Posting Permissions

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

 Security News

     Patches

       Security Trends

         How-To

           Buying Guides