October 26, 2005 at 7:34 am
I have a named instance of SQL Server 2K Standard Edition installed on a single Server running WIN2K.
I would like to install a second named Instance of SQL Server 2K on the same box.
When I rerun the SQL Server installation, do I select 'Create a New Instance' or do I need to select 'Advanced options' when running setup?? I have never done this before and I wanted to make sure before I continued.
Also on the same note... sort of.. when I apply the SQL Server Service Packs to this box, will it ask me which Instance to apply the SP to?
October 26, 2005 at 7:38 am
Choose create new instance and it will give you the option to install a default intance (if one is not present) or uncheck that option and create another named instance. During the patch it will give you a drop down window of all servers that the patch can be applied to.
October 26, 2005 at 7:39 am
I hope there is no need to go to advanced options since in that you will find options to create fail over node and blah blah. you have to proceed on by the normal way other than the place where there is an option to give the name of the instance.
While installing the service packs you have to install that service pack for each and every node individually.
with smiles
santhosh
October 26, 2005 at 8:18 am
Thank you!!! Sounds like I can even install the Second Instance without disrupting the first??? I didn't want to have to do this after-hours!!!
October 27, 2005 at 3:38 am
It may prompt you to shut down the other instance and SNMP etc...
depends on the OS and patch level...
October 27, 2005 at 10:13 am
On Win2K3, you should not have to reboot for the second and successive instances. On Win2K SP3/SP4, it's a 50/50 shot on the reboot. Also, I'd suggest shutting down the following services:
SNMP sometimes causes an installation to hiccup and MOM will cause an installation and SP's to hiccup.
One final note. I ALWAYS reboot after SQL installations and service pack applications. Call me paranoid, old school or whatever. It's just a habit that's served me well since v4.21.
RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."
October 27, 2005 at 10:36 am
Thanks one and all. and I hear ya about rebooting after installations or sp applications.. What I ended up doing was this:
Installation of the second named instance...
checked to be sure it looked 'ok'...
Shutdown the services and applied sp3a to my new instance...
restarted services and I'm good to go!!!
Now I can schedule a reboot afterhours and be on my way...
Thanks again everyone
October 28, 2005 at 9:59 am
Out of curiosity. I thought that instances were only used under SQL Enterprise Edition. Apparently I was mistaken. Can you install extra instances on a SQL 2000 standard box without incurring additional licensing costs?
October 28, 2005 at 10:52 am
Yes.
RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."
October 28, 2005 at 2:35 pm
Rudy: "It depends"
Std edition: Per-processor or Server/CAL makes difference
From MS site:
http://www.microsoft.com/sql/howtobuy/faq.mspx
Q. How does licensing work with the multi-instance feature in SQL Server 2000?
A. You can run multiple instances of SQL Server 2000 on a single computer. Multiple instances are used by organizations that have several applications running on a server, but want them to run in isolation so that any problem in one instance will not affect the other instances.
Under the Processor licensing model of SQL Server 2000, you can install multiple instances of SQL Server on the same computer without having additional licenses. Under the Server/CAL model, you can install multiple instances of SQL Server on the same computer only if you use SQL Server 2000 Enterprise Edition. With Standard Edition, using the Server/CAL licensing model, you must have a separate license for each instance.
Regards
Shawn
"RTFM"
October 28, 2005 at 3:53 pm
Good Day Shawn, I stand corrected - we have an Enterprise license agreement so we can actually do this.
RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."
October 31, 2005 at 12:42 am
No probs.
In a previous life, there was a mix of enterprise and standard with the occasional multi-instance box...
Viewing 12 posts - 1 through 11 (of 11 total)
You must be logged in to reply to this topic. Login to reply