Post reply

Assigning sql to use specific ethernet port

  • September 26, 2012 at 1:08 pm

    #262214

    Quick question for everyone,

    Is it possible to direct all SQL traffic to a specific ethernet port on a server? Say you have a 1GB and 10GB NIC card, can you assign SQL traffic to only the 10GB while retaining the 1GB for other operations??

    Thanks in adavnce!

  • September 26, 2012 at 2:06 pm

    #1542607

    You can have SQL server listen on a specific IP, one that is bound to the NIC card you want to accept the traffic. You set the IP and Port your instance will listen on in the SQL Server Configuration Manager.

    Configure a Server to Listen on a Specific TCP Port

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

  • September 26, 2012 at 2:26 pm

    #1542613

    Great, thank you, i'll gove it a shot.

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

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