Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 Development Tools
 Reporting Services Development
 Secure Reporting Services with SSL (https://)

Author  Topic 

e.heijmans@12move.nl
Starting Member

10 Posts

Posted - 2010-04-13 : 07:19:58
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.
   

- Advertisement -