September 7, 2006 at 4:03 pm
Can anyone guide to install second instance in cluster environment. Do I need to install second instance at active node or can install at passive node including the service packs. Will i have any impact on current active node during installations.
Thanks in advance
September 7, 2006 at 4:32 pm
From what I remember both SQL2000 and SQL2005 are cluster aware, which means that the 2nd instance will install on both nodes.
The installation routine should detect the existing instance and allow you to specify that a 2nd instance be installed.
Last time I walked through an installation it was straight forward but took absolutely ages. I haven't tried a 2nd instance but I would suspect that the machines will be quite heavily thrashed while the installation goes on.
September 8, 2006 at 12:52 pm
The instance should install on both nodes. (We run active/passive on SQL2000 SP3.) I usually simply insert the disk and create the instance, specifying the IP address and drive letter(s) we've carved out on the SAN for data and log files. I've not run into any performance issues on the active node while doing this. Good luck!
September 13, 2006 at 11:10 am
The instance will install across both nodes. One thing you may run into - if you are installing SQL Server 2000 Ent lower than SP3, you'll need to add a named pipe in the 2nd node first, so that system can recognize it - see the following KB article:
http://support.microsoft.com/?id=815431
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply