May 18, 2006 at 4:02 am
Hi, I have installed SQL 2000 Server on my machine with Default Instance and a named instance viz., Instance1.I tried upgrading the Database Engine of the Default instance to SQL 2005 Server (using the 2005 Set up CD). It was upgraded successfully. I tried upgrading the named instance's Database engien from SQL 2000 to SQL 2005 server. After selecting the Database Engine component and clicking Next, I got the following error: Name: Microsoft SQL Server 2000 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. Here are my machine details: Processor: PIII Processor with RAM: 512 MB OS: Windows 2003 Server SP1 SQL2000: Enterprise edition with SP3 sql2005: Enterprise edition Why is the upgrade not happening with respect to named instance whereas it si happening with Default instance? Thanks, Sandhya |
May 19, 2006 at 7:44 am
Service Packs have to be applied to each instance. Is it possible that the default instance was upgraded with the latest service pack and the named instance hasn't?
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply