SP4 on a failover 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)

SP4 on a failover cluster

Author

Topic

afeldman
Starting Member

10 Posts

Posted - 2005-06-27 : 13:04:04

Hi,

I am having problems installing SP4 on a cluster.
When giving the name of the virtual server, i get the following error message:

"The handle is invalid"

Any ideas?

Thanks,

AF

dragan
Starting Member

17 Posts

Posted - 2005-06-28 : 08:13:22

No idea about your problem...but Microsoft here in South Africa insists that we don't install SP4 as it has flaws (AWE being one of them).

Later

derrickleggett
Pointy Haired Yak DBA

4184 Posts

Posted - 2005-06-28 : 22:34:59

They fixed the AWE issue dragan. There are a LOT of other issues though. I'm still holding off on it.

MeanOldDBA
derrickleggett@hotmail.com

When life gives you a lemon, fire the DBA.

eyechart
Master Smack Fu Yak Hacker

3575 Posts

Posted - 2005-06-29 : 03:37:51

quote:
Originally posted by derrickleggett

They fixed the AWE issue dragan. There are a LOT of other issues though. I'm still holding off on it.

Do you have any links you can share?

dragan
Starting Member

17 Posts

Posted - 2005-06-29 : 07:01:18

Derrick is right, there is a fix.

Here's the link:
http://www.microsoft.com/downloads/details.aspx?FamilyId=7C407047-3F1F-48B8-9E4C-DC32875E1961&displaylang=en

dragan
Starting Member

17 Posts

Posted - 2005-06-29 : 07:50:55

...and here is a list of the other bugs that have been fixed:

http://support.microsoft.com/?kbid=888799

afeldman
Starting Member

10 Posts

Posted - 2005-07-18 : 18:32:28

Hi,

I solved the problem.
To install SP4 on a cluster, the only resource that may have dependencies on the Network Name resource is the SQL server itslef. I removed the dependency from MSTDC, installed SP4 without any problem, re-enabled the dependency in MSTDC, and everything is working perfectly now.

Aron

eyechart
Master Smack Fu Yak Hacker

3575 Posts

Posted - 2005-07-18 : 19:31:11

quote:
Originally posted by afeldman

Hi,

I solved the problem.
To install SP4 on a cluster, the only resource that may have dependencies on the Network Name resource is the SQL server itslef. I removed the dependency from MSTDC, installed SP4 without any problem, re-enabled the dependency in MSTDC, and everything is working perfectly now.

Aron

Do you have a separate cluster group for MSDTC, or is it in the initial cluster group that contains the cluster IP address, cluster name and the Quorum disk?

-ec

afeldman
Starting Member

10 Posts

Posted - 2005-07-18 : 19:39:09

quote:
Originally posted by eyechart

quote:
Originally posted by afeldman

Hi,

I solved the problem.
To install SP4 on a cluster, the only resource that may have dependencies on the Network Name resource is the SQL server itslef. I removed the dependency from MSTDC, installed SP4 without any problem, re-enabled the dependency in MSTDC, and everything is working perfectly now.

Aron

Do you have a separate cluster group for MSDTC, or is it in the initial cluster group that contains the cluster IP address, cluster name and the Quorum disk?

-ec

No. MSDTC is in the samoe cluster group.

Aron

eyechart
Master Smack Fu Yak Hacker

3575 Posts

Posted - 2005-07-18 : 19:51:12

quote:
Originally posted by afeldman
No. MSDTC is in the samoe cluster group.

Aron

The latest from MS says that MSDTC should be in it's own cluster group. With it's own drive (1 GB is fine). Here is the KB article with the details: http://support.microsoft.com/default.aspx?scid=kb;en-us;301600

I am assuming this is a WIN2K3 cluster.

-ec

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources