| Author |
 Topic  |
|
|
gangadhara.ms
Constraint Violating Yak Guru
India
497 Posts |
 Posted - 07/15/2010 : 05:26:22
|
Dear All,
How can rename the instance name in SQL server 2005/2008 ?
Thanks,
Gangadhar |
|
|
pk_bohra
Flowing Fount of Yak Knowledge
India
1182 Posts |
|
|
Bea
Starting Member
7 Posts |
Posted - 07/18/2010 : 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
Flowing Fount of Yak Knowledge
USA
2507 Posts |
Posted - 07/19/2010 : 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
USA
1 Posts |
Posted - 04/11/2012 : 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
Flowing Fount of Yak Knowledge
USA
2507 Posts |
Posted - 04/26/2012 : 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
Romania
30 Posts |
Posted - 05/20/2012 : 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? |
|
|
| |
Topic |
|
Rename instance name in SQL 2005
