none
How to change SQL Server 2005 instance name

    Question

  • Hi,
      I have installed SQL Server 2005 Express  Edition on my system. The default instance name is set as SQLEXPRESS. I want to change this to something else. Is there anyway I can do that?
    Thanks,
    pravi
    Thursday, December 14, 2006 4:07 AM

Answers

All replies

  • Hi Pravi,

    here is a reference material for renaming a Server / Instance

    http://msdn.microsoft.com/library/default.asp?url=/library/en-us/instsql/in_afterinstall_5r8f.asp

    HTH

    Hemantgiri S. Goswami

     

    • Proposed as answer by Benhaha Tuesday, June 07, 2011 2:45 PM
    Thursday, December 14, 2006 6:02 AM
    Moderator
  • hi Pravi,

    named instances can not be renamed...

    regards

    Thursday, December 14, 2006 4:43 PM
    Moderator
  • I need to change the name of my instance of sql 2005 it is running on the same box as my sql 2000 version... we want to move to the 2005 version by detaching and reattaching the 2000 database to sql 2005 but we need the instance name to be the same... can I do this? Other wise we will have to change all our apps and reports to look at this instance... not good!

     

    ~pt~

    Tuesday, August 05, 2008 7:06 PM
  • hi,

    SQL Server instances can not be renamed.. you can, eventually, upgrade your SQL Server 2000 instance to a SQL Server 2005 one as an in-place upgrade.. not sure if this is a good idea on production sistems thought.. did you already tested the "upgraded" databases in the SQL Server 2005 instance?

    regards

     

    Wednesday, August 06, 2008 10:07 AM
    Moderator
  •  

    Yes we have tested the 2005 instance and migrated and updated the user logins as well from the 2000 database...

     

    Any input about upgrading the SQL Server 2000 instance to SQL Server 2005 as an in-Place upgrade and how to proceed with this... I didn't think you could upgrade the 2000 in place?

     

    Thanks for your help ~pt~

    Wednesday, August 06, 2008 10:55 AM
  • Thank you
    Student
    Friday, March 13, 2009 9:59 AM
  • First collect the output of the current instance configuration
    1. sp_helpserver
    2. select @@servername

    Execute the below query to change the instance name

    1. sp_dropserver ‘old_name’
    2. go
    3. sp_addserver ‘new_name’ , ‘local’
    4. go

    Verify sql server instance configuration by running below queries

    1. sp_helpserver
    2. select @@servername
    • Proposed as answer by Benhaha Tuesday, June 07, 2011 2:44 PM
    Thursday, November 05, 2009 3:54 PM
  • 1. install a new Sql instance with the new instance name.

    2. detach the database files in your old (to be erazed) sql instance.

    3. attach the database files in your new instance

    4. showdown/uninstall old instance.

    Dan

    Sunday, April 18, 2010 5:24 PM
  • Thanks this works
    Rahul
    Wednesday, April 28, 2010 6:25 PM
  • In my version I had to:

     

    First collect the output of the current instance configuration

    1. sp_helpserver
    2. select @@servername

    Execute the below query to change the instance name

    1. sp_dropserver ‘old_name’
    2. go
    3. sp_addserver ‘new_name’ , ‘local’
    4. go

    RESTART SQL SEVER

    Verify sql server instance configuration by running below queries

    1. sp_helpserver
    2. select @@servername

    Friday, June 17, 2011 2:41 PM