Sign in
 
Home20122008 R2200820052000LibraryForums
SQL Server >
> 
> 
Creating an aliases for two server instances at 1 server

Answered Creating an aliases for two server instances at 1 server

  • Tuesday, February 12, 2013 9:59 AM
     
     
    Sign In to Vote
    0

    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,

     

All Replies

  • Tuesday, February 12, 2013 10:40 AM
     
     Answered
    Sign In to Vote
    0

    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.


     
  • Wednesday, February 13, 2013 7:55 PM
     
     
    Sign In to Vote
    0
    Correct. SSMS is 32 bit app, and your SQLCMD is 64 bit app. Those have different hives in the registry: http://sqlblog.com/blogs/tibor_karaszi/archive/2009/09/08/sql-client-config-32-and-64-bit.aspx

    Tibor Karaszi, SQL Server MVP | web | blog