Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
pareshmotiwala
Constraint Violating Yak Guru
323 Posts |
 Posted - 2006-12-22 : 13:57:53
|
| Anybody have luck with this?It fails everytime on Database services?in other words, we have two nodes 1 and 2 clustered.I am installing SQL SP1 on Node 1, but it keeps failing.No clue why? |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-12-22 : 14:01:53
|
| Yes we have sp1 installed on SQL Server 2005 in a cluster environment in production. Our cluster has 4 nodes. We didn't have any issues installing it on any of the 11 instances. Once you get it working, make sure to also install it on the other node otherwise the client tools don't get updated, which means no database mirroring.Tara Kizer |
 |
|
|
pareshmotiwala
Constraint Violating Yak Guru
323 Posts |
Posted - 2006-12-22 : 14:29:52
|
| Hi Tara, thanks for the input, but the database services is the main place where it does not apply the sql service pack to? |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-12-22 : 14:45:21
|
| It applies it to both the server and the client. The main part is the server. sp1 should be installed on all machines where the client tools are installed also.Tara Kizer |
|
|
|
pareshmotiwala
Constraint Violating Yak Guru
323 Posts |
Posted - 2006-12-22 : 14:51:47
|
| pardon my pain, but do I understand that the SQL SP1 needs to be applied individually to both?But still why would it fail on the active node? do both nodes need to be active? |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-12-22 : 15:00:39
|
| Yes it needs to be applied to both nodes.You haven't posted an error, so it's hard to help.Tara Kizer |
|
|
|
pareshmotiwala
Constraint Violating Yak Guru
323 Posts |
Posted - 2006-12-22 : 15:18:39
|
| Hi Tara,Figured out the problem.I had used Remote Desktop with local admin account to run the install. Once I used the Domain Admin's account, it completed without any hassles.Thank you for your patience...RegrdsPareshHave a happy new year. |
|
|
|
|
|
|
Service Pack 1 on Clustered SQL 2005