Alias for SQL Server named instance RRS feed

  • Question

  • I have SQL Server 2000 and SQLServer 2005 on my machine. The SQL Server 2005 has a named instance. From the server in Management Studio, I can load, and interact with both instances. 

    I have created an alias for the named instance. Now if I try to use the alias to connect in my Management studio, I am unable to do so.

    I get an error saying " Cannot connect to sql2005InstanceAlias"
    It says could not connnet because of the default setting does not allow for remote connections.
    But, I have enabled remote connections.

    I'm not sure what else do I have to do to use this alias?

    Another question I had is after creating the alias on my machine, can someone else connect to the instance(the alias) without specifying the port number remotely and with the SQL browser running? 

    Monday, March 23, 2009 5:30 PM


  • Hello Seema

    When you create an alias, it is specific to your client (PC)

    So the answer is No, other PCs cannot use that alias without it being set up explicitly on their PCs


    • Proposed as answer by Ewan Wednesday, April 29, 2009 10:54 AM
    • Marked as answer by seemap123 Thursday, April 30, 2009 5:12 PM
    Tuesday, April 28, 2009 11:40 AM

All replies