Solved

Trying to upgrade a named instance of SQL 2000 SP4 to SQL 2005

Posted on 2010-08-18
1
325 Views
Last Modified: 2012-05-10
When I run the installation wizard, I select my instance from the list, and everything looks fine. Then the SQL server setup "UpgradeAdvisor" gives me an error of -1. Then it just stops, and I am not able to upgrade the named instance. There default instance is SQL 2005, however I had to install this named instance for a legacy app. Now we want to upgrade to 2005 and we are having issues. Any ideas?
0
Comment
Question by:sqlagent007
1 Comment
 
LVL 1

Accepted Solution

by:
sqlagent007 earned 0 total points
Comment Utility
I removed .net 2.0, then let the SQL server wizard install it, after that it worked.
0

Featured Post

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

If you having speed problem in loading SQL Server Management Studio, try to uncheck these options in your internet browser (IE -> Internet Options / Advanced / Security):    . Check for publisher's certificate revocation    . Check for server ce…
Introduction This article will provide a solution for an error that might occur installing a new SQL 2005 64-bit cluster. This article will assume that you are fully prepared to complete the installation and describes the error as it occurred durin…
It is a freely distributed piece of software for such tasks as photo retouching, image composition and image authoring. It works on many operating systems, in many languages.
Illustrator's Shape Builder tool will let you combine shapes visually and interactively. This video shows the Mac version, but the tool works the same way in Windows. To follow along with this video, you can draw your own shapes or download the file…

771 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now