Results 1 to 4 of 4
  1. #1
    Join Date
    Feb 2004
    Posts
    26

    Lightbulb Unanswered: Renaming ASE 12.5 instance

    What are the steps for renaming an ASE instance? I know most of the external things but how do I get the ASE instance to see itself as the new server name? Like when you do select @@servername.... Thanks.

    DB
    Dogboy

  2. #2
    Join Date
    Feb 2002
    Location
    Willy is on vacation
    Posts
    1,208
    select @@servername
    go

    --if the @@servername returns something different from what you want to set, then first

    exec sp_dropserver <RESULT of @@servername>
    go


    --if there is nothing returned, then

    exec sp_addserver MY125SERVER,local,MY125SERVER
    go

    where MY125SERVER is the name of your ASE instance from the sql.ini or the interfaces file

  3. #3
    Join Date
    Jan 2003
    Location
    Geneva, Switzerland
    Posts
    353
    Note that the database server has to be restarted for this change to take effect.

    Michael

  4. #4
    Join Date
    Mar 2006
    Posts
    25

    Unhappy

    u drop oldserver
    sp_dropserver oldserver_name

    and then set newserver as local
    sp_addserver newserver_name,local.



    Quote Originally Posted by dogboy11
    What are the steps for renaming an ASE instance? I know most of the external things but how do I get the ASE instance to see itself as the new server name? Like when you do select @@servername.... Thanks.

    DB

Posting Permissions

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