Changing the default Instance name

Question

Changing the default Instance name

tomy1980

Newbie

Points: 1
More actions
April 12, 2011 at 12:22 am

#148804

Dear All,
I just want to take ur kind attention to one of our client's requirement which u can find below,
Machine Name = A
Default Instance Name .....They want it to be B instead of A as there are a lot of applications pointing to this instance B already in another machine
NB: (Itz a sql migration from sql server 2005 to sql server 2008) and both machines are in the same network...so we cannot use the same machine name.
Thanking you in advance. Any response will be highly appreciated.
Regards
Thomas

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply

Lowell SSC Guru Points: 323518 More actions · Answer 1

tomy1980 (4/12/2011)
Dear All,
I just want to take ur kind attention to one of our client's requirement which u can find below,
Machine Name = A
Default Instance Name .....They want it to be B instead of A as there are a lot of applications pointing to this instance B already in another machine
NB: (Itz a sql migration from sql server 2005 to sql server 2008) and both machines are in the same network...so we cannot use the same machine name.
Thanking you in advance. Any response will be highly appreciated.
Regards
Thomas

if both machines are going to be on the same network,you are out of luck as far as renaming. default instances inherit the computername they reside on.

can you rename [MachineB] to MachineOld]? adn then rename [MachineA] to [MachineB]?

if [MachineA] is the new SQL2008 server, taking over the workload for [MachineB], that would make sense.

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!