Post reply

SQL Server 2008 instance name alias

  • June 25, 2009 at 1:27 am

    #201834

    I have a request to alias a couple of sql servers with "easy" names rather than our hard-to-remember actual server names, i.e. "XXX_Production" and "XXX_Test".

    I have used the SQL config manager on the server to create an alias, and can connect on that server to the alias name with SS Studio Manager, but not remotely (from my computer or another server).

    Is there more to configure?

    thanks....

  • June 25, 2009 at 1:54 am

    #1015119

    If you are not abel to connect remotely you must be getting the errors .

    an you share it please .

    make sure you have SQL Browser enabled and TCP/IP , named pipes protocols enabled .

    HTH

    Abhay Chaudhary
    Sr.DBA (MCITP/MCTS :SQL Server 2005/2008 ,OCP 9i)

  • June 25, 2009 at 2:37 am

    #1015135

    Error with Query Analyzer: Unable to connect to server XXX_Test

    Server: Msg 17, Level 16, State 1

    [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied

    (Not access denied, I'm admin on the server)

    Same error with Named Pipes enabled.

  • June 25, 2009 at 3:02 am

    #1015144

    You need to create the alias on your remote machines.

  • June 25, 2009 at 3:59 am

    #1015171

    You got the answer .Aliases are always created on the client machines .

    On the localhost you have both clients and server .

    Regards

    Abhay Chaudhary
    Sr.DBA (MCITP/MCTS :SQL Server 2005/2008 ,OCP 9i)

  • June 25, 2009 at 4:33 am

    #1015185

    means i have to install the sql config utility on all client machines? not good... 🙁

  • June 25, 2009 at 4:55 am

    #1015195

    Not necessarily... the aliases are stored as entries in the registry, and there are other tools that will maintain these for you.

    If you have SQL 2000 client tools, then the "Client Network Utility" will do the job.

    You can also configure them via the ODBC data sources applet. Go through the motions of setting up a data source for the SQL Server driver, and click the "Client Configuration" button... that also allows you to set up an alias.

  • June 25, 2009 at 5:47 am

    #1015227

    thanks! pushing out a registry update would be soooo much easier...

  • June 25, 2009 at 6:25 am

    #1015243

    This is the area of the registry you need to look at:-

    HKLM\Software\Microsoft\MSSQLServer\Client\ConnectTo

Viewing 9 posts - 1 through 8 (of 8 total)

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