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 derrickleggett@hotmail.com When life gives you a lemon, fire the DBA.
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.
[<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 derrickleggett@hotmail.com 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.
