Installing SP4 on a Win2K Cluster Node

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)

Installing SP4 on a Win2K Cluster Node

Author

Topic

TonyTheDBA
Posting Yak Master

121 Posts

Posted - 2007-06-04 : 08:38:21

We have a single node cluster using SQL2K EE running on Win2K EE, and this has been running fine for a year or so. We finally have our new data centre completed, and the additional hardware installed for us to install the second node.

1) I installed Cluster services and added the second node to the cluster.
2) Ran COMClust to add DTC as a cluster resource
3) On the Active Node installed SQL2K, and selected advanced options, Maintain SQL Server . . . .
4) Checked SQL Server resources in Cluster Manager, every thing looks good.
5) Tried to install SP4 from the new passive node - Failed doesn't own resources in the Cluster
6) Tried installing SP4 from the active node . . . Got a bit further but the install fails with a 'Setup was unable to complete the operation on all nodes in the cluster'

At this point I am really stumped Looking at the SQLSP.log file it ends with

16:38:12 Begin SDPassword Dialog
16:38:12 Begin: CheckSAPassword
16:38:12 WARNING : No Blank SA Pwd
16:38:12 End: CheckSAPassword
16:38:12 Begin: SdShowSp3WrngDlg

and searching the net threw up a reference to this [url]http://support.microsoft.com/kb/815431/] KB article[/url]. Although this is not strictly relevant I am wondering if there is an issue with installing a non SP SQL2K on Win2K3, and then when trying to install SP4 its checking to see what SP level its at and rejecting it as it doesn't have SP3 Installed.

Anyone with any ideas? I'm going to try and put sp3a on it first and then see if it will allow me to proceed with the SP4 upgrade., although I also want to try removing SQL2K from the new node and redo it with a install disk with SP3a already applied.

Any other suggestions warmly welcomed

--
Regards
Tony The DBA

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-06-04 : 23:09:03

Try failover cluster resource to passive node and apply sp4 again.

JohnDeere
Posting Yak Master

191 Posts

Posted - 2007-06-04 : 23:16:12

Check
http://support.microsoft.com/kb/914839

Lance Harra

TonyTheDBA
Posting Yak Master

121 Posts

Posted - 2007-06-05 : 14:28:34

Thanks for the suggestions, Trying to Fail the Cluster group worked fine, when I tried to fail the SQL Group it failed. And I need to investigate that.

I should have said that the SQLSPx.LOG file is from the passive node, looking at the active node reveals no problems, which means that the KB article/hotfix isn't relevant here.

I have also removed sql Server from the Passive node and then installed it again from a disk with SP3a already applied . . . Same result when applying SP4. I'm begining to think that its time for a rebuild of both nodes (as a last resort), which is a real PITA as its currently live ATM.

Before doing that however, I'm planning on trying this on another cluster. The Tech Team are rebuilding the server to Base OS level for me tomorrow . . . . Watch this space.

I suppose that its a good thing the DB's are on the SAN, as I can unpresent the SAN storage, do all the installs, and then represent the SAN storage

--
Regards
Tony The DBA

eyechart
Master Smack Fu Yak Hacker

3575 Posts

Posted - 2007-06-05 : 14:55:28

is the new node a possible owner of the sql cluster group and/or resources in your sql cluster group?

-ec

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-06-05 : 23:05:28

You installed sql again on passive node? Should run install on active node and choose to add note.

TonyTheDBA
Posting Yak Master

121 Posts

Posted - 2007-06-08 : 06:13:08

Hi All,

Yes the new node is an owner of the cluser group, and the SQL resources.

I should have been more clear in my update post. From the Active Node I removed SQL 2K SP0 from the Passive Node, and then, following a reboot of the Passive node (Not required but sometimes it helps), From the active node I reinstalled SQL 2K SP3a. Then from the Active node I Tried to install SP4, which failed with a 'Setup was unable to complete the operation on all nodes in the cluster'

Looking at the SQLSPn.log files the installation was successful on the Active Node but failed with a 16:38:12 Begin: SdShowSp3WrngDlg error on the Passive Node.

--
Regards
Tony The DBA

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-06-08 : 13:21:30

You can failover sql resources to another node then apply sp4 again on it.

TonyTheDBA
Posting Yak Master

121 Posts

Posted - 2007-06-19 : 08:52:45

Well things get more curious. I'll ask a question, when is SP3a NOT sp3a?
.
.
.
.
.
.
.
.
.
.
In our case its when you install it from the distro CD as part of your SQL Server install. After applying a hotfix which should have solved our problem . . . . and didn't, and before flattening the servers to do a full rebuild . . . we decided to reapply SP3a . . . And it worked on both nodes. The I applied SP4 and guess what? . . . . . It worked!

So important lesson learned, just because it says that it includes SP3a on the lable doesn't always mean that it actually has SP3a on it :( Still, at least now I have a working two node cluster. Time to build the second node for cluster two :(

Thans for all your suggestions

--
Regards
Tony The DBA

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources