Post reply

SQL Server 2008 Port binding

  • March 1, 2012 at 5:00 am

    #256752

    Hi,

    I have got 3 SQL SQL 2008 Instance in a single Window 2008 Server. We are planning to bind FQDN with SQL port. Without changing connection String at application side.

    Exp:

    db1.xyx.com it should connect SQL instance 1,

    db2.xyx.com it should connect SQL instance 2,

    db1.xyx.com it should connect SQL instance 3

    can any one suggest how to do port binding with IP/FQDN

    Regards,

    Vinod K

  • March 1, 2012 at 11:42 am

    #1453809

    SQL Server Client has support for Aliases, these may be published by using Group Policy Preferences.


    Ole Kristian Velstadbråten Bangås - Virinco - Facebook - Twitter

    Concatenating Row Values in Transact-SQL[/url]

  • March 1, 2012 at 11:53 am

    #1453816

    DNS is incapable of port binding.. So as you have specified it it cannot be done.

    However, since it isn't a clustered machine you may be able to add 2-3 IP addresses to the NIC card and bind each instance (on port 1433) to that IP address..

    DNS can only convert a name to an IP address, it can't give you a port as well..

    CEWII

  • March 5, 2012 at 10:26 pm

    #1455100

    Thank you friends....

    I have been assined 2 more ip to my server. But iam not able to bind the ips with SQL

    Instances. Can any one send me the steps for ip binding with sql instance

  • March 6, 2012 at 8:30 am

    #1455364

    SQL Server Configuration Manager

    SQL Server Network Configuration

    Protocols for InstanceX

    Protocols for InstanceY

    Protocols for InstanceZ

    Under each of those protocols will be TCP/IP, by default they will all listen on all IP addresses. You will need to turn off most of those and enable the individual IP addresss and specific ports.

    CEWII

Viewing 5 posts - 1 through 4 (of 4 total)

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