SQL 2005 Reporting Services and IIS with Dual NIC

Posted on 2010-03-29
Medium Priority
Last Modified: 2012-05-09
How do I make all Reporting Services / IIS traffic travel over NIC 1 when two NICS are configured?

-Windows Server 2003 configured with Dual NICS.
--NIC 1 is
--Nic 2 is
-Sql Server 2005 with Reporting Services
-IIS is configured
-The Cisco ASA 5510 is configured to allow traffic exchange with

SCENARIO:  Currently I connect to the ASA with the Cisco client and use the web browser to hit http:\\\portal.html  across that connection.  Everything is presented fine and ask for authentication etc.  However, when I click one of the internal links, it reflects (Nic 2) on the bottom of the browser instead of (Why the change?).  of course this is configured to route outside the Cisco so it fails.  we are able to make it work my RDP into the server and executing there since you can hit both NIC from inside the server.

I have edited the two config files to use the Static IP address of NIC 1 instead of the server name, but it still does not work.  I did enable NETBIOS over the NIC since I read that might have been an issue (I put it back).  The files were rsreporting.config  and the web one which I can;t recalll the name at the moment.  Would I need to restart the server after I made those changes or is there something else I am missing?

Question by:wwakefield
LVL 17

Accepted Solution

Andres Perales earned 2000 total points
ID: 29126568
did you set the IIS website that reporting services is on to listen only on that IP address?  You will have to select this from the IIS manager.

Author Comment

ID: 32642002
This was never answred with success and I am still researching.   The Dual-Homed NICS seem to be the core of the issue.   All Reporting Services web pages are not presenting over the correct NIC.  

Please close.

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Question has a verified solution.

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

by Mark Wills Attending one of Rob Farley's seminars the other day, I heard the phrase "The Accidental DBA" and fell in love with it. It got me thinking about the plight of the newcomer to SQL Server...  So if you are the accidental DBA, or, simp…
In this article, we will show how to detach and attach a database and then show how to repair a corrupt database and attach it, If it has some errors. We will show how to detach and attach using SSMS or using T-SQL sentences.
SQL Database Recovery Software repairs the MDF & NDF Files, corrupted due to hardware related issues or software related errors. Provides preview of recovered database objects and allows saving in either MSSQL, CSV, HTML or XLS format. Ensures recov…
Stellar Phoenix SQL Database Repair software easily fixes the suspect mode issue of SQL Server database. It is a simple process to bring the database from suspect mode to normal mode. Check out the video and fix the SQL database suspect mode problem.
Suggested Courses

589 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