Rename Default Instance Name SQL Server 2005

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • CK
    #1

    Rename Default Instance Name SQL Server 2005

    We have a server with Sql Server 2000 on it. We installed Sql Server 2005 on
    the same box. It was named SERVERNAME\SQL2 005. What I need to do is
    basically decommision the Sql Server 2000 server and rename the 2005
    instance to just SERVERNAME. Any ideas on how to do this?
    Cheers,
    ~ck


    Tags: None
    • Erland Sommarskog
      #2
      Re: Rename Default Instance Name SQL Server 2005

      CK (c_kettenbach@h otmail.com) writes:
      We have a server with Sql Server 2000 on it. We installed Sql Server
      2005 on the same box. It was named SERVERNAME\SQL2 005. What I need to do
      is basically decommision the Sql Server 2000 server and rename the 2005
      instance to just SERVERNAME. Any ideas on how to do this?
      Uninstall SQL 2000, and install a default instance of SQL 2005. Or upgrade
      the existing instance.

      You cannot rename an existing instance, at least not in a supported way.


      --
      Erland Sommarskog, SQL Server MVP, esquel@sommarsk og.se

      Books Online for SQL Server 2005 at
      http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx

      Books Online for SQL Server 2000 at
      http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

        Comment

        Previous template Next
        Working...