Home > IT Answers > SQL Server > How to install a named instance in SQL Server 2005 without affecting the existing instance
SQL Server Ask the Experts
2,585 pts.
 How to install a named instance in SQL Server 2005 without affecting the existing instance
SQL Server 2005, SQL Server installation
I have SQL Server 2005 installed and the default instance running. I want to install an additional named instance. How should I go about creating the new instance, without affecting the existing one?

Software/Hardware used:
ASKED: March 16, 2008  10:28 PM
UPDATED: March 16, 2011  4:06 PM
RELATED QUESTIONS
Answer Wiki:
You have to run through the installer a second time. During the install the installer will ask you what the name of the instance should be. A reboot will be required after the install, and then another reboot will be required after SP2 is installed. Your default instance will not be effected except for being unavailable during the reboots.
Last Wiki Answer Submitted:  March 16, 2008  11:11 pm  by  Denny Cherry   64,550 pts.
All Answer Wiki Contributors:  Denny Cherry   64,550 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

Hi I am in Guatemala and i have a problem with sqlserver2005, i had a sqlserver2000 whith an instances data base, I upgrade to 2005 and appear the Data Base instance made in 2000 but i want to upgrade it for the 2005 or just delete it. I try with the ARPwrapper.exe command but the instance doesnt exist in the window How can I do?

ITGuatemala
 10 pts.
 

Hi compatriot.

I would recommend creating a new question to make sure all SQL Server experts take a look at it.

carlosdl
 63,580 pts.
 

So each new instance requires a total install with the same SPs and hotfixes as current install? If I need to install SPs or hotfixes later on, does the OS/SQL know to install the updates on all instances? Thank you.

MartinX
 20 pts.
 

“So each new instance requires a total install with the same SPs and hotfixes as current install? If I need to install SPs or hotfixes later on, does the OS/SQL know to install the updates on all instances? Thank you.”

–> Depends usually on how you install the patcheshotfixes. Typically when I have done it using the gui version, it has given me the choice to update all instances or a specific one.

Gconely
 10 pts.