I am trying to figure out how to request a certificate for SSRS 2008
installed on W2K3. With SSRS 2005 I would use IIS functionality to generate
a CSR that our certificate vendor would use to issue the certificate.

I thought that since SSRS 2008 uses http.sys, there would be some utility
that would allow the creation of the CSR like that in IIS.

Does anyone know how to do this?

"BrianB" wrote:


1. Find a server with IIS and go through the normal routine of requesting a
CSR with the Certificate Wizard.
2. Obtain the certificate through your normal means (for me that meant
submitting the CSR through our certificate vendor)
3. Assign the certificate to the web site through IIS using the Certificate
Wizard.
4. Export the certificate to a .pfx file using the Certificate Wizard and
copy the file to the report server.

5. On the SQL Server Reporting Server 2008, open a blank MMC console (start
->run -> mmc)
6. Add the Certificates snap-in in the console (File -> add/remove snap-in)
(use Local Computer when adding the Certificates snap-in)
7. Right click on the dialog and click "import" and import the certificate
into the certificate store. I used the personal keystore, but have read this
may not provide enough permissions in all situations.

8. Open the Reporting Serivices Configuration Manager. The certificate
should now show up in the drop down boxes for the Report Manager/Server URL.

Hope this helps!