Windows XP SP2 and SQL Server | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Windows XP SP2 and SQL Server

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.
Windows Firewall as in Microsoft Windows OS firewall???? MeanOldDBA
[email protected] When life gives you a lemon, fire the DBA.
Yes, I mean the Windows Firewall came with Windows XP SP2.
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

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.
Good to know your problem is solved, satya! —
–Frank
http://www.insidesql.de

[<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>
[<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 />
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.
I would change the default port number to something odd, then open up a port exception personally. MeanOldDBA
[email protected] When life gives you a lemon, fire the DBA.
I would go with option 1. 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.
]]>