Solved

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

Posted on 2010-08-18
1
330 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
ID: 33471728
I removed .net 2.0, then let the SQL server wizard install it, after that it worked.
0

Featured Post

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

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…
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
In an interesting question (https://www.experts-exchange.com/questions/29008360/) here at Experts Exchange, a member asked how to split a single image into multiple images. The primary usage for this is to place many photographs on a flatbed scanner…
I've attached the XLSM Excel spreadsheet I used in the video and also text files containing the macros used below. https://filedb.experts-exchange.com/incoming/2017/03_w12/1151775/Permutations.txt https://filedb.experts-exchange.com/incoming/201…

856 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