locked
Creating an aliases for two server instances at 1 server RRS feed

  • Question

  • Hello guys,

    I'm sorry for posting question to the wrong place if it is so.

    MS SQL Server 2008 r2

    I have two named instances: server\instance1, server\instance2 - at server with ip, say, 10.24.146.13.

    Now I'm trying to create an aliases for each of them to test some stuff.

    Note: I do it at the server itself.

    -

    So, I followed lots of guides and performed following actions:

    1) For each instance, using SQL Server Configuration Manager, I configured listening TCP Ports: 1500(for instance1) and 1501(for instance2);

    2) Using cliconfg.exe, I enabled TCP/IP protocol and created 2 aliases(sqlinst1, sqlinst2);

    3) Turned off Firewall;

    Now, if I use "sqlcmd -S sqlinst1" command, I connect successfully. But using sqlinst1 or sqlinst2 as a server name in SQL Server Management Studio returns an error: "Cannot connect to sqlinst1. Additional information: A network related error or instance-specific error occurred while.. And so on."

    What have I missed?

    I guess, that problem is in DNS, I probably should create a DNS record, but I have only 1 ip-adress for both servers...

    Please help!

    Best regards,

    Anton,

    Tuesday, February 12, 2013 9:59 AM

Answers

  • As it often happens, right after you post ur problem, a solution comes to mind.

    I missed something for the first time. After I recreated an aliases for instances(both for 32bit and 64bit OS) using Configuration Manager,  everything went fine. I'm pretty happy for this mystery :)

    And there are no need in configuring DNS records or somewhat else.


    Tuesday, February 12, 2013 10:40 AM

All replies