May 23, 2011 at 3:44 am
Hi
I am trying to Install SQL 2008 R2 and I get an error
Rule "Cluster prepared instance" failed and I cant install it.
Please can any one help me.
May 23, 2011 at 4:18 am
I checked the log file it says
Checks if there is at least one cluster prepared instance for the instance that is being clustered.
There is no cluster-prepared SQL Server instance that can be clustered.
But there is cluster added and MSDTC is active
May 23, 2011 at 11:09 pm
paste the error log file and clustered validation file
Regards,
Syed Jahanzaib Bin Hassan
BSCS | MCTS | MCITP | OCA | OCP | OCE | SCJP | IBMCDBA
My Blog
www.aureus-salah.com
May 24, 2011 at 2:28 am
Hi
the log file entry..
.
.
2011-05-23 14:35:11 Slp: Rule running on machine: SQLxxx
2011-05-23 14:35:11 Slp: Rule evaluation done : Succeeded
2011-05-23 14:35:11 Slp: Rule evaluation message: The MSCS cluster has been validated and there are no warnings reported in the MSCS cluster validation report.
2011-05-23 14:35:11 Slp: Send result to channel : RulesEngineNotificationChannel
2011-05-23 14:35:11 Slp: Initializing rule : Cluster prepared instance
2011-05-23 14:35:11 Slp: Rule applied features : ALL
2011-05-23 14:35:11 Slp: Rule is will be executed : True
2011-05-23 14:35:11 Slp: Init rule target object: Microsoft.SqlServer.Configuration.Cluster.Rules.SQLInstanceCheckFacet
2011-05-23 14:35:11 Slp: Cluster-prepped SQL Server instance available to cluster Query String //Product[@ID='SQL2008']/Instance/Feature[Install/MsiFeature[@FeatureState='3' and (@IsConfigured ='1' or @IsConfigured='3') and @ClusterState='2']]
2011-05-23 14:35:11 Slp: Rule 'Cluster_Prepped_Instance' detection result: IsClusterPreppedInstanceAvailable =False
2011-05-23 14:35:11 Slp: Evaluating rule : Cluster_Prepped_Instance
2011-05-23 14:35:11 Slp: Rule running on machine: SQLxxx
2011-05-23 14:35:11 Slp: Rule evaluation done : Failed
2011-05-23 14:35:11 Slp: Rule evaluation message: There is no cluster-prepared SQL Server instance that can be clustered.
2011-05-23 14:35:11 Slp: Send result to channel : RulesEngineNotificationChannel
2011-05-23 14:35:11 Slp: Initializing rule : Remote registry service
2011-05-23 14:35:11 Slp: Rule applied features : ALL
2011-05-23 14:35:11 Slp: Rule is will be executed : True
2011-05-23 14:35:11 Slp: Init rule target object: Microsoft.SqlServer.Configuration.Cluster.Rules.RemoteRegistryServiceFacet
2011-05-23 14:35:11 Slp: The StartMode of service RemoteRegistry on machine SQLxxx is Auto
2011-05-23 14:35:11 Slp: Rule 'Cluster_RemoteRegistryServiceFacet' detection result: IsRemoteRegistryServiceDisabled = False
2011-05-23 14:35:11 Slp: Evaluating rule : Cluster_RemoteRegistryServiceFacet
2011-05-23 14:35:11 Slp: Rule running on machine: SQLxxx
2011-05-23 14:35:11 Slp: Rule evaluation done : Succeeded
.
.
2011-05-23 14:54:07 Slp: Rule running on machine: SQLxxx
2011-05-23 14:54:07 Slp: Rule evaluation done : Succeeded
2011-05-23 14:54:07 Slp: Rule evaluation message: The MSCS cluster has been validated and there are no warnings reported in the MSCS cluster validation report.
2011-05-23 14:54:07 Slp: Send result to channel : RulesEngineNotificationChannel
2011-05-23 14:54:07 Slp: Initializing rule : Cluster prepared instance
2011-05-23 14:54:07 Slp: Rule applied features : ALL
2011-05-23 14:54:07 Slp: Rule is will be executed : True
2011-05-23 14:54:07 Slp: Init rule target object: Microsoft.SqlServer.Configuration.Cluster.Rules.SQLInstanceCheckFacet
2011-05-23 14:54:07 Slp: Cluster-prepped SQL Server instance available to cluster Query String //Product[@ID='SQL2008']/Instance/Feature[Install/MsiFeature[@FeatureState='3' and (@IsConfigured ='1' or @IsConfigured='3') and @ClusterState='2']]
2011-05-23 14:54:07 Slp: Rule 'Cluster_Prepped_Instance' detection result: IsClusterPreppedInstanceAvailable =False
2011-05-23 14:54:07 Slp: Evaluating rule : Cluster_Prepped_Instance
2011-05-23 14:54:07 Slp: Rule running on machine: SQLxxx
2011-05-23 14:54:07 Slp: Rule evaluation done : Failed
2011-05-23 14:54:07 Slp: Rule evaluation message: There is no cluster-prepared SQL Server instance that can be clustered.
2011-05-23 14:54:07 Slp: Send result to channel : RulesEngineNotificationChannel
2011-05-23 14:54:07 Slp: Initializing rule : Remote registry service
.
.
May 24, 2011 at 3:57 am
are you sure this is your cluster machine?
The error from SQL seems like saying the machine is not the cluster aware.
In start-Run-- cluadmin, are you able to see the groups and resource.
----------
Ashish
May 24, 2011 at 4:08 am
Which Installation option have you clicked on the setup of SQL SERVER 2008 R2 ?
have you defined qurum drive in cluster ?
MSDTC and Qurum drive must be define before installation of cluster instance
Regards,
Syed Jahanzaib Bin Hassan
BSCS | MCTS | MCITP | OCA | OCP | OCE | SCJP | IBMCDBA
My Blog
www.aureus-salah.com
May 24, 2011 at 4:29 am
crazy4sql (5/24/2011)
are you sure this is your cluster machine?The error from SQL seems like saying the machine is not the cluster aware.
In start-Run-- cluadmin, are you able to see the groups and resource.
Yes, this is the Cluster Server.. just a hostory on this one..
previously we had win 2008 with SQL 2008 Installed on this cluster.
I went and removed the cluster feature and upgraded the Win 2008 to win 2008 R2 and then I added the Cluster feature back and started to Install SQL 2008 R2.
May 24, 2011 at 4:40 am
Syed Jahanzaib Bin hassan (5/24/2011)
Which Installation option have you clicked on the setup of SQL SERVER 2008 R2 ?have you defined qurum drive in cluster ?
MSDTC and Qurum drive must be define before installation of cluster instance
THe MSDTC i haved added now but the Qurum is active and running, I thought MSDTC can be installed later may be i am wrong
May 25, 2011 at 2:42 am
Hi Guys
I managed to Install SQL by running the validation report again only by selecting few options and that made me to by pass the verification test
Thanks gusy for your time
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply