Solved

SQL 2008 R2 in Cluster 2008 R2

Posted on 2010-09-08
6
1,371 Views
Last Modified: 2012-05-10
Hi there...

i had setup 1 pair of windows 2008 R2 cluster for SQl 2008 R2.
All installation ran sucessfull. but when i trying to upgrade SP1 or CU4, i will get this error
"There are no SQL Server instances or shared features that can be updated on this computer "
I checked already the instance was installed. Im using default instance ID. the component selection view does not show the database engine components.

I followed steps from MSSQLTips.com, i didn't see the instance name appear beside the cluster group(MSSQLSERVER). at CMS console. it is normal..? SQL2008
0
Comment
Question by:hell_angel
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 2
6 Comments
 

Expert Comment

by:avbauwel
ID: 33625394
MSSQLSERVER is the name of the default instance, so you probably did the install to a default instance instead of a named instance.

For the SQL upgrade, you'll need to do it on the node that is currently owning the cluster resource, did you check that you've started the install on the correct node?
0
 

Author Comment

by:hell_angel
ID: 33626006
HI avbauwel,

maybe a bit confuse... the upgrade i meant is SP and CU4... it not required to own the cluster resources... The sql current version is RTM... i need to upgrade it to SP1 then CU4...

pls advise..
0
 

Expert Comment

by:avbauwel
ID: 33626612
You have 2 physical machines (nodes) in the cluster.

SQL Server is installed on a  cluster resource, not on the local drives (c:\program files\...) of the nodes.

So when you try to alter the SQL Server, you need to do the install of the SP and CU on the node that is currently running the SQL server instance.
0
Use Case: Protecting a Hybrid Cloud Infrastructure

Microsoft Azure is rapidly becoming the norm in dynamic IT environments. This document describes the challenges that organizations face when protecting data in a hybrid cloud IT environment and presents a use case to demonstrate how Acronis Backup protects all data.

 

Author Comment

by:hell_angel
ID: 33628226
When the wizard goes to component selection, it doesn't show sql engine and any instance... is it normal..?
0
 

Author Comment

by:hell_angel
ID: 33660241
any others...? im managed to update CU3 onto my sql 2008 r2 RTM version... when i trying to upgrade to SP1.. it got the error..
"There are no SQL Server instances or shared features that can be updated on this computer "

need help../ urgent..
0
 

Accepted Solution

by:
hell_angel earned 0 total points
ID: 33660276
0

Featured Post

Use Case: Protecting a Hybrid Cloud Infrastructure

Microsoft Azure is rapidly becoming the norm in dynamic IT environments. This document describes the challenges that organizations face when protecting data in a hybrid cloud IT environment and presents a use case to demonstrate how Acronis Backup protects all data.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

     When we have to pass multiple rows of data to SQL Server, the developers either have to send one row at a time or come up with other workarounds to meet requirements like using XML to pass data, which is complex and tedious to use. There is a …
Hi all, It is important and often overlooked to understand “Database properties”. Often we see questions about "log files" or "where is the database" and one of the easiest ways to get general information about your database is to use “Database p…
Come and listen to Percona CEO Peter Zaitsev discuss what’s new in Percona open source software, including Percona Server for MySQL (https://www.percona.com/software/mysql-database/percona-server) and MongoDB (https://www.percona.com/software/mongo-…
Monitoring a network: why having a policy is the best policy? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the enormous benefits of having a policy-based approach when monitoring medium and large networks. Software utilized in this v…

688 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question