Jul
4
2013

Microsoft SQL Server 2008 R2 BPA — Error 1722

A bit of a head-scratcher when trying to install the SQL Server 2008 R2 Best Practice Analyzer.

The Baseline configuration analyzer installed just fine, and WinRM / PS2.0 was installed, so no prereqs were missing.

However, when running the BPA installer, it would just flash a powershell window and fail.
I could run¬†msiexec /i {MSI} SKIPCA=1 to install it, but it wouldn’t initiate.

A little bit of digging led me to enable-psremoting cmdlet, which failed (loads of WinRM error messages).

Event log gives:
The kerberos client received a KRB_AP_ERR_MODIFIED error from the server host/computer.domain.corp.  The target name used was HTTP/computer.domain.corp.

So that indicates that there something hokey with the SPNs.

There is a little tool called “setspn.exe”. If you run setspn.exe -L (computername); it will list all SPNs registered to that machine.

In my case this gave me:

MSSQLSvc/computer.domain.corp:1433
MSSQLSvc/computer.domain.corp
MSSQLSvc/computer.domain.corp:SQLEXPRESS
WSMAN/computer
WSMAN/computer.domain.corp
HOST/computer
HOST/computer.domain.corp

So no http or https, which is what is used for WinRM.

Quick fix:

setspn -A https/computer.domain.corp COMPUTER
setspn -A http/computer.domain.corp COMPUTER

Enable-Psremoting again, and thar she blows!

Wonderful isn’t it? Couldn’t have done this without google, I admit.

Leave a comment

*