• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1498
  • Last Modified:

SQL 2000 to 2005 Upgrade Problem

I am tryint to upgrade my SQL 2000 Server.

My environment is Windows AD 2003 Domain. The SQL 2000 with Service Pack 4 Box is on a Windows Member server 2003.

When I launch the setup and sellect the instance to upgrade, I get this error: Upgrade Advisor Returned -1

Error Message:
LinkID                      20476
Product Name         Microsoft SQL Server
Product Version      9.00.1399.06
Message Source    setup.rll
Message ID             SQLSetup90
EvtType                   29552

Any ideas?
Many thanks,
Prince
0
Caxxiux
Asked:
Caxxiux
1 Solution
 
MohammedUCommented:
Post the summary.txt file to if there are any other errors...
0
 
milduraitCommented:
Caxxiux,
How many user databases on the server?
Mildura IT
0
 
CaxxiuxAuthor Commented:
To Elaborate,

I created a test environment with the same versions of SQL 2000 SP4. I then did a backup of the live environment and restored it to the same-named instance on my test environment successfully. Besides the new database instance I recovered, the rest are just defaults including: Master, Model, MSDB, Northwind, Pubs & TempDB.

I then proceeded to try upgrading my test environment to SQL2005. Both systems are in the same domain and are functioning optimally. See the attached JPEG File for a screenshot of the errors I am getting. I get a .NET 2.0 error in the APP log on event viewer. nothing else partaining to SQL

Many thanks,
Prince
SQL2000UpgradeErrors.JPG
0
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
CaxxiuxAuthor Commented:
Summary files
0
 
Bob LearnedCommented:
That looks like a "file not found" exception with .NET 2.0.  Do you have .NET 2.0 SP1 installed?
0
 
CaxxiuxAuthor Commented:
I figured out the problem.

I had all the latest .NET version installed including v2.0 SP1. The fix was to uninstall all the .NET versions and reinstalling .NET 2.0 SP.

Case Closed.

Thanks for all your help folks.
0
 
tpeckaCommented:
What is .NET 2.0 SP?  The name or version is incomplete.  I need to fix this too.  Please help.
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now