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!