A “Gotcha” is a “got you” or problem when you try to do something. Last week I blogged that I would be installing the Best Practices Analyzer for SQL Server 2008 R2. And I did – but not without a little trouble. I ran into an error that said:

There is a problem with this Windows Installer Package. A program run as part of the setup did not finish as expected. Contact your support personnel or package vendor.

Since I AM the package vendor, I had to look elsewhere. :) There’s actually already a blog entry from the CSS (support) engineers (find it here) but that didn’t work the same way for me. I ended up having to reverse the order of their instructions a little, so you can try this out on your test system if you’re having this issue to see which one works for you. This has to do with a domain security issue, specifically in Kerberos, so you’ll probably face it more often with a standalone server (as my test server is) than on a proper domain.

If their correction steps don’t work for you, try this – open a PowerShell window on your system in an elevated mode. Then run these two commands:

  • Enable-PSRemoting
  • winrm set winrm/config/winrs `@`{MaxShellsPerUser=`"10`"`}

From that same window, change to the directory where you’ve downloaded the BPA tool and run this command:

  • msiexec /i <MSI Name> SKIPCA=1

As mentioned in the other blog entry, the <MSI Name> will either be SQL2008R2BPA_Setup32.msi or SQL2008R2BPA_Setup64.msi depending on your platform.

Once I performed these steps, I was good to go. Again, only on a test system, folks.