Post reply

Renaming Servers

  • October 12, 2005 at 6:43 am

    #166251

    Hi, i want to rename the servers in the console tree on the left of SQL Server Enterprise Manager so that they are easier to understand. At the moment, they are all just IP addresses...

    Can anyone tell me how to change the names of them?

    TYIA

  • October 12, 2005 at 7:35 am

    #596801

    You have two options.  First, go to Client Network Utility, under SQL Server in the Program menu.  There you can set up an alias, e.g. MyServerX -> 10.10.20.30.

    Or, you can use the network name of the server.  This assumes that there is a DNS entry for the server.  If it's over the Internet, you may be out of luck.  Find out what the network name of the server is and you should be able to use that.  You can execute "select @@servername" in QA to find out what the server thinks its name is.  You may have to use a fully qualified name, like MyServerX.MyCompany.net.

    After that, you can re-register the servers under the name instead of the IP address.

    HTH

    Dylan Peters
    SQL Server DBA

  • October 12, 2005 at 9:00 am

    #596831

    thats the exact answer i was looking for mate.... thanks very much.

Viewing 3 posts - 1 through 2 (of 2 total)

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