Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

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

SQL Server 2000 > 2005 Ugrade Problem


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!

1 Solution

Featured Post

 [eBook] Windows Nano Server

Download this FREE eBook and learn all you need to get started with Windows Nano Server, including deployment options, remote management
and troubleshooting tips and tricks

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