?
Solved

Reporting Services broken after IP change on the servers.

Posted on 2005-05-10
2
Medium Priority
?
5,166 Views
Last Modified: 2008-01-09
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)
0
Comment
Question by:it_stops
2 Comments
 
LVL 7

Accepted Solution

by:
ABaruh earned 2000 total points
ID: 13988066
There are 2 files you need to edit: RSWebApplication.config and RSReportServer.config

On my machine, RSWebApplication.config is at:
C:\Program Files\Microsoft SQL Server\MSSQL\Reporting Services\ReportManager

and RSReportServer.config is at:
C:\Program Files\Microsoft SQL Server\MSSQL\Reporting Services\ReportServer

In RSWebApplication.config, look for and edit the value in this key:
<ReportServerUrl>

In RSReportServer.config, look for and edit the values in these keys (may not need to edit all of them):
InstanceName
<UrlRoot>
<SMTPServer>
0
 
LVL 1

Author Comment

by:it_stops
ID: 13992820
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
0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Question has a verified solution.

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

Hi, I am very much excited today since I'm going to share something very exciting Tool used for Analytical Reporting and that's nothing but MICROSTRATEGY. Actually there are lot of other tools available in the market for Reporting Such as Co…
Today, still in the boom of Apple, PC's and products, nearly 50% of the computer users use Windows as graphical operating systems. If you are among those users who love windows, but are grappling to keep the system's hard drive optimized, then you s…
Look below the covers at a subform control , and the form that is inside it. Explore properties and see how easy it is to aggregate, get statistics, and synchronize results for your data. A Microsoft Access subform is used to show relevant calcul…
When cloud platforms entered the scene, users and companies jumped on board to take advantage of the many benefits, like the ability to work and connect with company information from various locations. What many didn't foresee was the increased risk…
Suggested Courses

839 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