Upgrading SQL 2000 to 2005…..I know

Believe it or not, this night, I upgraded a SQL Server from 2000 to 2005.  During the upgrade, the following error was presented, luckily before any files were written:

Turns out, J-F Tourigny (thanks very much!) had the same problem when trying to upgrade from MSDE 2000 to SQL Express 2005.

“When trying to upgrade MSDE 2000 to SQL Express 2005, the installation would fail during the upgrade advisor with error -1.  In Application log, Event 5000 was generated for process “bpacmd.exe”.  A quick search on the Internet revealed that the process is looking for BPAClient.dll in the wrong directory. Creating folder %ProgramFiles%\Microsoft SQL Server\90\Setup Bootstrap\BPA\BPAClient and moving the DLL into this folder solved the issue”

The same solution worked for me when upgrading SQL from 2000 to 2005.

Leave a comment

Filed under Windows Server

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s