How do I add a certificate to reporting services?

Question

On the SQL Server open the Report Server Configuration Manager. Switch to Web Service URL. Click “Advanced” and click Add under HTTPS on the bottom of the window. Choose the certificate from the list and Click OK. The Reporting Service are now configured to use both HTTP and HTTPS traffic.

How do you configure SSRS to use SSL certificate?

How to Setup SSRS to Use HTTPS – Part 11Install the IIS Management Console.2Import the server certificate from your domain certificate authority.3Prepare SSRS for the server certificate.4Setup SSRS to use the server certificate.5Test the SSRS website.6Clean-up.

How do I update my SSRS certificate?

Updating SSL Certificate on SSRS Server1Get the CSR¶ (1) If this is a first-time creation, use your favorite CSR generation tool to generate the CSR. ... 2Provision new SSL certificate¶ (1) Using the above CSR, provision a new SSL certificate from your favorite provider. ... 3Install the Certificate in the Certificate Store¶

How do I grant access to reporting services?

Click Home, and then click Folder settings. From there, create a new role assignment so that you can grant access to the “Content Manager” role. To grant access so that the user can edit or build reports, you can give them additional permissions in SSRS, such as the Report Builder permission to the Home folder.

How do I add reporting services to an existing SQL Server?

Install your report server1Find the location of SQLServerReportingServices.exe and launch the installer.2Select Install Reporting Services.3Choose an edition to install and then select Next. ... 4Read and agree to the license terms and conditions and then select Next.

Expert · Answer