Solved

SQL 2008 R2 in Cluster 2008 R2

Posted on 2010-09-08
6
1,360 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
[Webinar] Disaster Recovery and Cloud Management

Learn from Unigma and CloudBerry industry veterans which providers are best for certain use cases and how to lower cloud costs, how to grow your Managed Services practice in IaaS clouds, and how to utilize public cloud for Disaster Recovery

 

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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
Video by: Mark
This lesson goes over how to construct ordered and unordered lists and how to create hyperlinks.
Both in life and business – not all partnerships are created equal. As the demand for cloud services increases, so do the number of self-proclaimed cloud partners. Asking the right questions up front in the partnership, will enable both parties …

920 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

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now