• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1504
  • 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
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

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