?
Solved

SQL 2008 R2 in Cluster 2008 R2

Posted on 2010-09-08
6
Medium Priority
?
1,372 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
NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!

 

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

Enroll in August's Course of the Month

August's CompTIA IT Fundamentals course includes 19 hours of basic computer principle modules and prepares you for the certification exam. It's free for Premium Members, Team Accounts, and Qualified Experts!

Question has a verified solution.

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

Audit has been really one of the more interesting, most useful, yet difficult to maintain topics in the history of SQL Server. In earlier versions of SQL people had very few options for auditing in SQL Server. It typically meant using SQL Trace …
In this article I will describe the Backup & Restore 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.
In this video, Percona Director of Solution Engineering Jon Tobin discusses the function and features of Percona Server for MongoDB. How Percona can help Percona can help you determine if Percona Server for MongoDB is the right solution for …
How to fix incompatible JVM issue while installing Eclipse While installing Eclipse in windows, got one error like above and unable to proceed with the installation. This video describes how to successfully install Eclipse. How to solve incompa…

765 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