Solved

How To Link The Application On The Application Server To The SQL SERVER 2005 On Different Zones Through FireWALL????

Posted on 2008-06-23
3
178 Views
Last Modified: 2010-03-19
Greetings Experts!
My Question is: I have a web application residing on an application server, and I have installed SQL SERVER 2005 on a database server, but the two servers are located in different zones, and  there is a firewall in between, and I need to access the report server (services) on the sql server , from my application. So, could do I accomplish this? Would there be certain ports I need to open?
Thanks in advance.
best wishes,
~Salman~
0
Comment
Question by:salman_sulaiman_2008
  • 2
3 Comments
 
LVL 4

Accepted Solution

by:
Nazermohideeen earned 500 total points
Comment Utility
Reporting service runs on Port 80 (HTTP) port.

NM
0
 

Author Comment

by:salman_sulaiman_2008
Comment Utility
Greetings Nazer!
thanks for the reply mate!
there is something else that I am confused about besides the ports issue. Do I need to add the application server's machine name on the report server users/roles list.? or would the application on the application server would be able to run the reports immediatly.? remembering that the two servers are on different zones..? I am thinking if I have to do this, it is going to be quite difficult. won't it.?

~salman~
0
 
LVL 4

Expert Comment

by:Nazermohideeen
Comment Utility
I am not so sure, but as far as I know, the report server is like another application server. You can simply configure how you want both ends to be. Next this is completely HTTP protocol. So no firewall problems.

Hope this helps
NM
0

Featured Post

Backup Your Microsoft Windows Server®

Backup all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Join & Write a Comment

Suggested Solutions

I've encountered valid database schemas that do not have a primary key.  For example, I use LogParser from Microsoft to push IIS logs into a SQL database table for processing and analysis.  However, occasionally due to user error or a scheduled task…
In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…
Here's a very brief overview of the methods PRTG Network Monitor (https://www.paessler.com/prtg) offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…

763 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now