| Author |
Topic |
|
pareshmotiwala
Constraint Violating Yak Guru
323 Posts |
 Posted - 2007-05-02 : 13:40:08
|
| I downloaded the sp2a from MS website.However after running the SP it shows version 9.00.3042.00When I applied the KB933508 it brings up the version as 9.00.3050.00Is there a problem.Per this site, some time ago, the version we need to be on ideally, is 9.00.3042.01In which case which patch do I need to download and apply?RegardsParesh MotiwalaBoston, USA |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
pareshmotiwala
Constraint Violating Yak Guru
323 Posts |
Posted - 2007-05-04 : 12:16:40
|
| I will be installing this on a active/passive cluster.any thing that I need to know.I have successfully installed it on three stand alone machines.RegardsParesh MotiwalaBoston, USA |
 |
|
|
Kristen
Test
22859 Posts |
Posted - 2007-05-04 : 12:30:13
|
| Thanks for that Tara. I had no idea that it was quite such a minefield. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-05-04 : 12:43:31
|
| On clusters, you need to apply the service pack to each node so that the client tools get updated as well. So run it from one node and have it apply it to all instances plus the tools, then run it again on the other node and have it apply it to the tools there. You actually won't need to select anything during each installation as it knows what it needs to update.Tara Kizerhttp://weblogs.sqlteam.com/tarad/ |
|
|
|
pareshmotiwala
Constraint Violating Yak Guru
323 Posts |
Posted - 2007-05-04 : 13:22:26
|
| it is failing on SQL Server Database Services and Analysis Service SP2 upgrade. It successfully did rest of them.First I had logged in as a local admin on node1, that failed, now I used the Domain Account, the SQLServer Service Account to log into it and rerun the sp2 install. It still fails.RegardsParesh MotiwalaBoston, USA |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-05-04 : 13:31:06
|
| You'll need to check the logs to see why it is failing. We certainly can't help without the error from them. I believe it should have told you which file the error would be in.Here's part of the path:C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOGTara Kizerhttp://weblogs.sqlteam.com/tarad/ |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-05-04 : 13:51:03
|
| Tried with cluster service account? |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-05-04 : 14:06:54
|
| You don't need to switch accounts. You just need to run it with a domain account that has local admin privileges.We need to see the error in the logs in order to help. We can't make any suggestions as to what to try until we see the errors.Tara Kizerhttp://weblogs.sqlteam.com/tarad/ |
|
|
|
pareshmotiwala
Constraint Violating Yak Guru
323 Posts |
Posted - 2007-05-04 : 14:10:39
|
| yep I did use the Domain Service Account. which is a local and domain admin.This is the error:"MSP Error: 1920 Service 'SQLWriter' (SQL Writer) failed to start" There is a posting on MSDN, it says that somehow during the SP1 install SQL Writer service gets uninstalled, this is what creates the problem.If you browse through to the CD there is a file called SqlWriter.msi. Just install it, start the service and it works. This was a huge gotcha...and...it did not let me install the hotfix on the passive node.RegardsParesh MotiwalaBoston, USA |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-05-04 : 14:14:45
|
| Please post the article so that others can view this information if they run into a similar problem. Tara Kizerhttp://weblogs.sqlteam.com/tarad/ |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-05-04 : 14:15:33
|
quote:
Originally posted by pareshmotiwala
yep I did use the Domain Service Account. which is a local and domain admin.
That is highly not recommended. Service accounts should not be domain admins.Tara Kizerhttp://weblogs.sqlteam.com/tarad/ |
|
|
|
pareshmotiwala
Constraint Violating Yak Guru
323 Posts |
|
|
|
SQL 2005 Service Pack 2A