How to install a named instance in SQL Server 2005 without affecting the existing instance

Tags:
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?

Answer Wiki

Thanks. We'll let you know when a new response is added.

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.

Discuss This Question: 4  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • ITGuatemala
    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?
    10 pointsBadges:
    report
  • carlosdl
    Hi compatriot. I would recommend creating a new question to make sure all SQL Server experts take a look at it.
    70,220 pointsBadges:
    report
  • MartinX
    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.
    20 pointsBadges:
    report
  • Gconely
    "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.
    10 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following