multiple instances of sqlserver different dns alias

  • Hi ,

    I have installed named instances sqlserver2005 express and sqlserver2012 on the same Windows 2008 server Virtual machine ,configured sqlserver2012 to use NON Default TCP IP port .

    we need 2 different DNS Aliases for these 2 database Servers i.e I should be able to access by specifying the following properties in my application

    user=sa

    password=myPwd

    hostname=mysql2005.us.comp.com

    port=1433

    instanceName=sqlserv2005

    user=sa

    password=myPwd

    hostname=mysql2012.us.comp.com

    port=1533

    instanceName=sqlserv2012

    Is this possible?Can you give pointers on how to achieve this

    ManyThanks,

    BG

  • Please don't cross post. It just wastes peoples time and fragments replies.

    No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic1442104-1550-1.aspx

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

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

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