Rename instance name in SQL 2005

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Administration

Rename instance name in SQL 2005

Author

Topic

gangadhara.ms
Aged Yak Warrior

549 Posts

Posted - 2010-07-15 : 05:26:22

Dear All,

How can rename the instance name in SQL server 2005/2008 ?

Thanks,
Gangadhar

pk_bohra
Master Smack Fu Yak Hacker

1182 Posts

Posted - 2010-07-15 : 07:10:54

Hi Gangadhara,

Generally it is not recommended to rename the instance.But still for some reason you want to do it, have a look at the following link:

http://www.sqlnewsgroups.net/group/microsoft.public.sqlserver.server/topic15810.aspx

Regards,
Bohra

I am here to learn from Masters and help new bees in learning.

Bea
Starting Member

7 Posts

Posted - 2010-07-18 : 03:29:23

Hello

When you install SQL Server 2005, you have an option to make a named instance or keep it as a default instance. You need to uninstall SQL Server 2005 and then reinstall SQL Server 2005, keep an eye out for the option and type in the name you wish to use.

Bea

dinakar
Master Smack Fu Yak Hacker

2507 Posts

Posted - 2010-07-19 : 16:08:31

quote:
Originally posted by Bea

Hello

When you install SQL Server 2005, you have an option to make a named instance or keep it as a default instance. You need to uninstall SQL Server 2005 and then reinstall SQL Server 2005, keep an eye out for the option and type in the name you wish to use.

Bea

Thats incorrect advice.
You can rename your instance with sp_dropserver and sp_Addserver. http://msdn.microsoft.com/en-us/library/ms143799.aspx

Dinakar Nethi
************************
Life is short. Enjoy it.
************************
http://weblogs.sqlteam.com/dinakar/

tdrudge
Starting Member

1 Post

Posted - 2012-04-11 : 00:34:17

quote:
Originally posted by dinakar

quote:
Originally posted by Bea

Hello

When you install SQL Server 2005, you have an option to make a named instance or keep it as a default instance. You need to uninstall SQL Server 2005 and then reinstall SQL Server 2005, keep an eye out for the option and type in the name you wish to use.

Bea

Thats incorrect advice.
You can rename your instance with sp_dropserver and sp_Addserver. http://msdn.microsoft.com/en-us/library/ms143799.aspx

Dinakar Nethi
************************
Life is short. Enjoy it.
************************
http://weblogs.sqlteam.com/dinakar/

To my knowledge (after digging through a lot of different threads) there is still no way to rename the actual instance name. You can rename the server, however not the instance name.

I would be curious to find out if anybody has attempted to hack renaming the instance name.

If anybody has a method of renaming the sql instance, PLEASE LET ME KNOW!!!!

Thomas Drudge
Sr. DBA
The Active Network, Inc.

dinakar
Master Smack Fu Yak Hacker

2507 Posts

Posted - 2012-04-26 : 19:06:04

Well that was something I learnt later as well.. :)
you cannot rename a named instance.. If you had a named instance say NAMED1 on computer say C1 and changed computer name to C2, the new server name would be C2\NAMED1.

Dinakar Nethi
************************
Life is short. Enjoy it.
************************
http://weblogs.sqlteam.com/dinakar/

ovc
Starting Member

35 Posts

Posted - 2012-05-20 : 11:30:59

You cannot rename a named instance. You have to reinstall the instance or as a workaround create an alisa in the SQL Server configuration manager.

Which is the reason to rename a sql server instance?

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources