stop listening to unwanted interfaces

[JavidRaj]

I have a SQL Server Desktop Engine installed in my machine.
SQL server listens on all interfaces; just one supported. Since our application is using the MS-SQL server locally it shouldn't be listening on all interfaces but just 127.0.0.1. when i chcke the event viewer and check the event entry:
19013 :
SQL server listening on 172.21.0.5:1433, 172.20.1.5:1433, 127.0.0.1:1433.

my requirement is the sql server should listen only one interface ie 127.0.0.1:1433. how to stop listening the unwanted ones

thanks in advance

Javid

 

[TomSark]

I'm assuming here that by interface, you are implying that SQL Server is listening for 3 different protocols:
Named Pipes, TCP/IP, and Multiprotocol. I would not remove these unless I was at gunpoint...

If you really want to shoot yourself in the foot and remove named pipes and multiprotocol, you can by running the server network utility and clicking on the remove button. I STRONGLY DISCOURAGE THIS!!!!!

Tom Davis
tdavis@sark.com

http://www.sarkdallas.com