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

• Imran-Yasir

  SSCrazy

  Points: 2044

  More actions

  August 30, 2010 at 12:08 pm

  #144794

  Hi,

  I am getting this error [Error: "SQL BPA command line has encountered a problem and needs to close"] while running SQL Server upgrade advisor for upgrade from sql 2000 to sql2005.

  I faced the same problem few months ago but fixed it with creating a new directory called BPAClient

  at C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\BPA\ then copied the BPAClient.dll form the C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\BPA\Bin directory into the new directory at C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\BPA\BPAClient then I continued with the install and it worked.

  But now i tried many times , uninstall sql2k, re-installed it again, copied files from another server but it does not work,every time getting the same error while runnin Upgrade Advisor.

  I dont know if i have un-installed any wrong file while doing unintall sql server from add/remove program.

  FYI:I dont have installed visual studio .net 2003.

  Thanks

  Irfan

• Steve Jones - SSC Editor

  SSC Guru

  Points: 736160

  More actions

  August 30, 2010 at 12:16 pm

  #1213880

  Some notes here: http://sqlblog.com/blogs/aaron_bertrand/archive/2010/08/25/sql-server-2008-r2-best-practices-analyzer.aspx as Aaron Bertrand had some issues.

  Do these help:

  http://social.msdn.microsoft.com/Forums/en-US/sqlsetupandupgrade/thread/2a5f460b-8684-4510-8fcb-1e9d9786baff

  http://www.masykur.web.id/post/Resolving-SQL-BPA-Command-Line-Problem-when-Running-SQL-Server-2005-Upgrade-Advisor.aspx

• Donna Collins

  SSC Enthusiast

  Points: 199

  More actions

  May 26, 2015 at 10:02 am

  #1800628

  Thansk you Steve, the link http://social.msdn.microsoft.com/Forums/en-US/sqlsetupandupgrade/thread/2a5f460b-8684-4510-8fcb-1e9d9786baff

  worked for me.