Clicking on Publish to Pyramid Throws an Exception
ISSUE
When using the button: “Publish to Pyramid” you receive exception or the following message “The Pyramid Analytics service you are trying to connect to, can’t be authenticated “
Solution
Check that you have a HTTP SPN set for your BI Office website.
This needs to be checked for the BI Office webserver itself or for the AD user running the Pyramid application pools (if you have changed the BI Office application pools to run as an AD user).
- If the BI Office application pools are running under an AD user please do the following:
- Run the following command in the command prompt:
SETSPN –L domainname\ADusername - If you do not see any HTTP SPN’s set, run the following commands from a windows command prompt to set them:
SETSPN –S HTTP\pyramidwebsite domainname\ADusername
SETSPN –S HTTP\pyramidwebsite.FQDN domainname\ADusername
- Run the following command in the command prompt:
- If the application pools are running under anything other than an AD user:
- Run the following command in the command prompt:
SETSPN –L BIOFFICESERVERNAME$ - If you do not see any HTTP SPN’s set, run the following commands from a windows command prompt to set them:
SETSPN –S HTTP\pyramidwebsite BIOFFICESERVERNAME$
SETSPN –S HTTP\pyramidwebsite.FQDN BIOFFICESERVERNAME$
- Run the following command in the command prompt:
The delegation of the BI Office server(s) should also be checked to make sure they are enabled for delegation. If the BI Office services are running under an AD user the delegation should be checked on this user, otherwise the server itself. The checking of the delegation is done on Active directory.
Please see attached Kerberos and delegation guide for further details (pages 6 and 7)