Hi,
RS 2005 (sql 2005 SP1) on Windows 2003 SP1
The report server was running ok until this morning. Its just giving a "The report server is not responding. Verify that the report server is running and can be accessed from this computer." message when trying to open the report manager.
Any ideas?
In the SQLDUMPER_ERRORLog.log file there is this..
05/22/06 12:53:35, ERROR , SQLDUMPER_UNKNOWN_APP.EXE, AdjustTokenPrivileges () failed (00000514)
05/22/06 12:53:35, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Input parameters: 4 supplied
05/22/06 12:53:35, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ProcessID = 328
05/22/06 12:53:35, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ThreadId = 0
05/22/06 12:53:35, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Flags = 0x0
05/22/06 12:53:35, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, MiniDumpFlags = 0x0
05/22/06 12:53:35, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, SqlInfoPtr = 0x47405860
05/22/06 12:53:35, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, DumpDir = <NULL>
05/22/06 12:53:35, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ExceptionRecordPtr = 0x00000000
05/22/06 12:53:35, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ContextPtr = 0x00000000
05/22/06 12:53:35, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ExtraFile = <NULL>
05/22/06 12:53:35, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, InstanceName = <NULL>
05/22/06 12:53:35, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ServiceName = <NULL>
05/22/06 12:53:36, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Callback type 11 not used
05/22/06 12:53:37, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Callback type 7 not used
05/22/06 12:53:37, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, MiniDump completed: C:\Program Files\Microsoft SQL Server\MSSQL.2\Reporting Services\LogFiles\SQLDmpr0001.mdmp
05/22/06 12:53:37, ACTION, w3wp.exe, Watson Invoke: No
I have the same problem now, but I am setting up a new deployment on another server, the original one can display the reports but it can not email out the reports.
Even though I am setting up a new report service on another server, I am encountering an error like the following:
TITLE: Microsoft Report Designer
A connection could not be made to the report server http://lasc06/reportserver.
ADDITIONAL INFORMATION:
Client found response content type of 'text/html; charset=utf-8', but expected 'text/xml'.
The request failed with the error message:
--
<html>
<head>
<title>
SQL Server Reporting Services
</title><meta name="Generator" content="Microsoft SQL Server Reporting Services 9.00.1399.00" />
<meta name="HTTP Status" content="500" />
<meta name="ProductLocaleID" content="9" />
<meta name="CountryLocaleID" content="1033" />
<meta name="StackTrace" content />
<style>
BODY {FONT-FAMILY:Verdana; FONT-WEIGHT:normal; FONT-SIZE: 8pt; COLOR:black}
H1 {FONT-FAMILY:Verdana; FONT-WEIGHT:700; FONT-SIZE:15pt}
LI {FONT-FAMILY:Verdana; FONT-WEIGHT:normal; FONT-SIZE:8pt; DISPLAY:inline}
.ProductInfo {FONT-FAMILY:Verdana; FONT-WEIGHT:bold; FONT-SIZE: 8pt; COLOR:gray}
A:link {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; COLOR:#3366CC; TEXT-DECORATION:none}
A:hover {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; COLOR:#FF3300; TEXT-DECORATION:underline}
A:visited {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; COLOR:#3366CC; TEXT-DECORATION:none}
A:visited:hover {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; color:#FF3300; TEXT-DECORATION:underline}
</style>
</head><body bgcolor="white">
<h1>
Reporting Services Error<hr width="100%" size="1" color="silver" />
</h1><ul>
<li>An internal error occurred on the report server. See the error log for more details. (rsInternalError) <a href="http://go.microsoft.com/fwlink/?LinkId=20476&EvtSrc=Microsoft.ReportingServices.Diagnostics.Utilities.ErrorStrings&EvtID=rsInternalError&ProdName=Microsoft%20SQL%20Server%20Reporting%20Services&ProdVer=9.00.1399.00" target="_blank">Get Online Help</a></li><ul>
<li>Object reference not set to an instance of an object.</li>
</ul>
</ul><hr width="100%" size="1" color="silver" /><span class="ProductInfo">SQL Server Reporting Services</span>
</body>
</html>
--. (Microsoft.ReportingServices.Designer)
BUTTONS:
OK
|||Hi,first thing for me would be to install the latest service pack first (You are running on the RTM version whereas the version 9.0.00.2047 is the most current.
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de|||
I looked at the log file and I found the following error:
07/24/06 18:20:55, ERROR , SQLDUMPER_UNKNOWN_APP.EXE, AdjustTokenPrivileges () failed (00000514)
Can someone provide me some tips? I have changed the permissions over here and there, I still have the same error...
and that caused me not able to access http://myserver/reports nor http://myserver/reportserver
|||This is the same error I had, I spent 2 days looking for a resolution but couldn't find one. I ended up re-installing SQL 2005 which obviously fixed the problem.
You may want to consider paying for some Microsoft support as I dont think anyone here knows the answers to this.
|||Hi,
The thing is I got this error after I installed a brand new report service on a server. I have reinstalled SQL 2005 so many times to solve this problem, but I still have the same error.
I am thinking, there are places I probably did not configure right during the report service setup, and the problem is I don't even know what are the right configurations I need to setup for the new report service. The following shows the error I found in the log file, looks like something is wrong with the pooling:
--
ReportingServicesService!library!4!7/25/2006-05:04:48:: i INFO: Catalog SQL Server Edition = Standard
ReportingServicesService!crypto!4!7/25/2006-05:04:48:: i INFO: Initializing crypto as user: NT AUTHORITY\NETWORK SERVICE
ReportingServicesService!crypto!4!7/25/2006-05:04:48:: i INFO: Exporting public key
ReportingServicesService!crypto!4!7/25/2006-05:04:48:: i INFO: Performing sku validation
ReportingServicesService!crypto!4!7/25/2006-05:04:49:: i INFO: Importing existing encryption key
ReportingServicesService!dbpolling!4!07/25/2006-05:04:49:: EventPolling polling service started
ReportingServicesService!dbpolling!a!7/25/2006-05:04:49:: EventPolling heartbeat thread started.
ReportingServicesService!dbpolling!4!07/25/2006-05:04:49:: NotificationPolling polling service started
ReportingServicesService!dbpolling!b!7/25/2006-05:04:49:: NotificationPolling heartbeat thread started.
ReportingServicesService!dbpolling!4!07/25/2006-05:04:49:: SchedulePolling polling service started
ReportingServicesService!dbpolling!4!07/25/2006-05:04:49:: UpgradePolling polling service started
ReportingServicesService!dbpolling!c!7/25/2006-05:04:49:: Polling started
ReportingServicesService!dbpolling!c!7/25/2006-05:04:49:: Polling caught an exception, restarting polling. Error Message System.NullReferenceException: Object reference not set to an instance of an object.
at Microsoft.ReportingServices.Diagnostics.WebConfigUtil.GetWebConfigAuthenticationAttribute(String attrName)
at Microsoft.ReportingServices.Diagnostics.WebConfigUtil.GetAuthenticationType()
at Microsoft.ReportingServices.Diagnostics.WebConfigUtil.get_AuthenticationType()
at Microsoft.ReportingServices.Library.NotificationQueueWorker.get_PollCommand()
at Microsoft.ReportingServices.Library.DBPoll.PollingFunction()
at Microsoft.ReportingServices.Library.DBPoll.PollingStartFunction().
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=164895&SiteID=1
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=463047&SiteID=1
|||I'm suffering from this problem but in my case sometimes the report works and sometimes not.
It's very strange.
The content of the Reporting Services' log file is:
08/25/06 14:22:49, ERROR , SQLDUMPER_UNKNOWN_APP.EXE, AdjustTokenPrivileges () failed (00000514)
08/25/06 14:22:49, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Input parameters: 4 supplied
08/25/06 14:22:49, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ProcessID = 4012
08/25/06 14:22:49, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ThreadId = 0
08/25/06 14:22:49, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Flags = 0x0
08/25/06 14:22:49, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, MiniDumpFlags = 0x0
08/25/06 14:22:49, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, SqlInfoPtr = 0x14DB9AF4
08/25/06 14:22:49, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, DumpDir = <NULL>
08/25/06 14:22:49, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ExceptionRecordPtr = 0x00000000
08/25/06 14:22:49, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ContextPtr = 0x00000000
08/25/06 14:22:49, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ExtraFile = <NULL>
08/25/06 14:22:49, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, InstanceName = <NULL>
08/25/06 14:22:49, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ServiceName = <NULL>
08/25/06 14:22:49, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Callback type 11 not used
08/25/06 14:22:51, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Callback type 7 not used
08/25/06 14:22:51, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, MiniDump completed: C:\Program Files\Microsoft SQL Server\MSSQL.6\Reporting Services\LogFiles\SQLDmpr0119.mdmp
08/25/06 14:22:51, ACTION, w3wp.exe, Watson Invoke: No
Thanks since now for any help
Jo?o Talles Dantas Batista
jtdbf@.hotmail.com
|||
Hi,
I solved my problem by going through the tips provided by someon else, it worked...
Beside the tips, you have to check IIS setting about the pooling...
I had a problem because I found out my report service was not with SQL 2005, it was the version before SQL 2005...
So, if you installed Report Service not along with SQL Server, you will have a lot of problems.
http://www.atrevido.net/blog/CategoryView.aspx?category=Security
|||Hello everyone,
I'm having at the present the same problem - my RS instance returns "The report server is not responding..."-message. Here is my scenario: 2 virtual PCs (VPC1 and VPC2). The SSRS is installed on both machines, and both instances configured to use one database, hosted on VPC2. VPC1 serves as Web-server.
I followed the hints listed in "How To: Configure a report server Scale-out deployment" from Books Online. I used "Reporting Services Configuration Manager" on both VPCs to set up the properties of the instances. I can see both instances from SQL Server Management Studio.
When I checked the log file, I saw the following message (among all INFOs):
Code Snippet
w3wp!ui!1!8/14/2007-14:34:17:: e ERROR: The report server is not responding. Verify that the report server is running and can be accessed from this computer.
w3wp!ui!1!8/14/2007-14:34:17:: e ERROR: HTTP status code --> 500
-Details--
Microsoft.ReportingServices.UI.Global+RSWebServiceWrapper+CantCommunicateWithReportServerException: The report server is not responding. Verify that the report server is running and can be accessed from this computer.
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!1!8/14/2007-14:34:19:: 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)
Error 500 isn't really helpful.
Does anyone have further hints or ideas?
Thanks in advantage,
Andrey
|||Hello again,
today I reinstalled the instances of SQL server on both VPCs. At the present I have DB engine installed on VPC1 and reporting services installed on VPC2. I can access the DB engine from VPC2 using SQL Server Management Studio, but when I open browser, I get the same error.
I suspect, there is a problem with IIS configuration. I will try to find out what could be a reason for this behaviour.
Regards,
Andrey
|||I reinstalled the IIS on VPC2 and the reconfigured Reporting Services using "Rep. Services Configuration Manager". When I try to access http://localhost/reports on VPC2, I get the following error:
Server Error in '/Reports' Application.
--
Configuration Error
Description: An error occurred during the processing of a configuration file required to service this request. Please review the specific error details below and modify your configuration file appropriately.
Parser Error Message: Cannot use 'partitionResolver' unless the mode is 'StateServer' or 'SQLServer'.
Source Error:
Line 162: </webParts>
Line 163: <machineKey validationKey="******" decryptionKey="***" validation="SHA1" />
Line 164: <sessionState mode="SQLServer" timeout="60" allowCustomSqlDatabase="true" partitionResolverType="Microsoft.Office.Server.Administration.SqlSessionStateResolver, Microsoft.Office.Server, Version=12.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c" />
Line 165: </system.web>
Line 166: <runtime>
Source File: c:\inetpub\wwwroot\web.config Line: 164
--
Version Information: Microsoft .NET Framework Version:2.0.50727.832; ASP.NET Version:2.0.50727.832
Does anyone know, what that means?
Regards,
Andrey.
|||After re-installing IIS did you reconfigure ASP.net 2.0?If not run C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\aspnet_regiis.exe -iru
gatharia
http://sharepointhacks.blogspot.com/|||
Hello,
this is a nice point. I really forgott to register .NET 2.0 with new installation of IIS. :-( Additionally I removed Sharepoint Server 2007 from the VPC.
At the present I need to stop my experiments, but I will return to them soon. The latest step I did was to install the default configuration of RS on VPC2 - just to check, that everything works. Later on I want to change the DB used by the installtion.
Regards,
Andrey
No comments:
Post a Comment