Prev: Manually uninstall reporting svcs (sql 2005)
Next: ReportViewer error
From: michelle on 20 Mar 2006 16:06
We had used the httpcfg.exe to add an IP listener on port 80 of the server's
IP address while trying to get http endpoints to work. We rebooted the
machine sometime later and from that point on, reporting services no longer
worked.

We removed this IP listener and reporting services now works.


"michelle" <michelle(a)nospam.com> wrote in message
news:Od80a14RGHA.1576(a)tk2msftngp13.phx.gbl...
> Found log file which contains more details about the error (see below).
>
> Would the fact that I can't browse to the website from the server using
> http:\\localhost be related to this at all?
>
> w3wp!ui!7!3/14/2006-11:30:01:: e ERROR: Unable to connect to the remote
> server
> w3wp!ui!7!3/14/2006-11:30:01:: e ERROR: HTTP status code --> 500
> -------Details--------
> System.Net.WebException: Unable to connect to the remote server --->
> System.Net.Sockets.SocketException: No connection could be made because
the
> target machine actively refused it
>
> at System.Net.Sockets.Socket.DoConnect(EndPoint endPointSnapshot,
> SocketAddress socketAddress)
>
> at System.Net.Sockets.Socket.InternalConnect(EndPoint remoteEP)
>
> at System.Net.ServicePoint.ConnectSocketInternal(Boolean
connectFailure,
> Socket s4, Socket s6, Socket& socket, IPAddress& address,
ConnectSocketState
> state, IAsyncResult asyncResult, Int32 timeout, Exception& exception)
>
> --- End of inner exception stack trace ---
>
> at
> Microsoft.SqlServer.ReportingServices2005.RSConnection.GetSecureMethods()
>
> at
>
Microsoft.ReportingServices.UI.Global.RSWebServiceWrapper.GetSecureMethods()
>
> at
>
Microsoft.SqlServer.ReportingServices2005.RSConnection.IsSecureMethod(String
> methodname)
>
> at
>
Microsoft.SqlServer.ReportingServices2005.RSConnection.ValidateConnection()
>
> 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.Page.OnInit(EventArgs e)
>
> at System.Web.UI.Control.InitRecursive(Control namingContainer)
>
> at System.Web.UI.Page.ProcessRequestMain(Boolean
> includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
> w3wp!ui!7!3/14/2006-11:30:04:: 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)
>
> "michelle" <michelle(a)nospam.com> wrote in message
> news:eCVrsgsRGHA.4792(a)TK2MSFTNGP14.phx.gbl...
> > This worked for quite some time but now it is not and we can't find
> anything
> > that has changed. We can browse to /ReportServer and get to the folders
> and
> > generate the reports but if we try to navigate to
> /Reports/Pages/Folder.aspx
> > We get a red X Error and Unable to connect to the remote server.
> >
> > This is SQL Server 2005 Enterprise Edition on Windows Server 2003. IIS
and
> > SQL are both running on this same box.
> >
> > There were some DCOM errors in the event log:
> >
> > Event Type: Error
> > Event Source: DCOM
> > Event Category: None
> > Event ID: 10016
> > Date: 3/13/2006
> > Time: 11:11:43 AM
> > User: NT AUTHORITY\NETWORK SERVICE
> > Computer: AFNISQLTEST
> > Description:
> > The application-specific permission settings do not grant Local
Activation
> > permission for the COM Server application with CLSID
> > {BA126AD1-2166-11D1-B1D0-00805FC1270E}
> > to the user NT AUTHORITY\NETWORK SERVICE SID (S-1-5-20). This security
> > permission can be modified using the Component Services administrative
> tool.
> >
> > But I believe that I have resolved this using dcomcnfg but I'm guessing
> that
> > it wasn't related because the Reporting Services stuff is still not
> working.
> > I don't see any other error messages of interest and am not sure what
> other
> > configuration information to provide. We're supposed to be demo-ing this
> > solution but it's not much of a solution right now.
> >
> > Thanks,
> >
> > Michelle
> >
> >
>
>


First  |  Prev  | 
Pages: 1 2
Prev: Manually uninstall reporting svcs (sql 2005)
Next: ReportViewer error