Post reply

Restricting IPs which SQL listens on?

  • October 29, 2003 at 3:35 pm

    #65248

    I have six IP addresses on my SQL box, but want SQL Server to only listen on one IP. How do I restrict this on startup?

    -g


    -g

  • October 29, 2003 at 4:53 pm

    #480214

    By default SQL Server listens on port 1433. You can change this thru Enterprise Manager, if necessary, by editing the properties of the server. If you have multiple instances of SQL Server, each listens on a different port.

    Hope this helps.

    Don

  • October 29, 2003 at 6:30 pm

    #480223

    You're not going to be able to restrict this on the SQL Server side, so far as I am aware. However, you can set up an IPSec policy that could block in-bound traffic on the 5 IP addresses for the SQL Server port.

    K. Brian Kelley

    http://www.truthsolutions.com/

    Author: Start to Finish Guide to SQL Server Performance Monitoring

    http://www.netimpress.com/

    K. Brian Kelley
    @kbriankelley

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply