Binding the Certificate

This procedure is required if the BI Service is set up in HTTPS when installing the SEI Server. For example, it could be required if the BI Service is exposed to the Internet when Excel Add-in is used.

To bind the certificate for the BI Service:

  1. Press the Windows key + R to open the Run window.
  2. Enter powershell and press the Enter key.
  3. Copy and paste this command and press the Enter key:

    Get-ChildItem -path cert:\LocalMachine\My 
  4. Copy the Thumbprint of your certificate (it's the first line) and paste it to a notepad.

  5. Back to the PowerShell window, copy and paste this command and press the Enter key:

    netsh http add urlacl url=https://+:4504/ user="EVERYONE"

    Note

    4504 is the BI Service application port configured during the basic or advanced installation.

    The User value depends on the language of the server; for example: TODOS in Spanish and TOUT LE MONDE in French.

    You can find more information here.

  6. Copy and paste this command to a notepad (the same notepad where you put the thumbprint):
    netsh http add sslcert ipport=0.0.0.0:4504 certhash=xxxxxxxxxxxxxxxxxxxxxxxxx appid={00000000-0000-0000-0000-000000000000}
  7. Replace the value of the certhash (xxxxxxxxxxxxxxxxxxxxxxxxx) with the thumbprint (7EC...A9 in our example).
  8. In the PowerShell window, enter netsh then press the Enter key.
  9. Enter http then press the Enter key.
  10. Paste the rest of the command line (add sslcert... 0}) and press the Enter key.

    Note

    You need to break this command line like this otherwise it won't work like shown in the screen capture below.

Other Useful Commands

Show reserved ports:

netsh http show urlacl

 

Show certificate bindings:

netsh http show sslcert

 

Delete certificate binding:

netsh http delete sslcert ipport=0.0.0.0:4504

 

Delete reserved port:

netsh http delete urlacl url=https://+:4504/