| Author |
Topic |
|
enjensensnap
Starting Member
2 Posts |
 Posted - 2010-04-20 : 09:01:52
|
| Hello,I recently "inherited" support for a group of SQL Server 2005 Standard servers. I need to upgrade one of the 2003 Server Clusters(two node)from RTM to SP3. Should I be able to jump straight to SP3? I tried it awhile ago(and I appologize for not remembering specifics) but wasn't able to. Can someone point me to a reference which shows the upgrade path or can perhaps recommend some tips?Thanks much. |
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2010-04-20 : 10:03:22
|
| Yes, you should be able to jump straight to SP3. The service packs are cumulative, SP3 has all the fixes from SP2 and SP1 in it.--Gail ShawSQL Server MVP |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2010-04-20 : 12:48:13
|
| After you install SP3, you need to apply the hotfix for the security vulnerability that exists in SP3. Since there have been hundreds of bug fixes for SP3 already, I'd suggest installing the latest cumulative update package which is currently CU9. CU9 includes the fix for the security vulnerability plus all of the other fixes. If you aren't comfortable with such a new CU, then install CU8 or CU7. You could alternatively install just the fix for the security vulnerability, but that wouldn't be my recommendation.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog |
|
|
|
enjensensnap
Starting Member
2 Posts |
Posted - 2010-04-21 : 13:47:02
|
| Thanks much you two! One last question then... The SQL services are running under a different account than the one I used to attempt the upgrade. Both accounts are in the local admin group. I"m assuming then I must login to the server with the account the SQL services are running under?Thanks again for your input! |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
ragsy
Starting Member
2 Posts |
Posted - 2010-07-13 : 09:56:34
|
| I attempted to re-install the SP3 to my SQL Server 9.0.1399 expecting the version to change to 9.0.4035. The SP seemed to have run ok, but it didnt change the version. Can someone assist me ? |
|
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2010-07-13 : 10:13:17
|
Did you reboot?
No, you're never too old to Yak'n'Roll if you're too young to die. |
|
|
|
ragsy
Starting Member
2 Posts |
Posted - 2010-07-13 : 10:39:00
|
| sure did... i am stumped... |
|
|
|
rdjabarov
Starting Member
8 Posts |
Posted - 2010-07-13 : 12:07:33
|
| try to move SQL group to another node, check the version there, check error logs. If everything is clean - try to install SP3 from that node."The data in a record depends on the Key to the record, the Whole Key, and nothing but the Key, so help me Codd." |
|
|
|
|
Upgrade from 9.0.1399(RTM) to 9.0.4035