Post reply

C-Name in DNS for a SQL server instance... HOW?

  • May 4, 2007 at 4:00 pm

    #116892

    I've been asked if I can set up C-Name Records in DNS for each instance of SQL.  Ummm.. help?

     

    I have 2 servers (testing DOUBLE takes Application Manager 4.2 BETA)

    FERRISSS2

    FERRISTS1

    both have an instance of SQL called "GP" installed on them.

    SO ODBC looks like <servername>\<instance>>

    I.E> FERRISTS1\GP  to connect to it.

    So what are they asking and what can I do?

    I can't create a cname with FERRISTS1\GP pointing to FERRISTS1.FERRISMFG.LOCAL  it won't let me.

    SO maybe I'm missing the boat here.

  • May 7, 2007 at 11:45 am

    #704734

    Why not try FERRISTS1_GP pointing to FERRISTS1.FERRISMFG.LOCAL instead ?

     

    RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."

  • May 8, 2007 at 6:41 am

    #704887

    The part before the "\" is the host name.  That is the part that you can alias with a CNAME record. The part after the "\" is the instance name and it is not related to DNS, just SQL server.  You can't put a "\" in a CNAME record because that is not an allowed character for DNS names.

    So, what are you trying to accomplish through doing this?

     

  • May 8, 2007 at 7:13 am

    #704904

    It turned out the people from double-take were not really sure what was going on.  My DNS server already had entries for each server (as it should) but the software wasn't working right with x64 OS.  It's been resolved. (have to run the app manager from the x64 server till they figure out why non x64 versions can't see the server. 

     

    Thanks,

    Sean~

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

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