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
179 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
ID: 21845010
Reporting service runs on Port 80 (HTTP) port.

NM
0
 

Author Comment

by:salman_sulaiman_2008
ID: 21852538
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
ID: 21867656
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

NAS Cloud Backup Strategies

This article explains backup scenarios when using network storage. We review the so-called “3-2-1 strategy” and summarize the methods you can use to send NAS data to the cloud

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Introduction: When running hybrid database environments, you often need to query some data from a remote db of any type, while being connected to your MS SQL Server database. Problems start when you try to combine that with some "user input" pass…
INTRODUCTION: While tying your database objects into builds and your enterprise source control system takes a third-party product (like Visual Studio Database Edition or Red-Gate's SQL Source Control), you can achieve some protection using a sing…
This video explains how to create simple products associated to Magento configurable product and offers fast way of their generation with Store Manager for Magento tool.
This is a video that shows how the OnPage alerts system integrates into ConnectWise, how a trigger is set, how a page is sent via the trigger, and how the SENT, DELIVERED, READ & REPLIED receipts get entered into the internal tab of the ConnectWise …

932 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

11 Experts available now in Live!

Get 1:1 Help Now