asked on

Reporting Services broken after IP change on the servers.

We brought our servers in house onto a dmz and gave them private IP's. The external FW interface maps the public IP's to the private ones. It feels like the reporter server is referencing the sql db(on another server on same private dmz subnet)by name, resolving to a public address, sending the request to the external interface of my FW(which is where the public address block resides and then gets lost since no real machine exists with these addresses. Is there a way to show the current config(maybe i can reference the db by IP and instance instead of name and instance. Here is my latest ReportServerWebApp...log. Notice the remote name resolution error:

<Header>
<Product>Microsoft SQL Server Reporting Services Version 8.00.743.00</Product>
<Locale>en-US</Locale>
<TimeZone>Eastern Daylight Time</TimeZone>
<Path>C:\Program Files\Microsoft SQL Server\MSSQL\Reporting Services\LogFiles\ReportServerWebApp__05_10_2005_09_02_09.log</Path>
<SystemName>STOPSOPS3</SystemName>
<OSName>Microsoft Windows NT 5.2.3790.0</OSName>
<OSVersion>5.2.3790.0</OSVersion>
</Header>
w3wp!library!66c!5/10/2005-09:02:09:: i INFO: Initializing MaxActiveReqForOneUser to '20' requests(s) as specified in Configuration file.
w3wp!library!66c!5/10/2005-09:02:09:: i INFO: Initializing MaxScheduleWait to default value of '1' second(s) because it was not specified in Configuration file.
w3wp!library!66c!5/10/2005-09:02:09:: i INFO: Initializing DatabaseQueryTimeout to default value of '30' second(s) because it was not specified in Configuration file.
w3wp!library!66c!5/10/2005-09:02:09:: i INFO: Initializing InstanceName to default value of 'MSSQLSERVER.1' because it was not specified in Configuration file.
w3wp!library!66c!5/10/2005-09:02:09:: i INFO: Initializing ProcessRecycleOptions to default value of '0' because it was not specified in Configuration file.
w3wp!library!66c!5/10/2005-09:02:09:: i INFO: Initializing RunningRequestsScavengerCycle to default value of '30' second(s) because it was not specified in Configuration file.
w3wp!library!66c!5/10/2005-09:02:09:: i INFO: Initializing RunningRequestsDbCycle to default value of '30' second(s) because it was not specified in Configuration file.
w3wp!library!66c!5/10/2005-09:02:09:: i INFO: Initializing RunningRequestsAge to default value of '30' second(s) because it was not specified in Configuration file.
w3wp!library!66c!5/10/2005-09:02:09:: i INFO: Initializing CleanupCycleMinutes to default value of '10' minute(s) because it was not specified in Configuration file.
w3wp!library!66c!5/10/2005-09:02:09:: i INFO: Initializing SecureConnectionLevel to default value of '1' because it was not specified in Configuration file.
w3wp!library!66c!5/10/2005-09:02:09:: i INFO: Initializing DisplayErrorLink to 'True' as specified in Configuration file.
w3wp!ui!d98!5/10/2005-09:02:11:: e ERROR: The underlying connection was closed: The remote name could not be resolved.
w3wp!ui!d98!5/10/2005-09:02:11:: e ERROR: HTTP status code --> 500
-------Details--------
System.Net.WebException: The underlying connection was closed: The remote name could not be resolved.

at System.Net.HttpWebRequest.CheckFinalStatus()

at System.Net.HttpWebRequest.EndGetRequestStream(IAsyncResult asyncResult)

at System.Net.HttpWebRequest.GetRequestStream()

at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters)

at Microsoft.SqlServer.ReportingServices.ReportingService.ListSecureMethods()

at Microsoft.SqlServer.ReportingServices.RSConnection.GetSecureMethods()

at Microsoft.ReportingServices.UI.RSWebServiceWrapper.GetSecureMethods()

at Microsoft.SqlServer.ReportingServices.RSConnection.IsSecureMethod(String methodname)

at Microsoft.ReportingServices.UI.Global.SecureAllAPI()

at Microsoft.ReportingServices.UI.ReportingPage.EnsureHttpsLevel(HttpsLevel level)

at Microsoft.ReportingServices.UI.ReportingPage.ReportingPage_Init(Object sender, EventArgs args)

at System.EventHandler.Invoke(Object sender, EventArgs e)

at System.Web.UI.Control.OnInit(EventArgs e)

at System.Web.UI.Control.InitRecursive(Control namingContainer)

at System.Web.UI.Page.ProcessRequestMain()
w3wp!ui!d98!5/10/2005-09:02:16:: e ERROR: Exception in ShowErrorPage: System.Threading.ThreadAbortException: Thread was being aborted.
at System.Threading.Thread.AbortInternal()
at System.Threading.Thread.Abort(Object stateInfo)
at System.Web.HttpResponse.End()
at System.Web.HttpServerUtility.Transfer(String path, Boolean preserveForm)
at Microsoft.ReportingServices.UI.ReportingPage.ShowErrorPage(String errMsg) at at System.Threading.Thread.AbortInternal()
at System.Threading.Thread.Abort(Object stateInfo)
at System.Web.HttpResponse.End()
at System.Web.HttpServerUtility.Transfer(String path, Boolean preserveForm)
at Microsoft.ReportingServices.UI.ReportingPage.ShowErrorPage(String errMsg)
w3wp!ui!66c!5/10/2005-09:49:30:: e ERROR: The underlying connection was closed: The remote name could not be resolved.
w3wp!ui!66c!5/10/2005-09:49:30:: e ERROR: HTTP status code --> 500
-------Details--------
System.Net.WebException: The underlying connection was closed: The remote name could not be resolved.

at System.Net.HttpWebRequest.CheckFinalStatus()

at System.Net.HttpWebRequest.EndGetRequestStream(IAsyncResult asyncResult)

at System.Net.HttpWebRequest.GetRequestStream()

at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters)

at Microsoft.SqlServer.ReportingServices.ReportingService.ListSecureMethods()

at Microsoft.SqlServer.ReportingServices.RSConnection.GetSecureMethods()

at Microsoft.ReportingServices.UI.RSWebServiceWrapper.GetSecureMethods()

at Microsoft.SqlServer.ReportingServices.RSConnection.IsSecureMethod(String methodname)

at Microsoft.ReportingServices.UI.Global.SecureAllAPI()

at Microsoft.ReportingServices.UI.ReportingPage.EnsureHttpsLevel(HttpsLevel level)

at Microsoft.ReportingServices.UI.ReportingPage.ReportingPage_Init(Object sender, EventArgs args)

at System.EventHandler.Invoke(Object sender, EventArgs e)

at System.Web.UI.Control.OnInit(EventArgs e)

at System.Web.UI.Control.InitRecursive(Control namingContainer)

at System.Web.UI.Page.ProcessRequestMain()
w3wp!ui!66c!5/10/2005-09:49:35:: e ERROR: Exception in ShowErrorPage: System.Threading.ThreadAbortException: Thread was being aborted.
at System.Threading.Thread.AbortInternal()
at System.Threading.Thread.Abort(Object stateInfo)
at System.Web.HttpResponse.End()
at System.Web.HttpServerUtility.Transfer(String path, Boolean preserveForm)
at Microsoft.ReportingServices.UI.ReportingPage.ShowErrorPage(String errMsg) at at System.Threading.Thread.AbortInternal()
at System.Threading.Thread.Abort(Object stateInfo)
at System.Web.HttpResponse.End()
at System.Web.HttpServerUtility.Transfer(String path, Boolean preserveForm)
at Microsoft.ReportingServices.UI.ReportingPage.ShowErrorPage(String errMsg)

ASKER CERTIFIED SOLUTION

ABaruh

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

it_stops

ASKER

ABaruh, you da man! I configured host files on these three machines but did not realize that there were two web instances on the report server. I saw the other one referenced in the RSWebApplication.config. I added that to my host file and it essentially points back to itself and it worked. MS RS is still an infant in my opinion. I remembered learning how to install it(what was necessary and what was not). It was a pain because there is so little info about it. I searched all over EE before asking. Thanks for helping me.

Steve