Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 12»»

Renaming a Named Instance Expand / Collapse
Author
Message
Posted Tuesday, January 31, 2012 9:14 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Tuesday, July 15, 2014 7:39 AM
Points: 66, Visits: 186
Is it possible to rename a named instance..?

If yes, are there any issues..?
Post #1244845
Posted Tuesday, January 31, 2012 9:19 PM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Wednesday, February 1, 2012 3:57 AM
Points: 91, Visits: 125
No, you can't rename the named instance.

BOL:

They can be used only to rename the part of the instance name that corresponds to the computer name. For example, you can change a computer named MB1 that hosts an instance of SQL Server named Instance1 to another name, such as MB2. However, the instance part of the name, Instance1, will remain unchanged. In this example, the \\ComputerName\InstanceName would be changed from \\MB1\Instance1 to \\MB2\Instance1
Post #1244847
Posted Tuesday, January 31, 2012 9:25 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Tuesday, July 15, 2014 7:39 AM
Points: 66, Visits: 186
Thanks Padhis..!

I am not able to find an installer file for the below mentioned version.. (In order to create a named instance..I need the install files right..?).

Can you help me..?

Microsoft SQL Server 2005 - 9.00.5000.00 (Intel X86) Dec 10 2010 10:56:29 Copyright (c) 1988-2005 Microsoft Corporation Standard Edition on Windows NT 5.2 (Build 3790: Service Pack 2)
Post #1244848
Posted Tuesday, January 31, 2012 9:30 PM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Wednesday, February 1, 2012 3:57 AM
Points: 91, Visits: 125
Yes you need a installer (setup) file .
Post #1244849
Posted Thursday, June 27, 2013 2:17 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, June 27, 2013 3:43 PM
Points: 1, Visits: 2
Ok, I have the setup/install files. What now? Where do I go in the installation options to rename the instance, not the computer?

Thanks for any input.
Post #1468344
Posted Thursday, June 27, 2013 2:39 PM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 10:17 AM
Points: 12,903, Visits: 31,974
donluz (6/27/2013)
Ok, I have the setup/install files. What now? Where do I go in the installation options to rename the instance, not the computer?

Thanks for any input.


you cannot rename an instance.
you can create a new instance with the desired name, migrate settings manually via scripts, bakcup and restore user databases, and finally uninstall the old one.


Lowell

--There is no spoon, and there's no default ORDER BY in sql server either.
Actually, Common Sense is so rare, it should be considered a Superpower. --my son
Post #1468349
Posted Thursday, June 27, 2013 2:53 PM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: 2 days ago @ 9:08 AM
Points: 550, Visits: 1,610
This would break any code that references the instance name, any linked servers, ODBC connections or connection strings in connecting applications out there. There a lots of gotchas so I would avoid this if possible.

Post #1468354
Posted Wednesday, August 28, 2013 12:40 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, July 25, 2014 1:59 PM
Points: 1, Visits: 25
Geez, I was hoping instance could be renamed . Just to confirm Gurus ,you can't do the following even in 2012

sp_dropserver 'Server Name\old_instance_name'
go
sp_adderver 'Server Name\New_instance_name'
go
Post #1489376
Posted Saturday, August 31, 2013 1:15 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, August 15, 2014 4:58 AM
Points: 115, Visits: 231
Yes, we can rename the instance by using the below commands. I have also involved once in this activity.
sp_dropserver 'old servername'
go
sp_addserver 'new servername'
go


Thanks,
I’m nobody but still I’m somebody to someone………….
Post #1490359
Posted Saturday, August 31, 2013 4:44 AM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Monday, August 18, 2014 3:19 PM
Points: 800, Visits: 713
Again, you cannot rename an instance.

The sp_dropserver/sp_addserver applies whem you have changed the machine name in Windows. In this case you need to do "sp_dropserver oldname" followed by

sp_addserver "newname", local

to have @@servername to show the correct server name.



Erland Sommarskog, SQL Server MVP, www.sommarskog.se
Post #1490374
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse