Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
chriking
Starting Member
2 Posts |
 Posted - 2004-07-20 : 11:37:51
|
| Hello,Is there a way to limit the IPs SQL listens on? I have several IPs on the server but I only want SQL to listen on about 5. Is this possible to setup?Any help is appreciated...Thanks,Ck |
|
|
Merkin
Funky Drop Bear Fearing SQL Dude!
4970 Posts |
Posted - 2004-07-20 : 21:17:57
|
| I don't know of a way you can SQL Server to do this, however you could possibly use Windows packet filtering to firewall out the other addresses.Damian |
 |
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2004-07-20 : 23:11:25
|
| Is it a dedicated SQL Server?MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
|
|
|
chriking
Starting Member
2 Posts |
Posted - 2004-07-21 : 14:50:13
|
| Thanks for replying...It is not a dedicated SQL box. I could block it on the firewall, my thinking is that it's taking a lot of resources listening on the other ips. If you guys don't think it's that big of a hog, I won't worry about it.Ck |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-07-21 : 14:51:20
|
| SQL Server is a hog, but it's a hog when it comes to memory and CPU.Tara |
|
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2004-07-21 : 14:52:47
|
| I wouldn't be worried about it consuming resources on the server. If you want to lock it down, delete named pipes as a valid protocol and only have tcp/ip, then limit that port. Then put your limitations on the firewall to prevent invalid traffic(which you should have anyway). You're not going to save on resources by doing this though.MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
|
|
|
|
|
|
Limit Listening IPs