THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |
in Search

Buck Woody

Carpe Datum!

SQL Server Best Practices problem with this Windows Installer Package

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.

    Published Monday, July 12, 2010 8:13 AM by BuckWoody

    Comment Notification

    If you would like to receive an email when updates are made to this post, please register here

    Subscribe to this post's comments using RSS


    No Comments

    Leave a Comment


    About BuckWoody

    This Blog


    Privacy Statement