Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1394
  • Last Modified:

SQL 2008 R2 in Cluster 2008 R2

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
hell_angel
Asked:
hell_angel
  • 4
  • 2
1 Solution
 
avbauwelCommented:
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
 
hell_angelEngineerAuthor Commented:
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
 
avbauwelCommented:
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
Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

 
hell_angelEngineerAuthor Commented:
When the wizard goes to component selection, it doesn't show sql engine and any instance... is it normal..?
0
 
hell_angelEngineerAuthor Commented:
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
 
hell_angelEngineerAuthor Commented:
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

  • 4
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now