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.