sql server reporting services: Problems with pix firewall -- sql server reporting services

You're in the

sql server reporting services

group:

Problems with pix firewall

Daniel Billingsley
2/23/2006 9:33:48 AM

sql server reporting services: We have a pix firewall and Websense filter on our internet connection. One
of the software products we use is web-based and includes SQL RS for its
reporting.

When I run one of these reports from inside the company, I get the message
that the report is being generated and the spinning green circle thingy
graphic, but the actual report never displays. If I take the exact same
computer and disconnect from the company network and connect with my Verizon
card the report runs fine. I've switched back and forth a few times and it
consistently works from outside and not from inside.

Is there some kind of push going on to get the actual report that is maybe
blocked by the firewall or Websense? I've looked at the firewall
configuration and nothing jumps out at me.

Anybody have any suggestions?

RE: Problems with pix firewall

t-weilu NO[at]SPAM online.microsoft.com
2/24/2006 12:00:00 AM

Hi Daniel,

Welcome to use MSDN Managed Newsgroup Support.

From your description, my understanding of this issue is: You can see the
report from the Extranet correctly but you can not generate the report when
you are in the intranet. If I misunderstood your concern, please feel free
to point it out.

To narrow down the issue, would your provide the information to me?

1. Are you in the same domain with the Report Server when you using
the company network?

2. If you turn off the firewall, does this issue occur again?

3. You may want to check <reportserverurl> item in the following
configuration file in the Reporting Server to see details.

C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
Services\reportmanager\rswebapplicaton.config file

4. If all the above can not resolve the issue, it seems the issue is
related with configuration of your company network. I think you need to
contact your network admin to check the configuration.

Due to the complexity of this issue we might not be able to effectively
assist with this request in the newsgroups. If the issue could not be
solved efficiently in the newsgroup, I would like to suggest that you
contact Microsoft Product Support Services via telephone so that a
dedicated Support Professional can assist with this request. Please be
advised that contacting phone support will be a charged call. However, if
you are simply requesting a hotfix be sent to you and no other support then
charges are usually refunded or waived.

To obtain the phone numbers for specific technology request please take a
look at the web site listed below.

http://support.microsoft.com/default.aspx?scid=fh;EN-US;PHONENUMBERS

If you are outside the US please see http://support.microsoft.com
for regional support phone numbers.

Thank you for your patience and understanding.

Sincerely yours,

Wei Lu
Microsoft Online Partner Support

Get Secure! - www.microsoft.com/security
=====================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.

Re: Problems with pix firewall

Daniel Billingsley
2/24/2006 4:01:16 PM

Thanks for your help.

It's not my reporting server - it is from a software vendor. It is
obviously something on our network, but I don't even know where to begin
looking. I'm hoping somebody has had problems with running a RS report on a
server outside a network and could provide some insight like "yes, you have
to open port such-and-such." I've had a previous occasion (with Polycom
videoconferencing) where it turned out the pix is particularly picky about
certain kinds of traffic.

To answer your specific questions.

1. I'm not in the same domain in either case.
2. That would mean bypassing the entire corporate firewall and reconfiguring
the physical connections to the internet. We're not at that point yet.
3. Not relevant. See #1.

[quoted text, click to view]

Re: Problems with pix firewall

t-weilu NO[at]SPAM online.microsoft.com
2/27/2006 12:00:00 AM

Hi Daniel,

Thanks for the update.

Apparently it is not server side issue at all. I think you'd better contact
Cisco since the issue is caused by their firewall and they could provide
more information about the configuration of your firewall. You may need
capture packets on firewall side and compare to the packets without
firewall.

Thank you for the understanding.

Sincerely yours,

Wei Lu
Microsoft Online Partner Support

Get Secure! - www.microsoft.com/security
=====================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server reporting services group.

home · blog · groups

Questions? Comments? Contact the dn