SQL Server 2008 Service pack 2 installation on a failover cluster

Question

Hi All,

 

I have problem with installing SQL Server service pack 2 on Windows Server 2008 x64 on SQL Server 2008 clustered environment.

Pasted log from Detail.txt:

 

2011-10-05 08:15:35 SQLEngine: : Upgrading resource type 'SQL Server' using resource for instance 'BRTMLOST08SQL1A' as reference ...

2011-10-05 08:15:38 Slp: Configuration action failed for feature SQL_Engine_Core_Inst during timing ConfigRC and scenario ConfigRC.

2011-10-05 08:15:38 Slp: The RPC server is unavailable

2011-10-05 08:15:38 Slp: Configuration action failed for feature SQL_Engine_Core_Inst during timing ConfigRC and scenario ConfigRC.

2011-10-05 08:15:38 Slp: System.ComponentModel.Win32Exception: The RPC server is unavailable

2011-10-05 08:15:38 Slp:    at Microsoft.SqlServer.Configuration.Cluster.ClusterResource.UpgradeResourceDLL(String nodeName, String dllPathName)

2011-10-05 08:15:38 Slp:    at Microsoft.SqlServer.Configuration.SqlEngine.SQLEngineClusterFeature.UpgradeResourceDLL(SQLServiceResource sqlResource)

2011-10-05 08:15:38 Slp:    at Microsoft.SqlServer.Configuration.SqlEngine.SQLEngineClusterFeature.ConfigureSQLEngineResourceType()

2011-10-05 08:15:38 Slp:    at Microsoft.SqlServer.Configuration.SqlEngine.SqlEngineSetupPrivate.Patch_ConfigRC(EffectiveProperties properties)

2011-10-05 08:15:38 Slp:    at Microsoft.SqlServer.Configuration.SqlEngine.SqlEngineSetupPrivate.Patch(ConfigActionTiming timing, Dictionary`2 actionData, PublicConfigurationBase spcb)

2011-10-05 08:15:38 Slp:    at Microsoft.SqlServer.Configuration.SqlConfigBase.SqlFeatureConfigBase.Execute(ConfigActionScenario scenario, ConfigActionTiming timing, Dictionary`2 actionData, PublicConfigurationBase spcbCurrent)

2011-10-05 08:15:38 Slp:    at Microsoft.SqlServer.Configuration.SqlConfigBase.SlpConfigAction.ExecuteAction(String actionId)

2011-10-05 08:15:38 Slp:    at Microsoft.SqlServer.Configuration.SqlConfigBase.SlpConfigAction.Execute(String actionId, TextWriter errorStream)

2011-10-05 08:15:38 Slp: Exception: System.ComponentModel.Win32Exception.

2011-10-05 08:15:38 Slp: Source: Microsoft.SqlServer.Configuration.Cluster.

2011-10-05 08:15:38 Slp: Message: The RPC server is unavailable.

2011-10-05 08:15:38 Slp: Watson Bucket 1 

 Can anybody help me?

Answer 1

Please check if the steps mentioned in this article help.

---

Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @PradeepAdiga

Answer 2

Yes, seems similar, but in our environment, windows firewall is disabled.

Answer 3

How about the DNS entries. When you ping the nodes/virtual name did not find any issues? Does the IP addresses resolve to the correct name?

---

Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @PradeepAdiga

Answer 4

I have tried to ping the SSOCluster, and everything was fine, but I have tried to ping SQL cluster, there was no response. I have checked the DNS entries, but there are these entries

Answer 5

hi

  did u manage to solve the issue

thank you