Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
samuurai
Starting Member
2 Posts |
 Posted - 2009-01-20 : 05:39:38
|
| Hi,I've got a new SQL 2005 Cluster, which is humming away perfectly with the first clustered instance that was created upon installation.I now want to add a second instance, and i'm using the original installation CD to attempt to do so. It detects the Cluster group with the Clustered Physical Disk resource, but it fails to install, saying it can't start the installer on the second cluster node.It says I should run the installer with the SKUUPGRADE=1 parameter.I think it's having trouble with it because since installing SQL Server 2005 from the installation DVD, i've installed the service pack and other updates and the older installer is having trouble communicating to a newer version of SQL Server.Has anyone come across this before? Is there a newer version of the setup.exe I can run, as i'm a bit dubious about forcing it to install an older version with possibility of overwriting shared DLL's with older versions etc.Here's the exact error:Microsoft SQL Server 2005 9.00.3042.00==============================OS Version : Microsoft Windows Server 2003 family, Enterprise Edition Service Pack 2 (Build 3790)Time : Mon Jan 19 16:44:00 2009LBHSQL1N1 : To change an existing instance of Microsoft SQL Server 2005 to a different edition of SQL Server 2005, you must run SQL Server 2005 Setup from the command prompt and include the SKUUPGRADE=1 parameter.Task did not appear to start on machine: \\LBHSQL1N2: 267013 |
|
|
mcrowley
Aged Yak Warrior
771 Posts |
Posted - 2009-01-20 : 10:00:37
|
| Do you have a group with a disk resource that you can install the new instance onto? And is that group currently owned by the node you are installing on? |
 |
|
|
samuurai
Starting Member
2 Posts |
Posted - 2009-01-20 : 10:06:11
|
| Yep...I got it working...I found that if you go into add/remove programs then modify the installation, you can use that installer. I actually had lots of issues and had to upgrade to SP3.It's working perfectly now. Thanks! |
|
|
|
datosiva
Starting Member
18 Posts |
Posted - 2010-11-09 : 04:32:31
|
| Dear mastersI need to add another instance into the existing SQL Cluster machine.Can you assist me on the above. Currently the SQL group is active on node 2.Do you have any step by step doc. Please help.regardssiva |
|
|
|
|
|
|
Add a second Instance to an SQL Cluster