SQL Server Performance

Windows XP SP2 and SQL Server

Discussion in 'General DBA Questions' started by pcsql, Sep 3, 2004.

  1. pcsql New Member

    Which is a better way to open SQL Server to the network?

    1. Add a port to the Exception of the Windows Firewall.
    2. Add sqlservr.exe to the Exception of the Windows Firewall.


    Thank you for any help.
  2. derrickleggett New Member

    Windows Firewall as in Microsoft Windows OS firewall????

    MeanOldDBA
    derrickleggett@hotmail.com

    When life gives you a lemon, fire the DBA.
  3. pcsql New Member

    Yes, I mean the Windows Firewall came with Windows XP SP2.
  4. FrankKalis Moderator

    Search my site for "Windows XP". Should return 15 hits. All of them are links back to Microsoft Knowledgebase. Too much to post here.


    --
    --Frank
    http://www.insidesql.de
  5. satya Moderator

    Thanks for the hand-on Frank, it helped me other way on Dev. box.

    Satya SKJ
    Moderator
    http://www.SQL-Server-Performance.Com/forum
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
  6. FrankKalis Moderator

  7. satya Moderator

    [<img src='/community/emoticons/emotion-1.gif' alt=':)' />] I was thinking to dip into MS technet site to correct the issue, and meanwhile noticed beneficial reply from you. <br /><br />Added your site as one of my favourites for SQL...<br /><br /><hr noshade size="1"><b>Satya SKJ</b><br />Moderator<br /<a target="_blank" href=http://www.SQL-Server-Performance.Com/forum>http://www.SQL-Server-Performance.Com/forum</a><br /><center><font color="teal"><font size="1">This posting is provided “AS IS” with no rights for the sake of <i>knowledge sharing.</i></font id="size1"></font id="teal"></center>
  8. FrankKalis Moderator

    [<img src='/community/emoticons/emotion-1.gif' alt=':)' />]<br /><br /><br />--<br />--Frank<br /<a target="_blank" href=http://www.insidesql.de>http://www.insidesql.de</a><br />
  9. pcsql New Member

    Frank,

    I have already read those MS articles before I post this thread. If you notice that I'm asking which way is better:

    1. Add a port to the Exception of the Windows Firewall.
    2. Add sqlservr.exe to the Exception of the Windows Firewall.

    The main difference that I found between these 2 ways:

    #2 supports dynamic TCP port.
    #2 also opens up UDP port 1434 for SQL Browser Service.


    Thank you for any help.

  10. derrickleggett New Member

    I would change the default port number to something odd, then open up a port exception personally.

    MeanOldDBA
    derrickleggett@hotmail.com

    When life gives you a lemon, fire the DBA.
  11. satya Moderator

Share This Page