Results 1 to 3 of 3
  1. #1
    Join Date
    Apr 2004
    Posts
    2

    Unanswered: Rename server names in Enterprise Manager?

    Hi there.

    Sorry 'bout my bad english.
    Is there any possibility, to change the current server name from the stuctureview in the Enterprise Manger. I'm registering a lot of online-servers from my customers. The remote servername is fixed of course, but I want to change it local, to explain it a little bit better
    (e.g. "W2KSQLSRV" -> "CustomerXY")

    Can someone give me a hint, please?

    Thanx.

  2. #2
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    Not mentioned the version of SQL server used>

    If its SQL 2K then you can use SP_DROPSERVER & SP_ADDSERVER which will take affect at the restart of SQL services.

    If its version 7 then you've to run the setup again to take new changes affected.

    Refer to books online about Renaming Servers topic.
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

  3. #3
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54

    Re: Rename server names in Enterprise Manager?

    Originally posted by LuckyLights
    Hi there.

    Sorry 'bout my bad english.
    Is there any possibility, to change the current server name from the stuctureview in the Enterprise Manger. I'm registering a lot of online-servers from my customers. The remote servername is fixed of course, but I want to change it local, to explain it a little bit better
    (e.g. "W2KSQLSRV" -> "CustomerXY")

    Can someone give me a hint, please?

    Thanx.
    It sounds to me like you want to register a server, but have a completely different name show up on the screen in the Server collection. IF I understood what you wanted correctly, according to How to register a server, that can't be done.

    -PatP

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •