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

Answer 1

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

 

Answer 2

hi Pravi,

named instances can not be renamed...

regards

Answer 3

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~

Answer 4

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

 

Answer 5

 

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~

Answer 6

Thank you

---

Student

Answer 7

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