Solved

SQL 2008 R2 in Cluster 2008 R2

Posted on 2010-09-08
6
1,368 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
  • 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
Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

 

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

Free eBook: Backup on AWS

Everything you need to know about backup and disaster recovery with AWS, for FREE!

Question has a verified solution.

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

Naughty Me. While I was changing the database name from DB1 to DB_PROD1 (yep it's not real database name ^v^), I changed the database name and notified my application fellows that I did it. They turn on the application, and everything is working. A …
Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
Email security requires an ever evolving service that stays up to date with counter-evolving threats. The Email Laundry perform Research and Development to ensure their email security service evolves faster than cyber criminals. We apply our Threat…

756 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