Adding SQL Permissions to Certificates in Windows

 Faced with these certificate permissions how do you add the last two?

The correct syntax is to add each of these.

NT SERVICE\MSSQLSERVER
NT SERVICE\SQLSERVERAGENT

Jet Reports Jet Service Tier Error

 Jet Service Tier Error

The SSL certificate could not be validated. The following error was received.

Could not establish trust relationship for the SSL/TLS secure channel with authority 'host.example.com:7090'.

I tried using the Jet Services Administration Shell, this ran and immediately closed the PowerShell window, I found the script was missing that the shortcut calls.

1. I checked for a binding using netsh: netsh http show sslcert
2. I removed the binding: netsh http delete sslcert ipport=0.0.0.0:7090
3. I added the new binding using the appid from step one: netsh http add sslcert ipport=0.0.0.0:7090 certhash=my-cert-hash appid={appid from step 1}

I was then able to open Jet Administration Console and connect.