Report Builder load failure on WAN-side of firewall

All,

Can anyone shed some light on this problem:

Using the same laptop and credentials I can successfully load Report Builder ONLY from the LAN-side of the firewall. However, if I reconnect using my Sprint AirCard I cannot load Report Builder; I get the now infamous "The remote server returned an error: (401) Unauthorized."

What ports are used by Reporting Service?

Thanks,

Brian

I'm not sure what's up with the AirCard connection, but I think I can explain the WAN/LAN difference. On the LAN side your default Windows credentials are sufficient to access the Report Builder files at http://hostname/reportserver/reportbuilder. On the WAN side, Windows integrated authentication doesn't work, so you get no Report Builder. The reason is that ClickOnce (which is responsible for downloading the application files to the client) cannot prompt for credentials, and it doesn't get any from IE, so if default Windows credentials don't work, you get nothing. The solution is to configure IIS on the report server to allow anonymous access to the virtual directory I mentioned above.

|||Does this work with port 443 also?

Report Builder load failure on WAN-side of firewall

All,

Can anyone shed some light on this problem:

Using the same laptop and credentials I can successfully load Report Builder ONLY from the LAN-side of the firewall. However, if I reconnect using my Sprint AirCard I cannot load Report Builder; I get the now infamous "The remote server returned an error: (401) Unauthorized."

What ports are used by Reporting Service?

Thanks,

Brian

I'm not sure what's up with the AirCard connection, but I think I can explain the WAN/LAN difference. On the LAN side your default Windows credentials are sufficient to access the Report Builder files at http://hostname/reportserver/reportbuilder. On the WAN side, Windows integrated authentication doesn't work, so you get no Report Builder. The reason is that ClickOnce (which is responsible for downloading the application files to the client) cannot prompt for credentials, and it doesn't get any from IE, so if default Windows credentials don't work, you get nothing. The solution is to configure IIS on the report server to allow anonymous access to the virtual directory I mentioned above.

|||Does this work with port 443 also?

Report Access over the internet

Hi,

I need to install and setup accounts so that external users can see the reports

over the internet. The SQL Server is behind a firewall and SSRS 2000 will be on a separate machine.

Would someone know how I can install RS and what kind of accounts need to be created and set up so users outside the network can see the reports?

Very much appreciate your help!

Take a look at using Forms Authentication with Reporting Services. This is the recommended way to access reports from the internet. There are other ways(enabling Anon access), but they are not recommended.

http://msdn2.microsoft.com/en-us/library/ms152899.aspx

http://blogs.msdn.com/bimusings/archive/2005/08/04/447939.aspx