troubleshooting Question

Problem setting up https in SQL Server Reporting Services 2019

Avatar of Paul Donson
Paul DonsonFlag for United Kingdom of Great Britain and Northern Ireland asked on
Microsoft SQL ServerSSL / HTTPSMicrosoft Server OSSSRSWindows Server 2019
7 Comments1 Solution10 ViewsLast Modified:
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).

Thanks


Paul.

Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 7 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 7 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros