Second instace of RS not working correctly

Question

Post reply

Second instace of RS not working correctly

rozdelisi

Newbie

Points: 3
More actions
September 27, 2010 at 1:05 pm

#228838

Background:
Need to access Reporting Services from outside the firewall. So, the IT department installed second instance of RS on a box outside the firewall and pointed it to the Report Server database on the SQL Server box inside the firewall. The application that runs the reports uses Forms Authentication and appears to working correctly. It picks up the "cookie" from RS and calls the report with the cookie in the header.
The Problem:
The call to programmatically login to RS works...but when the report is requested, a page comes up and asks the user to enter the username and password for the "data source". Once a "sql server user" is entered, and the user clicks on the "View Report" button, the report comes up. Why is RS asking for credentials for the report's data source???

Viewing 5 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Luke L SSC-Dedicated Points: 35547 More actions · Answer 1

Check to make certain the datasource has the appropriate credentials stored in it's definition.

-Luke.

To help us help you read this[/url]For better help with performance problems please read this[/url]

rozdelisi Newbie Points: 3 More actions · Answer 2

Yeah, that's the first thing we checked. The credentials are there and everything checks out when we run the report through the ReportManager. It only prompts us for credentials coming from the second instance of RS...which is outside the firewall.

Luke L SSC-Dedicated Points: 35547 More actions · Answer 3

First I'm slightly confused by this statement...

everything checks out when we run the report through the ReportManager. It only prompts us for credentials coming from the second instance of RS

Is this report manager on the first instance or the second, or perhaps I'm mis-understanding your configuration.

Second, since instance 2 is outside of your firewall, and I would hope extremely well locked down, have you looked at the firewall logs, as well as the security logs of the first instance and second instance? Is there a port that's currently blocked that needs to be opened? Anything noting a dropped connection or other such issue?

This may also have something to do with multiple hops using Windows Auth? Brian Kelly go into it in this post a bit. I'm not sure if this also applies to forms auth, but it may be worth examining. http://www.sqlservercentral.com/Forums/FindPost243540.aspx

-Luke.

To help us help you read this[/url]For better help with performance problems please read this[/url]

rozdelisi Newbie Points: 3 More actions · Answer 4

Thanks for the ideas Luke...I haven't checked the logs...we do have it locked down well...but I will take a look at the link....more later.