Secure Reporting Services with SSL (https://)

• Ellen Heijmans

  SSC Eights!

  Points: 840

  More actions

  April 13, 2010 at 5:31 am

  #217746

  For one of our clients we've made a secure site by linking it to a certificate (therefore accesible with https://). But now I have problems with actions in my reports. In some reports you can cllick an item, and a page of the site will be opened. But because RS is not secure but the site is, problems arise.

  In RS, through Configuration Manager, I've linked the same certificate that I use for the site. An URL was added for https://. But, when I click this URL to go to the secure report server, it asks me for a user name and password. When I try to log on with my administrator account for the server, I don't get access. RS keeps prompting me to log on. The other URL voor Report Manager, the unsecure one, gives no problems.

  When I try to open the report through my site (a page with an report viewer links to the secure report manager) I get an error message about authorization.

  Who knows how to configure RS to work with SSL? Which user account do I have to use to get access to the secure RS? I work with SQL Server 2008, so there is no site in IIS that I can configure.

• surbajit.shehri

  SSC Journeyman

  Points: 88

  More actions

  November 19, 2010 at 8:46 am

  #1253104

  Hi,

  There is a connection level setting in the config file;

  http://msdn.microsoft.com/en-us/library/ms345223(v=SQL.90).aspx

  Best of luck

  Regards