I got following error message while performing upgrade from SQL Server 2000 to SQL Server 2005.
SQL BPA command line has encountered a problem and needs to close.
After little googling i found a solution that
- Go to C:Program FilesMicrosoft SQL Server90Setup BootstrapBPA
- Make folder BPAClient
- Go to C:Program FilesMicrosoft SQL Server90Setup BootstrapBPAbin
- Copy BPAClient.dll
- Paste it in to the newly created directory BPAClient on following path C:Program FilesMicrosoft SQL Server90Setup BootstrapBPABPAClient
To accomplish the above task I have created a cmd script in .bat file. On double click the batch script will run and above task will be performed. After these small steps upgrade process will go on without any problem. As a follow up to this post i will try to list here some reasons and background for this error message.