installing a default instance AFTER a named instance

Question

installing a default instance AFTER a named instance

Jpotucek

SSCoach

Points: 18583
More actions
May 19, 2008 at 7:42 am

#121429

we have a new SQL Server 2005 (standard edition) box. have already installed a named instance on the box and applied 2005 sp2.
I am now trying to install a default instance on the same box but it is being blocked. When I run setup, it reaches the screen where you choose what to install.. it is basically only letting me install client tools etc.. there is no option to install a new instance.. what am i doing wrong?

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

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

Steve Jones - SSC Editor SSC Guru Points: 738663 More actions · Answer 1

I bet that once a named instance exists, the setup program detects it and prevents the install. It's possible that a scripted install might work, but I've not tried it.

Michael Earl-395764 SSC Guru Points: 53873 More actions · Answer 2

I have never tried to do that either, but it makes sense. If the installer detects any instance of SQL, it may not want to allow anything but a named instance.

However, it could just be that the named instance took port 1433. Try changing the port number on the instance you already have ane re-run the installer.

alimcitp SSC Eights! Points: 930 More actions · Answer 3

I think its not true, I have installed Named Instance and then installed the default instance. I thinks is some thing wrong with your initial installation...

Basit Ali Farooq
MCITP Database Administrator
Microsoft Certified Professional Developer (Web Applications)
Microsoft Certified Database Administrator
Microsoft Certified Systems Engineer
Microsoft Certified Systems Administrator
CIW Security Analyst
Cisco Certified Network Associate

Matt Miller (4) SSC Guru Points: 124210 More actions · Answer 4

Something else is going on, because I did just that (installed a default instance after a named instances). Are you going into Advanced mode? That's the only way to pick another instance.

If something has taken over the primary port (1433) - I'd imagine it would have some trouble too.

----------------------------------------------------------------------------------
Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?

Jpotucek SSCoach Points: 18583 More actions · Answer 5

Thanks for your help. I was using the wrong install media I think. I popped in Disk 1 and it worked fine