Results 1 to 3 of 3
  1. #1
    Join Date
    May 2002
    Location
    Timbaktu
    Posts
    185

    Unanswered: Rename a Sql Server

    How do you rename a Sql Server ?

  2. #2
    Join Date
    Feb 2002
    Posts
    2,232
    Check out the following article:

    article

    Make sure you run sp_helpserver first and copy the information.

  3. #3
    Join Date
    Oct 2002
    Posts
    369

    Exclamation Re: Rename a Sql Server


    How do you rename a Sql Server ?
    Hopefully by following a good plan developed and verified by rigorous prior testing. In other words, cautiously. (This a very broad question to address in this format even with a great deal of additional very specific detail.)

    There are many different ramifications with different versions i.e. ( 6.0, 6.5, 7.0, 8.0) as well as with different editions and all the possible different installation details (the service pack levels of mssql and the OS, the host OS itself, virtual and/or default instances, cluster types and members, federated servers, the machine integration into the network {MS domain, Novell env., member server, stand alone, and so on} etc., etc.)

    None of that begins to address any issues your applications and / or their access methods may face. Generally, this is something you should fastidiously investigate the ramifications of e.g.(by testing on a dev server configured as closely as possible to your production server). Simply changeing the host server OS name and proceeding form there may be a fairly quick and painless process in your specific case; ==> BUT, it may also result in a very expensive disaster (depending on your specific installation, environment, downtime costs, etc., etc.).

Posting Permissions

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