SQL Server 2000 > 2005 Ugrade Problem

Posted on 2008-11-07
Last Modified: 2012-06-27

I am in the middle of upgrading a server from SQL 2000 to 2005 and I'm having a problem upgrading the database engine/service.

I tick the box to select SQL Server Database Services 8.00.2039, setup then proceeds to an authentication screen (SQL or Windows). I tried Windows first, but it throws up the following error (as does the SQL authentication).

"SQL BPA command line has encountered a problem and needs to close".

When I click close and re-try the authentication, the following error appears:

"UpgradeAdvisor returned -1. Error message:" (no error message displays).

I just wondered if anyone else had come across this, as this is the final step in my upgrade before moving onto final database testing which I need completed and released within  2 weeks.

Thanks in advance!

Question by:robsamuel2k8
    1 Comment
    LVL 11

    Accepted Solution


    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Threat Intelligence Starter Resources

    Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

    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.
    Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
    Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
    Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties

    737 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

    22 Experts available now in Live!

    Get 1:1 Help Now