Ahmad Masykur

Share your knowledge although one function!

About the author

Ahmad Masykur is a Software Architecture Engineer at PT. Freeport Indonesia Jakarta Indonesia.
In this blog, I share things of interest to me. Most topics are likely to be related to software development, but don't hold me to it.

Certificates



Awards


Powered by

Widget Prayer Time not found.

There is an error in XML document (4, 16278).X

Page List

Validators


Ahmad Masykur

Resolving SQL BPA Command Line Problem when Running SQL Server 2005 Upgrade Advisor

Currently, I want to upgrade our SQL Server 2000 databases to SQL Server 2005. The first step is running Microsoft SQL Server Upgrade Advisor. I was installed this tool on my computer and no error in installation. When I running this tool and try to analyze database engine, it returning error message:

"SQL BPA command line has encountered a problem and needs to close. We are sorry for the inconvenience."

I confused about this error because I was use this tool a few year ago without any problems. What is the problem, my database, my account or the tool problem? I'm forget that used SQL Server 2005 Upgrade Advisor with Service Pack 1 that different with previous version that was used. I think it the tool problem. I'm try to look at the forum that any suggestions. One of the suggestions is to registering BPAClient.dll to the GAC. It resolve the problem for me.

To resolve this problem, follow the instructions below.

  1. Open Visual Studio 2005/2008 Command Prompt
  2. Change directory to C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\BPA\bin or based on your software installation path.
  3. Type following command:
    C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\BPA\bin>gacutil /i BPAClient.dll

I hope this information is helpful.


Categories: SQL Server | Tips
Permalink | Comments (4) | Post RSSRSS comment feed

Comments

giolicious United States | Reply

Friday, January 30, 2009 11:41 PM

giolicious

do you know where can i download Microsoft SQL Server Upgrade Advisor?

Dale United States | Reply

Saturday, February 21, 2009 8:18 AM

Dale

I am experienceing this error when trying to install SQL 2005 SP3 specifically on an instance of Reporting Services.

There is no Visual Studio installed to access that GAC utility.  Any other methods for registering the BPAclient.dll?

Dale United States | Reply

Saturday, February 21, 2009 11:22 AM

Dale

...and if you don't have Visual Studio installed?   any other ways to regiser that .dll to the GAC?

Ahmad Masykur Indonesia | Reply

Tuesday, April 14, 2009 11:24 AM

Ahmad Masykur

If you don't have Visual Studio installed, you can use gacutil.exe from .NET Framework SDK placed in C:\Program Files\Microsoft SDKs\Windows\v6.0A\bin

Add comment




  Country flag

biuquote
  • Comment
  • Preview
Loading