Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1426
  • Last Modified:

Adding new node to SQL 2000 SP4 cluster. Can't apply Service Pack 3 SP3

I'm adding a 3rd new node to an existing SQL 2000 Enterprise SP4 cluster on Windows 2003 Enterprise SP2 R2. It is a two node Active/Passive.

SERVER1 and SERVER2 will be the current cluster
SERVER3 is the new node i'm adding.

I have the SERVER3 added and was able to install SQL 2000 Enterprise on this new passive node. I was also able to Apply Service Pack 1, and Service Pack 2 without issue. When applying Service Pack 3 I get the following errors

"All cluster disks available to this virtual server are owned by other node(s)"

I click ok and get

"Setup was unable to verify the state of the server for an upgrade. Verify the server is able to start and that you have provided a valid sa password and restart setup"


I've already read through http://support.microsoft.com/kb/811168.

From what I can guess, I'm thinking I need to be on the current Active node (SERVER1). Then run the Service Pack 3 update from there and it will copy the right binaries to my new node (SERVER3). I'm not sure how it affects the current cluster since it's already at SP4 level.

or

Move the SQL Active Group from (SERVER1) over to the new passive node (SERVER3) and upgrade Service Pack 3 on SERVER3 which is the active node now. Although I'm thinking this will break something since SERVER1 currently has SP4 and failing it over to the passive node (SERVER3) with only SP2 currently on it will cause issues

0
trcadmin
Asked:
trcadmin
  • 12
  • 8
1 Solution
 
Jim P.Commented:
The SQL Server Service Packs are cumulative. You should have been able to go straight to from the RTM/base install to SP4 with no stops in between.

As far as installing SP  on clusters -- In SQL 2k5 you have to do an instance install from a passive node and SPs from the active node. You have to flip all instances to one node and then do the SP.
0
 
trcadminAuthor Commented:
Someone will have to correct me if I'm wrong

But with SQL2000 I thought it was best practice that you must install the Service Pack one by one. SP2, SP3 then SP4.

Or perhaps SQL2000 the Service Packs are not cumulative


I know with SQL 2005 You can go immediately to the latest SP
0
 
Jim P.Commented:
The second paragraph in the Overview area:
-------------------------------------------------------------------------
SP4 is a cumulative Service Pack containing all of the fixes from previous service packs, including MS03-031 security bulletin.
-------------------------------------------------------------------------

As a matter of fact, I talked to an M$ tech way back when that said SP3 was a mistake and shouldn't have been released.

Microsoft SQL Server 2000 Service Pack 4
http://www.microsoft.com/downloads/details.aspx?FamilyID=8e2dfc8d-c20e-4446-99a9-b7f0213f8bc5&displaylang=en
0
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
trcadminAuthor Commented:
interesting Jimpen

Thanks for the link and article. I have setup a maintenance window tomorrow to move SQL over to the new node. I'll skip SP3 then and go straight for SP4, which I believe also requires the SQL resource to be on the active node.

I'll see how that goes.
0
 
trcadminAuthor Commented:
I moved the SQL group over to the new node. I attempted to apply SP4 directly and I"m receiving the following error

After getting to the part where it says "Performing necessary updates to cluster nodes please wait"....

then

"failed to perform required operations on the cluster nodes"


I notice that during the attempted upgrade it stops the following services, SQL Agent, MSSQL and SQLFul Text service. Is this normal?

0
 
trcadminAuthor Commented:
oh yes another thing When checking the SQL server properties on that node it is showing it as Service Pack 4.  Very odd
0
 
trcadminAuthor Commented:
last few lines of SQLSP.log


16:31:38 This combination of Package and Operating System allows a full product install.
16:31:38 End Action  DialogShowSdMachineName
16:31:38 begin ShowDialogsUpdateMask
16:31:38 nFullMask = 0x183000f7, nCurrent = 0x2, nDirection = 0
16:31:38 Updated Dialog Mask: 0xb73c037, Disable Back = 0x1
16:31:38 Dialog 0x2 returned: 0
16:31:38 End Action ShowDialogsHlpr
16:31:38 ShowDialogsGetDialog returned: nCurrent=0x4,index=2
16:31:38 Begin Action ShowDialogsHlpr: 0x4
16:31:38 Begin Action:  DialogShowSdInstallMode
16:31:43 ShowDlgInstallMode returned: -1
16:31:43 ShowDlgInstallMode: GetLastError returned: 0
16:31:43 The operation completed successfully.

16:31:43 End Action  DialogShowSdInstallMode
16:31:43 End Action ShowDialogs
16:31:43 Action CleanUpInstall:
16:31:43 StatsGenerate returned: 2
16:31:43 StatsGenerate (0x0,0x0,0xf00000,0x200,1033,0,0x0,0x20000008,0,0,0
16:31:43 StatsGenerate -1adminUserName)
16:31:43 Installation Failed.
0
 
trcadminAuthor Commented:
Sorry. The above SQLSTP.log


Here is the SQLSP.log


Script file copied to '\\NY_C1B\ADMIN$\NY_C1B_MSSQLSERVER.iss' successfully.

Script file copied to '\\NY_C1A\ADMIN$\NY_C1A_MSSQLSERVER.iss' successfully.

Script file copied to '\\NY_C2A\ADMIN$\NY_C2A_MSSQLSERVER.iss' successfully.

Installing remote service (NY_C1B)...

Installing remote service (NY_C1A)...

Installing remote service (NY_C2A)...

CRemoteProcess::RunUntilComplete [0xd0] exit code: 3010
Remote process exit code was '3010' (NY_C1A).

CThreadPool::RunUntilCompleteHlpr WaitForMultipleObjects returned: 0
CThreadPool::RunUntilCompleteHlpr signaled thread [0xd0]
Thread [0xd0] exit code: [0xbc2]
CRemoteProcess::RunUntilComplete [0xd4] exit code: 3010
Remote process exit code was '3010' (NY_C1B).

CThreadPool::RunUntilCompleteHlpr WaitForMultipleObjects returned: 3010
CThreadPool::RunUntilCompleteHlpr signaled thread [0xd4]
Thread [0xd4] exit code: [0xbc2]
CProcess::RunUntilComplete [0xcc] exit code: 0
Remote process exit code was '0' (NY_C2B).

CThreadPool::RunUntilCompleteHlpr WaitForMultipleObjects returned: 3010
CThreadPool::RunUntilCompleteHlpr signaled thread [0xcc]
Thread [0xcc] exit code: [0xbc2]
CRemoteProcess::RunUntilComplete [0xd8] exit code: -12
Remote process exit code was '-12' (NY_C2A).

CThreadPool::RunUntilCompleteHlpr WaitForMultipleObjects returned: 3010
CThreadPool::RunUntilCompleteHlpr signaled thread [0xd8]
Thread [0xd8] exit code: [0xbc2]
CThreadPool::RunUntilComplete returned 3010
CThreadPool::RunUntilComplete execution level=1, need execution: 0
Disconnecting from remote machine (NY_C2B)...

Service removed successfully.

Remote files could not be removed.

#### SQL Server Remote Setup - Stop Time 05/02/09 15:42:05 ####

Disconnecting from remote machine (NY_C1A)...

Service removed successfully.

Remote files removed successfully.

#### SQL Server Remote Setup - Stop Time 05/02/09 15:42:17 ####

Disconnecting from remote machine (NY_C1B)...

Service removed successfully.

Remote files removed successfully.

#### SQL Server Remote Setup - Stop Time 05/02/09 15:42:34 ####

Disconnecting from remote machine (NY_C2A)...

Service removed successfully.

Remote files removed successfully.

#### SQL Server Remote Setup - Stop Time 05/02/09 15:42:51 ####

                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           
15:42:51 End Action : Run setup on cluster nodes
15:42:51 One or more errors occurred while running remote setup on the clustered machines.
15:43:40 Setup failed to perform required operations on the cluster nodes.
15:43:40 End Action : ClusterSetupHelper
15:43:40 Begin Action : LogEvent
15:43:40 End Action : LogEvent
15:43:40 Begin Action : CloseEventLog
15:43:40 End Action : CloseEventLog
0
 
Jim P.Commented:
Try moving all the instances to a pre-existing node then start the install. Also make sure the user id you are using has admin rights on all involved machines.
0
 
trcadminAuthor Commented:
If I move the SQL instance to the old pre-existing node and run the Service Pack 4 install, will this apply it to both the new nodes?
0
 
Jim P.Commented:
It should -- I've done all my clustering in 2k5 but the it seems typical even with 2000 -- you service pack from a single active node and do new instances from an inactive node.
0
 
trcadminAuthor Commented:
Okay. I'll apply the patch after hours then since the last time I did Service Pack 4 it seems to stop the SQL agent and MSSQL services when applying the SP.

I'll let you know how it goes
0
 
Jim P.Commented:
>> it seems to stop the SQL agent and MSSQL services when applying the SP.

It has too. Part of the SPs is replacing the SQLServer.exe and the SQLAgent##.exe in the instances "C:\Program Files\Microsoft SQL Server\MSSQL.#\MSSQL\Binn" folder.
0
 
trcadminAuthor Commented:
didn't work. Same error. So odd.

"Setup failed to perform required operations on the cluster nodes."



Here are the last lines of SQLSP.LOG

01:06:42 Begin Action : ClusterSetupHelper
01:06:42 Begin Action : CreateClustISSFiles
01:06:42 End Action : CreateClustISSFiles
01:06:42 Begin Action : ClusterWriteRemIni
01:06:42 End Action : ClusterWriteRemIni
01:06:42 Begin Action : Run setup on cluster nodes
[args]
NumRemoteServers=4
Server.1=NY_C1B
Server.2=NY_C1A
Server.3=NY_C2B
Server.4=NY_C2A
[Server.1]
NumRemoteServices=1
1.app="\\nyfile\ny-sprt\Software\Microsoft\SQL 2000\SQL Sservice Pack 4\x86\setup\setupsql.exe"
1.server=NY_C1B
1.script=\\NY_C1B\admin$\NY_C1B_MSSQLSERVER.iss
1.cmdlineformat=%s k=Nb k=Rm k=Cl -SMS -s -f "\\nyfile\ny-sprt\Software\Microsoft\SQL 2000\SQL Sservice Pack 4\x86\setup\setup.ins" -f1 %s -f2 "\\NY_C1B\admin$\setup.log" -e "stpsilnt._ex" -b  -x "C:\DOCUME~1\JONATH~1\LOCALS~1\Temp\1\"
1.user=TRANSRE\svraccount1
1.name=SQLSetup1
1.sqlsetup=Y
1.copyexe=cnvsvc1.exe
[Server.2]
NumRemoteServices=1
1.app="\\nyfile\ny-sprt\Software\Microsoft\SQL 2000\SQL Sservice Pack 4\x86\setup\setupsql.exe"
1.server=NY_C1A
1.script=\\NY_C1B\admin$\NY_C1A_MSSQLSERVER.iss
1.cmdlineformat=%s k=ClSec k=Rm k=Cl -SMS -s -f "\\nyfile\ny-sprt\Software\Microsoft\SQL 2000\SQL Sservice Pack 4\x86\setup\setup.ins" -f1 %s -f2 "\\NY_C1A\admin$\setup.log" -e "stpsilnt._ex"  -x "C:\Documents and Settings\jonathan_adm\"
1.user=TRANSRE\svraccount1
1.name=SQLSetup2
1.sqlsetup=Y
1.copyexe=cnvsvc2.exe
[Server.3]
NumRemoteServices=1
1.app="\\nyfile\ny-sprt\Software\Microsoft\SQL 2000\SQL Sservice Pack 4\x86\setup\setupsql.exe"
1.server=NY_C2B
1.script=\\NY_C1B\admin$\NY_C2B_MSSQLSERVER.iss
1.cmdlineformat=%s k=ClSec k=Rm k=Cl -SMS -s -f "\\nyfile\ny-sprt\Software\Microsoft\SQL 2000\SQL Sservice Pack 4\x86\setup\setup.ins" -f1 %s -f2 "\\NY_C2B\admin$\setup.log" -e "stpsilnt._ex"  -x "C:\Documents and Settings\jonathan_adm\"
1.user=TRANSRE\svraccount1
1.name=SQLSetup3
1.sqlsetup=Y
1.copyexe=cnvsvc3.exe
[Server.4]
NumRemoteServices=1
1.app="\\nyfile\ny-sprt\Software\Microsoft\SQL 2000\SQL Sservice Pack 4\x86\setup\setupsql.exe"
1.server=NY_C2A
1.script=\\NY_C1B\admin$\NY_C2A_MSSQLSERVER.iss
1.cmdlineformat=%s k=ClSec k=Rm k=Cl -SMS -s -f "\\nyfile\ny-sprt\Software\Microsoft\SQL 2000\SQL Sservice Pack 4\x86\setup\setup.ins" -f1 %s -f2 "\\NY_C2A\admin$\setup.log" -e "stpsilnt._ex"  -x "C:\Documents and Settings\jonathan_adm\"
1.user=TRANSRE\svraccount1
1.name=SQLSetup4
1.sqlsetup=Y
1.copyexe=cnvsvc4.exe
01:06:42 Setup is performing required operations on cluster nodes.  This may take a few minutes...
01:06:42  "C:\DOCUME~1\JONATH~1\LOCALS~1\Temp\1\SqlSetup\Bin\remsetup.exe" C:\Documents and Settings\jonathan_adm\WINDOWS\remsetup.ini saEpwd
01:06:42 Process Exit Code: (-1)
01:06:42 Begin Action : GetRemsetupRetCode
01:06:42 Installation return status on NY_C1B : -1
01:06:42 Installation return status on NY_C1A : -1
01:06:42 Installation return status on NY_C2B : -1
01:06:42 Installation return status on NY_C2A : -1
01:06:42 End Action : GetRemsetupRetCode
01:06:42 End Action : Run setup on cluster nodes
01:06:42 One or more errors occurred while running remote setup on the clustered machines.
01:06:44 Setup failed to perform required operations on the cluster nodes.
01:06:44 End Action : ClusterSetupHelper
01:06:44 Begin Action : LogEvent
01:06:44 End Action : LogEvent
01:06:44 Begin Action : CloseEventLog
01:06:44 End Action : CloseEventLog
0
 
Jim P.Commented:
You're using an domain level user that has full admin rights on all nodes in the cluster? And a sysadmin user in all the instances in the cluster?

You have the SA user setup with a password?

Is mixed mode on?

Can you see any errors in the event log on the remote servers?
0
 
trcadminAuthor Commented:
yes, using Doman Level user account with Full Admin rights to all nodes in the cluster as well as the instance

Yes, the SA user account is setup with a password. I attempted to install using Windows Level Authentication and then using SQL authentication, both times it errors out

Mixed Mode security is on and set for SQL server and Windows
0
 
Jim P.Commented:
I went to a cluster in SQL 2K5 and never had to argue with it in SQL 2000.

Have you seen these KB articles?

Have you rebooted all nodes in the cluster -- one at a time?

How to troubleshoot the "Setup failed to perform required operations on the cluster nodes" error message
http://support.microsoft.com/kb/321063/EN-US/

SQL Server 2000 installation fails with "...previous program installation..." error message
http://support.microsoft.com/kb/312995

A cluster upgrade to Service Pack 1 does not succeed if SQL Server services are running under a non-administrator account
http://support.microsoft.com/kb/308829
0
 
trcadminAuthor Commented:
I did some reading. since i've unsuccesffully installed SP4 before rebooting all the nodes sounds like a good idea. I'll give that a shot tonight again.
0
 
trcadminAuthor Commented:
Finally success

ONe of the nodes was the problem node. One of the new nodes was able to receive SQL resource group and Enterprise Manager actually showed SP4 installed. When moving SQL to the Other new Node the SQL services would not start and kept failing. Some articles pointed to it possibly blocking Named Pipes for some reason. I then I found a windows article that says SQL 2000 SP2 and lower on Windows Server 2003 Automatically blocked NAMED PIPES because of some vulnerability issue. Thus meaning One Node updated to SP4 and was not blocking named pipes but The other node could not update directly to SP4 for some reason even though SP4 is cumulative.


I was able to install Service Pack 3 to the Cluster Node even though before I was not able to. I believe it was because I used RMB / ILO connection instead of RDP with /Console switch connection this time, or perhaps because I rebooted each of the cluster nodes as you advised, I'm not sure what solved it. Service Pack 3 installed successfully and unblocked Named Pipes for the Node. Because of this I was able to then apply Service Pack 4 to the cluster node

However when moving SQL1 to the new nodetest Enterprise Manager was not showing the SQL registration. I had to edit a Registry Key to manually enter in the SQL named instance.
Everything came up succesfully now.


Thank you for your help. I am rewarding you full points.
0
 
Jim P.Commented:
Glad to be of assistance. May all your days get brighter and brighter.
0

Featured Post

Become an Android App Developer

Ready to kick start your career in 2018? Learn how to build an Android app in January’s Course of the Month and open the door to new opportunities.

  • 12
  • 8
Tackle projects and never again get stuck behind a technical roadblock.
Join Now