SQL Active/Active Cluster - SQL Server Forums

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.

All Forums

SQL Server 2000 Forums

SQL Server Administration (2000)

SQL Active/Active Cluster

Author

Topic

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2002-04-02 : 09:00:13

Robert writes "Problem
I am unable to install a second instance of SQL server on my cluster.

Configuration
2-node cluster
Windows 2000 Enterprise & SQL 2000 Advanced both w/SP2
I have installed SQL on “Node-A” already. Fail-over cluster setup works fine
I am now trying to install a separate instance of SQL server so it my run on “Node-B”
Both servers on up and running

What I have attempted
Installed with and without SQL (and its associated services) running.
Tried to run the installation from both servers.
Allocated all resources to the server installing the instance.
Used multiple naming conventions to rule out syntax errors

This is the step by step of the install and my entry’s
1. Enter the name of a existing or new virtual server “RDBCLUST60”
2. Enter IP address “192.168.200.xx” using the “PUBLIC” Network connection
3. Placed the data files in the cluster group assigned to Node-B
4. Under Cluster definition, I placed both systems as configured nodes.
5. When asked to enter a valid Domain name and password for the cluster service I enter the same name and password that was used for the previous install (I know this is a valid account. Not entering a valid account brings back an immediate error)
6. For instance name I enter “RDB60”
7. I put the program files on the non-shared “C:” drive and place the data files on a separate drive from the first install. (Shared)
8. When asked for a services account for SQL, I enter a valid domain account. It is the same account as used in the first install (this account as also been checked and verified)
9. When asked to choose authentication I picked mixed mode and entered a SA password.
10. At last I enter the number of licenses (Per seat 25) and I’m done.

The install then runs for about 5 min and returns an error “Setup failed to perform required operations on the clustered nodes”

SQL Install log....

SPLSTP.LOG
09:19:35 Begin Setup
09:19:35 8.00.194
09:19:35 Mode = Normal
09:19:35 ModeType = NORMAL
09:19:35 GetDefinitionEx returned: 0, Extended: 0x0
09:19:35 ValueFTS returned: 1
09:19:35 ValuePID returned: 1
09:19:35 ValueLic returned: 1
09:19:35 System: Windows NT Enterprise Server
09:19:35 SQL Server ProductType: Enterprise Edition [0x3]
09:19:35 IsNTCluster returned: 1
09:19:35 Begin Action: SetupInitialize
09:19:35 End Action SetupInitialize
09:19:35 Begin Action: SetupInstall
09:19:35 Reading Software\Microsoft\Windows\CurrentVersion\CommonFilesDir ...
09:19:35 CommonFilesDir=C:\Program Files\Common Files
09:19:35 Windows Directory=C:\WINNT09:19:35 Program Files=C:\Program Files09:19:35 TEMPDIR=C:\WINNT\TEMP09:19:35 Begin Action: SetupInstall
09:19:35 digpid size : 164
09:19:35 Begin Action: CheckFixedRequirements
09:19:35 Platform ID: 0xf00000
09:19:35 Version: 5.0.2195
09:19:35 File Version - C:\WINNT\System32\shdocvw.dll: 5.0.3315.2879
09:19:35 End Action: CheckFixedRequirements
09:19:41 Begin Action: ShowDialogs
09:19:41 Initial Dialog Mask: 0x183000f7, Disable Back=0x1
09:19:41 Begin Action ShowDialogsHlpr: 0x1
09:19:41 Begin Action: DialogShowSdWelcome
09:19:43 End Action DialogShowSdWelcome
09:19:43 Dialog 0x1 returned: 1
09:19:43 End Action ShowDialogsHlpr
09:19:43 ShowDialogsGetDialog returned: nCurrent=0x2,index=1
09:19:43 Begin Action ShowDialogsHlpr: 0x2
09:19:43 Begin Action: DialogShowSdMachineName
09:20:38 ShowDlgMachine returned: 1
09:20:38 Name = RBDCLUST60, Type = 0x10000008
09:20:38 Begin Action: CheckRequirements
09:20:38 Processor Architecture: x86 (Pentium)
09:20:38 Service Pack: 512
09:20:38 ComputerName: RDB8450-61
09:20:38 User Name: Administrator
09:20:38 IsAllAccessAllowed returned: 1
09:20:38 OS Language: 0x409
09:20:38 End Action CheckRequirements
09:20:38 This combination of Package and Oper

graz
Chief SQLTeam Crack Dealer

4149 Posts

Posted - 2002-04-02 : 09:00:13

And we truncated at 4,000 characters. You can post here if you like.

chadmat
The Chadinator

1974 Posts

Posted - 2002-04-03 : 01:49:58

Just a shot in the dark, cause I can't see the error.

Did you install the second node as a named instance?

Is RDBCLUST60 the same virtual name you used for SQL Server on node A?

This has to be different.

-Chad

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources