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 |
|
Mountain_Nerd
Starting Member
28 Posts |
 Posted - 2008-02-19 : 00:20:22
|
Perhaps someone here can give me a hand with this... I have three servers running SQL Server 2000. Two are running Windows Server 2000 SP4 with SQL 2000/SP4 and one Windows Server 2003 with SQL 2000/SP?(probably not 4). I copied the installation DVD to a network drive and successfully performed an in-place upgrade of the Windows Server 2003 machine. However, when I try to upgrade either of the other servers, I get an error indicating that I have a service pack problem. Reason: Your upgrade is blocked. For more information about upgrade support, see the "Version and Edition Upgrades" and "Hardware and Software Requirements" topics in SQL Server 2005 Setup Help or SQL Server 2005 Books Online.Service pack requirement check:Your upgrade is blocked because of service pack requirements. To proceed, apply the required service pack and then rerun SQL Server Setup. For more information about upgrade support, see the Version and Edition Upgrades topic in SQL Server 2005 Setup Help or SQL Server 2005 Books Online.My SQL 2005 media was probably released before SP4 was released because the Setup Help indicates that you can directly upgrade from SP3, but makes no mention of SP4. I can't imagine there are any migration problems with it since I can't find any reference to it as a problem on any SQL Server sites... So... I'm left wondering what my problem really is...  Any help would be appreciated. |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-02-19 : 22:45:06
|
| I did several in place upgrade on sql2k sp4 servers and worked ok, maybe os version issue. |
 |
|
|
Mountain_Nerd
Starting Member
28 Posts |
Posted - 2008-02-22 : 12:35:52
|
| Thanks for your input, but I solved my issue. The truth is, I'm ashamed to admit, that I was mistaken. After being told the SQL 2000 boxes were SP4, I finally double checked (they aren't MY servers)... and, of course, they were RTM. No upgrade path. Go figure... the error I was getting was the realerror! I should be able to upgrade now. Thanks. |
|
|
|
Ozz76
Starting Member
1 Post |
Posted - 2008-07-17 : 17:06:45
|
| What do you mean with RTM? I have Sql server 2000 version 8.00.2050running on Small Businees Server 2003 and when I try to update using the Premium Technologies disc I get the blocked error. What could be the problem?Any help will be really appreciatedOzzy |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-07-17 : 23:28:35
|
| RTM is version without service pack. What's blocked error? Can you post whole error message? Any app connected to sql during upgrade? |
|
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2009-03-31 : 05:08:58
|
| Try upgardeing to SP4 - and then upgrade. Normally , I would do a clean install and migrate databasesJack Vamvas--------------------http://www.ITjobfeed.com |
|
|
|
lpozdol
Starting Member
6 Posts |
Posted - 2009-04-15 : 13:01:08
|
| Do you have SQL2005 express installed on server? |
|
|
|
|
|
|
|
|
In-place upgrade from SQL 2000 SP4 failed