SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Getting bizarre error while installing SQL 2008 SP2 on standalone server


Getting bizarre error while installing SQL 2008 SP2 on standalone server

Author
Message
Marios Philippopoulos
Marios Philippopoulos
SSChampion
SSChampion (13K reputation)SSChampion (13K reputation)SSChampion (13K reputation)SSChampion (13K reputation)SSChampion (13K reputation)SSChampion (13K reputation)SSChampion (13K reputation)SSChampion (13K reputation)

Group: General Forum Members
Points: 13182 Visits: 3766
While trying to upgrade a SQL-2008 R2 installation to SQL 2008 SP2 I'm getting the following error in the rule-checking phase of the installation:

Rule "Not clustered or the cluster service is up and online." failed.
The machine is clustered, but the cluster is not online or cannot be accessed from one of its nodes.
To continue determine why the cluster is not online and rerun setup instead of rerunning the rule since
the rule can no longer detect a cluster environment correctly.


In the Rule-Check dialog I see these 3 items, among others:

...
- Not clustered or the cluster service is up and online - Status: failed
- Cluster group owned by local computer - Status: passed
- Cluster Resource DLL Update Restart Check: passed

If the server is not clustered, why do I have the last 2 items? It's weird...

__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables
Persisting SQL Server Index-Usage Statistics with MERGE
Turbocharge Your Database Maintenance With Service Broker: Part 2
Marios Philippopoulos
Marios Philippopoulos
SSChampion
SSChampion (13K reputation)SSChampion (13K reputation)SSChampion (13K reputation)SSChampion (13K reputation)SSChampion (13K reputation)SSChampion (13K reputation)SSChampion (13K reputation)SSChampion (13K reputation)

Group: General Forum Members
Points: 13182 Visits: 3766
It looks like I ran out of memory while applying the SP (!), so setup assumed there was an actual problem with the server configuration;
I have restarted the server and will try again:

See section taken from the Detail.txt file in C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20101006_145133:


2:09 Slp: Initializing rule : Not clustered or the cluster service is up and online.
2010-10-06 14:52:09 Slp: Rule applied features : ALL
2010-10-06 14:52:09 Slp: Rule is will be executed : True
2010-10-06 14:52:09 Slp: Init rule target object: Microsoft.SqlServer.Configuration.Cluster.Rules.ClusterServiceFacet
2010-10-06 15:00:32 Slp: Out of memory
2010-10-06 15:00:32 Slp: at System.Management.ManagementException.ThrowWithExtendedInfo(ManagementStatus errorCode)
at System.Management.ManagementObjectCollection.ManagementObjectEnumerator.MoveNext()
at Microsoft.SqlServer.Configuration.Cluster.Rules.ClusterServiceFacet.Microsoft.SqlServer.Configuration.RulesEngineExtension.IRuleInitialize.Init(String ruleId)
at Microsoft.SqlServer.Configuration.RulesEngineExtension.RulesEngine.Execute(Boolean stopOnFailure)
2010-10-06 15:00:32 Slp: Rule initialization failed - hence the rule result is assigned as Failed
2010-10-06 15:00:32 Slp: Send result to channel : RulesEngineNotificationChannel


__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables
Persisting SQL Server Index-Usage Statistics with MERGE
Turbocharge Your Database Maintenance With Service Broker: Part 2
Marios Philippopoulos
Marios Philippopoulos
SSChampion
SSChampion (13K reputation)SSChampion (13K reputation)SSChampion (13K reputation)SSChampion (13K reputation)SSChampion (13K reputation)SSChampion (13K reputation)SSChampion (13K reputation)SSChampion (13K reputation)

Group: General Forum Members
Points: 13182 Visits: 3766
After restarting, I can get past that point, so it seems it was an issue with memory resources on the server...

__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables
Persisting SQL Server Index-Usage Statistics with MERGE
Turbocharge Your Database Maintenance With Service Broker: Part 2
Marios Philippopoulos
Marios Philippopoulos
SSChampion
SSChampion (13K reputation)SSChampion (13K reputation)SSChampion (13K reputation)SSChampion (13K reputation)SSChampion (13K reputation)SSChampion (13K reputation)SSChampion (13K reputation)SSChampion (13K reputation)

Group: General Forum Members
Points: 13182 Visits: 3766
Now I'm getting following error;
can I not upgrade from SQL 2008 R2 to SQL 2008 SP2?

There are no SQL Server instances or shared features that can be updated on this computer.


__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables
Persisting SQL Server Index-Usage Statistics with MERGE
Turbocharge Your Database Maintenance With Service Broker: Part 2
Shawn Melton
Shawn Melton
SSCertifiable
SSCertifiable (6.1K reputation)SSCertifiable (6.1K reputation)SSCertifiable (6.1K reputation)SSCertifiable (6.1K reputation)SSCertifiable (6.1K reputation)SSCertifiable (6.1K reputation)SSCertifiable (6.1K reputation)SSCertifiable (6.1K reputation)

Group: General Forum Members
Points: 6097 Visits: 3537
Just curious but how much memory do you have on the server? Is the server do something else other than SQL Server?

Shawn Melton
Twitter: @wsmelton
Blog: blog.wsmelton.info
Marios Philippopoulos
Marios Philippopoulos
SSChampion
SSChampion (13K reputation)SSChampion (13K reputation)SSChampion (13K reputation)SSChampion (13K reputation)SSChampion (13K reputation)SSChampion (13K reputation)SSChampion (13K reputation)SSChampion (13K reputation)

Group: General Forum Members
Points: 13182 Visits: 3766
Shawn Melton (10/6/2010)
Just curious but how much memory do you have on the server? Is the server do something else other than SQL Server?


48 GB.

I know, I can't explain what happened with the memory, it's bizarre; I have nothing else running, this server is not even in production yet.

Anyways, any thoughts on why I'm unable to upgrade from SQL 2008 R2?

__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables
Persisting SQL Server Index-Usage Statistics with MERGE
Turbocharge Your Database Maintenance With Service Broker: Part 2
Marios Philippopoulos
Marios Philippopoulos
SSChampion
SSChampion (13K reputation)SSChampion (13K reputation)SSChampion (13K reputation)SSChampion (13K reputation)SSChampion (13K reputation)SSChampion (13K reputation)SSChampion (13K reputation)SSChampion (13K reputation)

Group: General Forum Members
Points: 13182 Visits: 3766
Hmm, it may not be too surprising that I cannot upgrade from SQL 2008 R2 to SQL 2008 SP2.

SQL 2008 R2 is probably on a different version stream, so it might have its own service packs in future...

Is it me or are there too many SQL 2008 versions being released?

__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables
Persisting SQL Server Index-Usage Statistics with MERGE
Turbocharge Your Database Maintenance With Service Broker: Part 2
Shawn Melton
Shawn Melton
SSCertifiable
SSCertifiable (6.1K reputation)SSCertifiable (6.1K reputation)SSCertifiable (6.1K reputation)SSCertifiable (6.1K reputation)SSCertifiable (6.1K reputation)SSCertifiable (6.1K reputation)SSCertifiable (6.1K reputation)SSCertifiable (6.1K reputation)

Group: General Forum Members
Points: 6097 Visits: 3537
Marios Philippopoulos (10/6/2010)
Hmm, it may not be too surprising that I cannot upgrade from SQL 2008 R2 to SQL 2008 SP2.

SQL 2008 R2 is probably on a different version stream, so it might have its own service packs in future...

Is it me or are there too many SQL 2008 versions being released?

Yeah the SP1 is the only SP so far for SQL Server 2008 R2.

I don't know that to many versions are being released, there are some cool things in R2 (not that too many people may be using them right off) that could not be implemented by just a service pack for SQL Server 2008.

Shawn Melton
Twitter: @wsmelton
Blog: blog.wsmelton.info
Shawn Melton
Shawn Melton
SSCertifiable
SSCertifiable (6.1K reputation)SSCertifiable (6.1K reputation)SSCertifiable (6.1K reputation)SSCertifiable (6.1K reputation)SSCertifiable (6.1K reputation)SSCertifiable (6.1K reputation)SSCertifiable (6.1K reputation)SSCertifiable (6.1K reputation)

Group: General Forum Members
Points: 6097 Visits: 3537
Marios Philippopoulos (10/6/2010)Is it me or are there too many SQL 2008 versions being released?

They were 4 months shy of 2 year gap between release dates:
SQL Server 2008 -- August 6, 2008
SQL Server 2008 R2 -- April 21, 2010.

Shawn Melton
Twitter: @wsmelton
Blog: blog.wsmelton.info
yup
yup
Ten Centuries
Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)

Group: General Forum Members
Points: 1284 Visits: 1029
For a fix you can run the following commands from an administrative command prompt. Locate this directory: %systemroot%\system32\wbem
Run these commands in sequence & restart your setup.

regsvr32 cluswmi.dll
mofcomp.exe ClusWMI.mof
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search