I am running SQL Server 2019 SSRS on Windows Server 2019 and want to connect via a secure connection.
I have obtained an SSL Certificate which approves my domain ssrs.***.co.uk - this domain already works fine on an unsecured connection.
I have imported the certificate into the certificate repository on my server, SSRS seems to only look at the Personal/Certificates folder although I have also installed it in Trusted Root Certification Authorities (which is where I thought it was supposed to go).
When I set up the Web Service URL in Report Server Configuration Manager and add an HTTPS binding, it sees the certificate in the Personal repository and recognises the correct domain.
When I add it, I get the following messages:
1) The specified url was unexpectedly reserved. The previous reservation has been overridden.
The specified url may have been reserved by another product.
2) Reserving url https://ssrs.***.co.uk:443
The url was successfully reserved.
3) Create certificate binding.
We were unable to create the certificate binding.
I suspect message 3 is the problem but I have no idea what to do about it.
When I run "netsh http show sslcert" there are no SSL Certificate Bindings on my machine.
I don't have IIS installed (and nor do I want or need it).