Post reply

Is it possible to have an alias for the instance name when connecting to the database ?

  • September 22, 2010 at 3:54 am

    #229608

    Hi All,

    Does anyone know of any methods which I can configure an alias of the instance name ?

    For example, if my instance name is SQLSERVER-CLUST\SQLSERVER1.

    Will I be able to say point the name to an alias like SQLSERVER-CLUST\Server1 ?

    And connecting via sqlcmd will be like: sqlcmd -S SQLSERVER-CLUST\Server1

    Any ideas will be appreciated !

    Thank You !

  • September 22, 2010 at 4:38 am

    #1225445

    yes you can,

    go in configuration manager-- go to client configuration--select alias.

    you will have 4 option

    alias name :- put what you want your server to be named as

    pipe name/port number :- pipe name if named pipe selected and port number(1433) if tcp ip selected in protocol

    protocol :- tcp ip if its enabled, else named pipe

    server :- your original server for which you creating alias. So if your server have instance name then complete name as servername\instance name.

    ----------
    Ashish

  • September 22, 2010 at 6:31 pm

    #1226020

    Hi Ashish,

    Thanks a lot for the help !

    That is exactly what I need !

  • September 23, 2010 at 12:28 am

    #1226105

    Thanks Ashish for the pointer. We can also use SQL Server Client Network utility for doing the same. Both approaches are detailed in the article http://www.mssqltips.com/tip.asp?tip=1620

  • September 23, 2010 at 1:10 am

    #1226116

    My pleasure Dias.

    Venky,

    as mentioned in article:-

    If you haven't installed the SQL Server 2005/2008 client tools, you can still create an alias using the SQL Server Client Network Utility.

    ----------
    Ashish

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

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