Showing posts with label following. Show all posts

Friday, March 30, 2012

reportbuilder.application Authentication Error

This is the strangest thing. Whenever I try to access report builder from 90% of machines, I get the following error:

PLATFORM VERSION INFO
Windows : 5.1.2600.131072 (Win32NT)
Common Language Runtime : 2.0.50727.42
System.Deployment.dll : 2.0.50727.42 (RTM.050727-4200)
mscorwks.dll : 2.0.50727.42 (RTM.050727-4200)
dfdll.dll : 2.0.50727.42 (RTM.050727-4200)
dfshim.dll : 2.0.50727.42 (RTM.050727-4200)

SOURCES
Deployment url : https://reports.mysite.com/ReportServer/ReportBuilder/ReportBuilder.application

ERROR SUMMARY
Below is a summary of the errors, details of these errors are listed later in the log.
* Activation of https://reports.mysite.com/ReportServer/ReportBuilder/ReportBuilder.application resulted in exception. Following failure messages were detected:
+ Downloading https://reports.mysite.com/ReportServer/ReportBuilder/ReportBuilder.application did not succeed.
+ The remote server returned an error: (401) Unauthorized.

COMPONENT STORE TRANSACTION FAILURE SUMMARY
No transaction error was detected.

WARNINGS
There were no warnings during this operation.

OPERATION PROGRESS STATUS
* [5/10/2006 8:48:02 AM] : Activation of https://reports.mysite.com/ReportServer/ReportBuilder/ReportBuilder.application has started.

ERROR DETAILS
Following errors were detected during this operation.
* [5/10/2006 8:48:11 AM] System.Deployment.Application.DeploymentDownloadException (Unknown subtype)
- Downloading https://reports.mysite.com/ReportServer/ReportBuilder/ReportBuilder.application did not succeed.
- Source: System.Deployment
- Stack trace:
at System.Deployment.Application.SystemNetDownloader.DownloadSingleFile(DownloadQueueItem next)
at System.Deployment.Application.SystemNetDownloader.DownloadAllFiles()
at System.Deployment.Application.FileDownloader.Download(SubscriptionState subState)
at System.Deployment.Application.DownloadManager.DownloadManifestAsRawFile(Uri& sourceUri, String targetPath, IDownloadNotification notification, DownloadOptions options, ServerInformation& serverInformation)
at System.Deployment.Application.DownloadManager.DownloadDeploymentManifestDirectBypass(SubscriptionStore subStore, Uri& sourceUri, TempFile& tempFile, SubscriptionState& subState, IDownloadNotification notification, DownloadOptions options, ServerInformation& serverInformation)
at System.Deployment.Application.DownloadManager.DownloadDeploymentManifestBypass(SubscriptionStore subStore, Uri& sourceUri, TempFile& tempFile, SubscriptionState& subState, IDownloadNotification notification, DownloadOptions options)
at System.Deployment.Application.ApplicationActivator.PerformDeploymentActivation(Uri activationUri, Boolean isShortcut)
at System.Deployment.Application.ApplicationActivator.ActivateDeploymentWorker(Object state)
Inner Exception
System.Net.WebException
- The remote server returned an error: (401) Unauthorized.
- Source: System
- Stack trace:
at System.Net.HttpWebRequest.GetResponse()
at System.Deployment.Application.SystemNetDownloader.DownloadSingleFile(DownloadQueueItem next)

COMPONENT STORE TRANSACTION DETAILS
No transaction informtion is available.
-

Ok, so here's the catch. It works one 1 machine, a co-workers machine. I can login as any user and it'll work fine. But when I try it on any other machine, including my laptop, my desktop, my server, etc. I get that error. I've tried adjusting the IE Security settings, firewall settings, even tried different browsers. Here's some of the stuff installed on my machines:

Laptop
-Windows XP Pro
-ASP.NET Validation Tool
-Visual Basic Express w/ SQL Server Express
-.NET 1.1/2.0 Framework

Desktop
-Windows XP Home
-Visual Studio 2005 Professional
-.NET 1.1/2.0 Framework

Server
-Windows Server 2003 Enterprise
-SQL Server 2005
-.NET 1.1/2.0 Framework

Any help on this would be greatly appreciated. Even our lead developer has no clue, it won't work on his machine either!

I found a solution here.

reportbuilder.application Authentication Error

This is the strangest thing. Whenever I try to access report builder from 90% of machines, I get the following error:

SOURCES
Deployment url : https://reports.mysite.com/ReportServer/ReportBuilder/ReportBuilder.application

COMPONENT STORE TRANSACTION FAILURE SUMMARY
No transaction error was detected.

WARNINGS
There were no warnings during this operation.

OPERATION PROGRESS STATUS
* [5/10/2006 8:48:02 AM] : Activation of https://reports.mysite.com/ReportServer/ReportBuilder/ReportBuilder.application has started.

COMPONENT STORE TRANSACTION DETAILS
No transaction informtion is available.
-

Laptop
-Windows XP Pro
-ASP.NET Validation Tool
-Visual Basic Express w/ SQL Server Express
-.NET 1.1/2.0 Framework

Desktop
-Windows XP Home
-Visual Studio 2005 Professional
-.NET 1.1/2.0 Framework

Server
-Windows Server 2003 Enterprise
-SQL Server 2005
-.NET 1.1/2.0 Framework

Any help on this would be greatly appreciated. Even our lead developer has no clue, it won't work on his machine either!

I found a solution here.sql

report works in VS2003, but not in IE

I have a dirt-simple report that will render perfectly in the IDE, but when
it is deployed and run in the browser, I get the following error:
Exception of type
Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
thrown. (rrRenderingError) Get Online Help
Exception of type
Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
thrown.
Index was out of range. Must be non-negative and less than the size of the
collection. Parameter name: index
The report consists of a single textbox and two Line objects. The textbox
receives its value from a query that returns a single field. I have applied
the SSRS SP1.
Other reports work fine. For some reason this simple one fails. Why? I
can post the RDL upon request.Do you have any expressions in your report?
Andy Potter|||"Potter" wrote:
> Do you have any expressions in your report?
> Andy Potter
No, here's the only report item:
<ReportItems>
<Textbox Name="Notes">
<Style>
<PaddingLeft>0in</PaddingLeft>
<BorderColor>
<Default>#000000</Default>
</BorderColor>
<BorderStyle>
<Default>Dashed</Default>
</BorderStyle>
<FontSize>8pt</FontSize>
<LineHeight>13pt</LineHeight>
<Color>#000000</Color>
<PaddingBottom>0in</PaddingBottom>
<PaddingTop>0in</PaddingTop>
<PaddingRight>0in</PaddingRight>
</Style>
<Height>0.2083in</Height>
<Width>10in</Width>
<CanGrow>true</CanGrow>
<CanShrink>true</CanShrink>
<Value>=Fields!RSNotes.Value</Value>
</Textbox>
</ReportItems>
---
The field does need to wrap to multiple lines to display the "RSNotes" text
from the db. The above XML is nested inside <List></List> tags, which is the
only thing inside the Body tags.|||Any parameters or calculated fields?|||"Potter" wrote:
> Any parameters or calculated fields?
No calculated fields. There is one report parameter, "nRecordID", which is
used in the TSQL query as "...where RecordID = @.nRecordID"|||Unusual. Most of the references to this error revolve around exporting
to Excel. While the SP2 readme doesn't identify this as a resolved
issue, it might be worth bumping up to the move recent service pack.
Andy POtter|||"Potter" wrote:
> Unusual. Most of the references to this error revolve around exporting
> to Excel. While the SP2 readme doesn't identify this as a resolved
> issue, it might be worth bumping up to the move recent service pack.
I should have corrected my first post to state we are using SSRS2K SP2. It
is strange that this simplest report fails where much more complex ones are
OK. The report was imported from an Access2000 .mdb file. I will try
recreating it from scratch to see what happens. If all else fails I'll
install a trial of SSRS 05 on a different server and try it there.|||I've been able to reproduce the error. Starting from an empty report, the
body would deploy and print OK. When I added the pageheader from the
imported report, I got the "index out of range" error. Here is the
pageheader that was generated by the "Import report from Access" function:
<PageHeader>
<ReportItems>
<Line Name="Line8">
<Width>0in</Width>
<Style>
<BorderWidth>
<Default>2pt</Default>
</BorderWidth>
<BorderColor>
<Default>#000000</Default>
</BorderColor>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
</Line>
</ReportItems>
<PrintOnLastPage>true</PrintOnLastPage>
<PrintOnFirstPage>true</PrintOnFirstPage>
<Style>
<BackgroundColor>#ffffff</BackgroundColor>
</Style>
<Height>0in</Height>
</PageHeader>
With this pageheader removed, the report works. It would seem the import
code does not always produce valid reports, even though the pageheader does
render without error in the IDE.sql

Wednesday, March 28, 2012

Report with 2 or more tables and repeated rows.

Hello,

I'm encountering a problem. The following happens:
I make 2 tables in my report. Both tables have detail rows.
The 2 tables can have a different amount of (repeated)detail rows (e.g. The one table most to the top of the report has 3 detail rows an the other, below the topmost table, has 6)

The thing now is that every detailrow in the bottom table is repeated 3 times(so 3x6 is 18 rows...)
Does anyone know how to solve this problem?

Thanks,

Fedor BrouwerI don't think the 2 tables are affecting each other, unless one is nested inside the other. This will probably be down to the way the row groups have been set up but without more information about the report it's a bit difficult to say.

Report Web Viewer Control Error - SQL2005 September CTP

I am trying to use the Report Viewer Control in an ASPX page but getting the following error :- "For security reasons DTD is prohibited in this XML document. To enable DTD processing set the ProhibitDtd property on XmlReaderSettings to false and pass the settings into XmlReader.Create method. ". This is with the SQL Server 2005 September CTP. Is there any option that i should turn on or off?...

Thanks,
Krishna

see
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=101047&SiteID=1

I will try this tomorrowsql

Report Web Viewer Control Error - SQL2005 September CTP

Thanks,
Krishna

see
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=101047&SiteID=1

I will try this tomorrow

Monday, March 26, 2012

Report Viewer to Get Data from RS Deployed on separate Network.

Hi,

I am using Reporting Services in the following way. The application implements a three tier Architecture viz Web Server, Application Server and Database Server. Reporting Services 2005 is installed on the Database Server.

The application uses ReportViewer Control which is part of an ASPX page deployed on the Web Server. For ReportViewer Control to fetch data from Reporting Services using RS API, we have to set ReportServerUrl and Report Path. In this scenario, the web server cannot communicate to the database server directly. The web server is in the DMZ and it can only communicate with the Application Server which is in a separate Network.

How can I use Report Viewer Control to fetch data from Reporting Services which is on the Database Server.

Thanks & Regards,

Rajiv

I am afraid you won't like the answer but the Report Viewer control assumes a direct connection to the Report Server web service. It looks like in your situation, you need to install RS on the application server. A split deployment scenario is also an option (RS middle tier on the application server, while the catalog is on the database server) but you will need two licenses. Finally, in case you wan't to get innovative, try implementing an HttpHandler on the application server that would intercept SOAP and URL requests generated by the ReportViewer and forward them to the database server. I haven't done this but it should be possible. If you decide to try the last option, please post your findings here.|||

Hi,

Thanks for your reply. I am working on the approach that you have suggested. I have created an HttpHandler which is deployed as an Application Gateway on the Application Server. In the process request method of HttpHandler I am using HttpContext to get the current request and create a new request to the reporting server.

I am using windows XP, IIS 5.1. , Microsoft Visual Studio 2005 and Asp.net 2.0.

Scenario : Request an ASP.NET Page from the Webserver... which in turn makes a new request using HttpHandler which invokes Reporting Server.

"abc.aspx" page includes report viewer control. This page is deployed on the web server. The following properties are set for ReportViewer Control.

ReportVwrObj.ServerReport.ReportServerUrl = HTTPHandlerURL;

ReportVwrObj.ServerReport.ReportPath = ConfigurationManager.AppSettings["WebReportResults"].ToString ( ); //report file name and path.

Using Http Handler : I was able to sucessfully create a new request once i get the request from web server........However, I came across few issues related to Response.

Below is the sample code implemented in the ProcessRequest Method of HttpHandler.

public void ProcessRequest ( HttpContext context )

{

context.Response.ContentType = "text/plain";

//Url Request

RequestURL = "http://MahineName/reportserver";

///create the web request to get the remote stream

HttpWebRequest objRequest = ( HttpWebRequest ) WebRequest.Create ( RequestURL );

//objRequest.Credentials = CredentialCache.DefaultNetworkCredentials;

NetworkCredential nt = new NetworkCredential ( "Username", "Password", "Domain." );

objRequest.Credentials = nt;

objRequest.KeepAlive = false;

boolException = false;//clear exception

objResponse = ( HttpWebResponse ) objRequest.GetResponse ( );

if ( ( objResponse.ContentType.ToLower ( ).IndexOf ( "html" ) >= 0 ) || ( objResponse.ContentType.ToLower ( ).IndexOf ( "javascript" ) >= 0 )

||( objResponse.ContentType.ToLower ( ).IndexOf ( "xml" ) >= 0 ) )

{

//this objResponse is HTML Content, so we must parse it

StreamReader objReadStream = new StreamReader ( objReceiveStream, Encoding.Default );

//Uri test = new Uri(strRemoteUrl);

strContent = "";

strContent = objReadStream.ReadToEnd ( );

context.Response.ContentType = objResponse.ContentType;

context.Response.Flush ( );

context.Response.Write ( strContent );

///close streams

objReadStream.Close ( );

objResponse.Close ( );

}

context.Response.End ( );

}

In the above code, I have created a new httpwebrequest to forward the request to the reporting server. For the newly created request i get the response and flush it . I came across the below error while following this approach.

Response is not well-formed XML.

Data at the root level is invalid. Line 1, position 1.

Any Clue on this ?

|||Use a listener such as tcpTrace or SoapUtil to capture the request from the HttpHandler by redirecting to http://MahineName:8080/reportserver. It looks like the XML got distorted or something.

Report Viewer Problem

Hi there,

I hope someone can assist with this ?

My Report viewer takes ages to load then displays in the following format :

localhost/WayneServer - /

 Monday, November 20, 2006 1:32 PM <dir> AW Monday, November 20, 2006 11:07 AM <dir> Data Sources
 Monday, November 20, 2006 11:44 AM <dir> export_UWCM
 Monday, November 20, 2006 11:06 AM <dir> Report Project2

Microsoft SQL Server Reporting Services Version 9.00.1399.00

This view exist in IIs, report manager and all previews

I wish to view the HTML versions.

are you navigating to http://reportserver/reportserver ? if this is the case you will get a view as above, I suggest you navigate to http://reportserver/reports to get the publised nice html / CSS reports.|||

Nope, still getting problems,

Have uninstalled SQL Server completely plus .Net Framework and reinstalled all.

I still cannot get the reports page to display. The error that keeps appearing is shown below.

From the various messages I have read , I shouldn't be concerned by an occasional appearence of this error, however it is happening every time I try to view reports.

The report server is running and visible if I browse within IIS , but when I try with the Reports page, this is what I get.

The page will take forever to load , then this appears.

Server Error in '/Reports' Application.

Thread was being aborted.

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.Threading.ThreadAbortException: Thread was being aborted.
Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:

[ThreadAbortException: Thread was being aborted.] System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +483
 System.Web.HttpApplication.ResumeSteps(Exception error) +539
 System.Web.HttpApplication.System.Web.IHttpAsyncHandler.BeginProcessRequest(HttpContext context, AsyncCallback cb, Object extraData) +144
 System.Web.HttpRuntime.ProcessRequestInternal(HttpWorkerRequest wr) +403

Version Information: Microsoft .NET Framework Version:2.0.50727.42; ASP.NET Version:2.0.50727.210

|||

This is the debug information for the error.

'aspnet_wp.exe' (Managed): Loaded 'C:\WINDOWS\assembly\GAC_32\mscorlib\2.0.0.0__b77a5c561934e089\mscorlib.dll', Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled.

'aspnet_wp.exe' (Managed): Loaded 'C:\WINDOWS\assembly\GAC_32\System.Web\2.0.0.0__b03f5f7f11d50a3a\System.Web.dll', Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled.

'aspnet_wp.exe' (Managed): Loaded 'C:\WINDOWS\assembly\GAC_MSIL\System\2.0.0.0__b77a5c561934e089\System.dll', Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled.

'aspnet_wp.exe' (Managed): Loaded 'C:\WINDOWS\assembly\GAC_MSIL\System.Configuration\2.0.0.0__b03f5f7f11d50a3a\System.Configuration.dll', Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled.

'aspnet_wp.exe' (Managed): Loaded 'C:\WINDOWS\assembly\GAC_MSIL\System.Xml\2.0.0.0__b77a5c561934e089\System.Xml.dll', Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled.

'aspnet_wp.exe' (Managed): Loaded 'C:\WINDOWS\WinSxS\x86_Microsoft.VC80.CRT_1fc8b3b9a1e18e3b_8.0.50727.42_x-ww_0de06acd\msvcm80.dll', Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled.

'aspnet_wp.exe' (Managed): Loaded 'C:\WINDOWS\assembly\GAC_MSIL\System.Web.RegularExpressions\2.0.0.0__b03f5f7f11d50a3a\System.Web.RegularExpressions.dll', Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled.

'aspnet_wp.exe' (Managed): Loaded 'C:\WINDOWS\assembly\GAC_MSIL\Microsoft.JScript\8.0.0.0__b03f5f7f11d50a3a\Microsoft.JScript.dll', Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled.

'aspnet_wp.exe' (Managed): Loaded 'C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files\reports\2cbaf422\c4330628\App_global.asax.pa_-rz_z.dll', Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled.

'aspnet_wp.exe' (Managed): Loaded 'C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files\reports\2cbaf422\c4330628\assembly\dl3\de5a2332\00394ed1_9bd0c501\ReportingServicesWebUserInterface.DLL', Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled.

'aspnet_wp.exe' (Managed): Loaded 'C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files\reports\2cbaf422\c4330628\assembly\dl3\f180608d\00860e60_9bd0c501\Microsoft.ReportingServices.Diagnostics.DLL', Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled.

'aspnet_wp.exe' (Managed): Loaded 'C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files\reports\2cbaf422\c4330628\assembly\dl3\cd47089b\002f6849_9bd0c501\Microsoft.ReportingServices.Interfaces.DLL', Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled.

'aspnet_wp.exe' (Managed): Loaded 'C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files\reports\2cbaf422\c4330628\assembly\dl3\498aee86\00aa0b9e_9bd0c501\ReportingServicesCDOInterop.DLL', Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled.

'aspnet_wp.exe' (Managed): Loaded 'C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files\reports\2cbaf422\c4330628\assembly\dl3\4a099978\00b832a5_9bd0c501\ReportingServicesEmailDeliveryProvider.DLL', Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled.

'aspnet_wp.exe' (Managed): Loaded 'C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files\reports\2cbaf422\c4330628\assembly\dl3\a890e9c0\006cf7a9_9bd0c501\ReportingServicesFileShareDeliveryProvider.DLL', Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled.

'aspnet_wp.exe' (Managed): Loaded 'C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files\reports\2cbaf422\c4330628\assembly\dl3\23449648\00e563a6_9bd0c501\ReportingServicesNativeClient.DLL', Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled.

'aspnet_wp.exe' (Managed): Loaded 'C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files\reports\2cbaf422\c4330628\assembly\dl3\4b08bd78\00f2abb7_99d0c501\microsoft.reportingservices.diagnostics.resources.DLL', Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled.

'aspnet_wp.exe' (Managed): Loaded 'C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files\reports\2cbaf422\c4330628\assembly\dl3\eadd2b09\00e484b0_99d0c501\reportingservicesemaildeliveryprovider.resources.DLL', Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled.

'aspnet_wp.exe' (Managed): Loaded 'C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files\reports\2cbaf422\c4330628\assembly\dl3\e3d1a29b\003ee7b2_99d0c501\reportingservicesfilesharedeliveryprovider.resources.DLL', Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled.

'aspnet_wp.exe' (Managed): Loaded 'C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files\reports\2cbaf422\c4330628\assembly\dl3\753885f1\00dcd580_99d0c501\reportingservicesnativeclient.resources.DLL', Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled.

'aspnet_wp.exe' (Managed): Loaded 'C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files\reports\2cbaf422\c4330628\assembly\dl3\f6b220db\007683cf_99d0c501\reportingserviceswebuserinterface.resources.DLL', Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled.

'aspnet_wp.exe' (Managed): Loaded 'C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files\reports\2cbaf422\c4330628\assembly\dl3\4cce8f77\00c4f522_9ad0c501\microsoft.reportingservices.diagnostics.resources.DLL', Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled.

'aspnet_wp.exe' (Managed): Loaded 'C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files\reports\2cbaf422\c4330628\assembly\dl3\03e0eba8\00e3ff1c_9ad0c501\reportingservicesemaildeliveryprovider.resources.DLL', Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled.

'aspnet_wp.exe' (Managed): Loaded 'C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files\reports\2cbaf422\c4330628\assembly\dl3\7ac4a147\003d621f_9ad0c501\reportingservicesfilesharedeliveryprovider.resources.DLL', Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled.

'aspnet_wp.exe' (Managed): Loaded 'C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files\reports\2cbaf422\c4330628\assembly\dl3\ec2c2e87\000b3eda_99d0c501\reportingservicesnativeclient.resources.DLL', Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled.

'aspnet_wp.exe' (Managed): Loaded 'C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files\reports\2cbaf422\c4330628\assembly\dl3\9f3b9c1a\00c13937_9ad0c501\reportingserviceswebuserinterface.resources.DLL', Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled.

'aspnet_wp.exe' (Managed): Loaded 'C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files\reports\2cbaf422\c4330628\assembly\dl3\25bd35d6\001dd391_9ad0c501\microsoft.reportingservices.diagnostics.resources.DLL', Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled.

'aspnet_wp.exe' (Managed): Loaded 'C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files\reports\2cbaf422\c4330628\assembly\dl3\e979f37b\00fec897_9ad0c501\reportingservicesemaildeliveryprovider.resources.DLL', Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled.

'aspnet_wp.exe' (Managed): Loaded 'C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files\reports\2cbaf422\c4330628\assembly\dl3\65426dcc\00b28d9c_9ad0c501\reportingservicesfilesharedeliveryprovider.resources.DLL', Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled.

'aspnet_wp.exe' (Managed): Loaded 'C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files\reports\2cbaf422\c4330628\assembly\dl3\3d8370dc\00bbc15f_9ad0c501\reportingservicesnativeclient.resources.DLL', Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled.

'aspnet_wp.exe' (Managed): Loaded 'C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files\reports\2cbaf422\c4330628\assembly\dl3\5bcc180c\009383a2_9ad0c501\reportingserviceswebuserinterface.resources.DLL', Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled.

'aspnet_wp.exe' (Managed): Loaded 'C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files\reports\2cbaf422\c4330628\assembly\dl3\1f72add9\00690e8d_9ad0c501\microsoft.reportingservices.diagnostics.resources.DLL', Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled.

'aspnet_wp.exe' (Managed): Loaded 'C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files\reports\2cbaf422\c4330628\assembly\dl3\c4359e5b\005d1ede_9ad0c501\reportingservicesemaildeliveryprovider.resources.DLL', Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled.

'aspnet_wp.exe' (Managed): Loaded 'C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files\reports\2cbaf422\c4330628\assembly\dl3\d785aca6\005d1ede_9ad0c501\reportingservicesfilesharedeliveryprovider.resources.DLL', Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled.

'aspnet_wp.exe' (Managed): Loaded 'C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files\reports\2cbaf422\c4330628\assembly\dl3\52a99564\007fe4c3_9ad0c501\reportingservicesnativeclient.resources.DLL', Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled.

'aspnet_wp.exe' (Managed): Loaded 'C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files\reports\2cbaf422\c4330628\assembly\dl3\418a71ff\0095bafa_9ad0c501\reportingserviceswebuserinterface.resources.DLL', Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled.

'aspnet_wp.exe' (Managed): Loaded 'C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files\reports\2cbaf422\c4330628\assembly\dl3\b4b974fc\008793f3_9ad0c501\microsoft.reportingservices.diagnostics.resources.DLL', Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled.

'aspnet_wp.exe' (Managed): Loaded 'C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files\reports\2cbaf422\c4330628\assembly\dl3\c94ea495\00d68ada_9ad0c501\reportingservicesemaildeliveryprovider.resources.DLL', Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled.

'aspnet_wp.exe' (Managed): Loaded 'C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files\reports\2cbaf422\c4330628\assembly\dl3\457280b4\003e14e4_9ad0c501\reportingservicesfilesharedeliveryprovider.resources.DLL', Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled.

'aspnet_wp.exe' (Managed): Loaded 'C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files\reports\2cbaf422\c4330628\assembly\dl3\a49f2774\00cb1fbf_9ad0c501\reportingservicesnativeclient.resources.DLL', Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled.

'aspnet_wp.exe' (Managed): Loaded 'C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files\reports\2cbaf422\c4330628\assembly\dl3\64c3cee7\00c2ebfb_9ad0c501\reportingserviceswebuserinterface.resources.DLL', Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled.

'aspnet_wp.exe' (Managed): Loaded 'C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files\reports\2cbaf422\c4330628\assembly\dl3\bff44b85\004e7243_9bd0c501\microsoft.reportingservices.diagnostics.resources.DLL', Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled.

'aspnet_wp.exe' (Managed): Loaded 'C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files\reports\2cbaf422\c4330628\assembly\dl3\335adad0\0016d626_9bd0c501\reportingservicesemaildeliveryprovider.resources.DLL', Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled.

'aspnet_wp.exe' (Managed): Loaded 'C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files\reports\2cbaf422\c4330628\assembly\dl3\250e7417\00f7cb2c_9bd0c501\reportingservicesfilesharedeliveryprovider.resources.DLL', Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled.

'aspnet_wp.exe' (Managed): Loaded 'C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files\reports\2cbaf422\c4330628\assembly\dl3\9f7916c3\0084d707_9bd0c501\reportingservicesnativeclient.resources.DLL', Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled.

'aspnet_wp.exe' (Managed): Loaded 'C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files\reports\2cbaf422\c4330628\assembly\dl3\80fa321c\0059dd5e_9bd0c501\reportingserviceswebuserinterface.resources.DLL', Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled.

'aspnet_wp.exe' (Managed): Loaded 'C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files\reports\2cbaf422\c4330628\assembly\dl3\0f159e7c\0091a6ac_9cd0c501\microsoft.reportingservices.diagnostics.resources.DLL', Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled.

'aspnet_wp.exe' (Managed): Loaded 'C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files\reports\2cbaf422\c4330628\assembly\dl3\3949ea0c\001bf69b_9cd0c501\reportingservicesemaildeliveryprovider.resources.DLL', Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled.

'aspnet_wp.exe' (Managed): Loaded 'C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files\reports\2cbaf422\c4330628\assembly\dl3\414c7f51\00cfbaa0_9cd0c501\reportingservicesfilesharedeliveryprovider.resources.DLL', Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled.

'aspnet_wp.exe' (Managed): Loaded 'C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files\reports\2cbaf422\c4330628\assembly\dl3\51e658af\001eb287_9cd0c501\reportingservicesnativeclient.resources.DLL', Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled.

'aspnet_wp.exe' (Managed): Loaded 'C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files\reports\2cbaf422\c4330628\assembly\dl3\5e60063e\0023a5cb_9cd0c501\reportingserviceswebuserinterface.resources.DLL', Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled.

'aspnet_wp.exe' (Managed): Loaded 'C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files\reports\2cbaf422\c4330628\assembly\dl3\70ac46a9\0085b6fd_9cd0c501\microsoft.reportingservices.diagnostics.resources.DLL', Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled.

'aspnet_wp.exe' (Managed): Loaded 'C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files\reports\2cbaf422\c4330628\assembly\dl3\3326da35\008872e9_9cd0c501\reportingservicesemaildeliveryprovider.resources.DLL', Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled.

'aspnet_wp.exe' (Managed): Loaded 'C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files\reports\2cbaf422\c4330628\assembly\dl3\ce35052b\000f06ed_9cd0c501\reportingservicesfilesharedeliveryprovider.resources.DLL', Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled.

'aspnet_wp.exe' (Managed): Loaded 'C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files\reports\2cbaf422\c4330628\assembly\dl3\cb3df8e5\00f3b7de_9cd0c501\reportingservicesnativeclient.resources.DLL', Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled.

'aspnet_wp.exe' (Managed): Loaded 'C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files\reports\2cbaf422\c4330628\assembly\dl3\eef34066\001a7108_9dd0c501\reportingserviceswebuserinterface.resources.DLL', Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled.

'aspnet_wp.exe' (Managed): Loaded 'C:\WINDOWS\assembly\GAC_MSIL\System.Web.Mobile\2.0.0.0__b03f5f7f11d50a3a\System.Web.Mobile.dll', Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled.

'aspnet_wp.exe' (Managed): Loaded 'C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files\reports\2cbaf422\c4330628\App_Web_psamwgh1.dll', Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled.

'aspnet_wp.exe' (Managed): Loaded 'C:\WINDOWS\assembly\GAC_MSIL\System.Web.Services\2.0.0.0__b03f5f7f11d50a3a\System.Web.Services.dll', Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled.

'aspnet_wp.exe' (Managed): Loaded 'cibw0fcm', No symbols loaded.

'aspnet_wp.exe' (Managed): Loaded 'C:\WINDOWS\assembly\GAC_MSIL\System.Management\2.0.0.0__b03f5f7f11d50a3a\System.Management.dll', Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled.

The thread 0xd64 has exited with code 0 (0x0).

The program '[4476] aspnet_wp.exe: Managed' has exited with code -532459699 (0xe0434f4d).

Friday, March 23, 2012

report viewer control wont display report !

Hi friends
am trying to display reports from my report server in report view controls. following is my code in a button click

reportviewer1.ServerReport.ReportServerUrl = {http://localhost/reportserver};
reportviewer1.ServerReport.ReportPath = "\customer Details"
reportviewer1.RefreshReport();

its not giving my any error not displays any report!!
but if i set same info in design mode to report viewer control it works nicely!
whats missing here ?
Thanks for your help.finally figured out .following is what needs to be done

reportviewer1.ProcessingMode = Microsoft.Reporting.WinForms.ProcessingMode.Remote;
reportviewer1.ServerReport.ReportServerUrl = new System.Uri(@."http://localhost/reportserver");
reportviewer1.ServerReport.ReportPath = "\customer Details"
reportviewer1.RefreshReport();

Report Viewer control and ASPX

I am trying to use the Report Viewer Control in an ASPX page but getting the following error "For security reasons DTD is prohibited in this XML document. To enable DTD processing set the ProhibitDtd property on XmlReaderSettings to false and pass the settings into XmlReader.Create method". This is with September CTP of SQL Server 2005. I am not trying to set any DTD, the same report works if displayed using the WinForm viewer control...so I am not sure why this is happening. is there any samples available for using the Report Web viewer control in an aspx page?

Thanks

Krishna

This happens, when you are using a IP-address for the SQL Server Reporting Server once I started using DNS/Machine name the error went away - Krishna|||

Hello,

I am also getting the following error when viewing a report through an ASP.NET 2.0 Report Viewer control:

For security reasons DTD is prohibited in this XML document. To enable DTD processing set the ProhibitDtd property on XmlReaderSettings to false and pass the settings into XmlReader.Create method.

I seem to be getting it when retrieving a large amount of data. When I run the same report for a subset of the data, the report runs fine.

Any ideas?

Thanks in advance...

Brian

|||

Same problem when using Report Builder inside of SQL Reporting Services with Service Pack. The SRS Product doesn't seem to scale well to large reports.

|||

Hello ,Krishnaswin

How do you fix the issue , can you explain more ?

How to use the DNS/Machine name ,i do not catch your meaning .

lizzy

|||

Hello,Kishnawin

I use the method as you suggested ,but still have the issue .

Hope some one can give some suggestion

|||I am having same problem. I am using DNS name.. Reports are not large but am still getting this error. Help please

Report Viewer control and ASPX

Thanks

Krishna

This happens, when you are using a IP-address for the SQL Server Reporting Server once I started using DNS/Machine name the error went away - Krishna|||

Hello,

I am also getting the following error when viewing a report through an ASP.NET 2.0 Report Viewer control:

For security reasons DTD is prohibited in this XML document. To enable DTD processing set the ProhibitDtd property on XmlReaderSettings to false and pass the settings into XmlReader.Create method.

I seem to be getting it when retrieving a large amount of data. When I run the same report for a subset of the data, the report runs fine.

Any ideas?

Thanks in advance...

Brian

|||

Same problem when using Report Builder inside of SQL Reporting Services with Service Pack. The SRS Product doesn't seem to scale well to large reports.

|||

Hello ,Krishnaswin

How do you fix the issue , can you explain more ?

How to use the DNS/Machine name ,i do not catch your meaning .

lizzy

|||

Hello,Kishnawin

I use the method as you suggested ,but still have the issue .

Hope some one can give some suggestion

|||I am having same problem. I am using DNS name.. Reports are not large but am still getting this error. Help please

Report Viewer control and ASPX

Thanks

Krishna

This happens, when you are using a IP-address for the SQL Server Reporting Server once I started using DNS/Machine name the error went away - Krishna|||

Hello,

I am also getting the following error when viewing a report through an ASP.NET 2.0 Report Viewer control:

For security reasons DTD is prohibited in this XML document. To enable DTD processing set the ProhibitDtd property on XmlReaderSettings to false and pass the settings into XmlReader.Create method.

I seem to be getting it when retrieving a large amount of data. When I run the same report for a subset of the data, the report runs fine.

Any ideas?

Thanks in advance...

Brian

|||

Same problem when using Report Builder inside of SQL Reporting Services with Service Pack. The SRS Product doesn't seem to scale well to large reports.

|||

Hello ,Krishnaswin

How do you fix the issue , can you explain more ?

How to use the DNS/Machine name ,i do not catch your meaning .

lizzy

|||

Hello,Kishnawin

I use the method as you suggested ,but still have the issue .

Hope some one can give some suggestion

|||I am having same problem. I am using DNS name.. Reports are not large but am still getting this error. Help please

Report Viewer control and ASPX

Thanks

Krishna

This happens, when you are using a IP-address for the SQL Server Reporting Server once I started using DNS/Machine name the error went away - Krishna|||

Hello,

I am also getting the following error when viewing a report through an ASP.NET 2.0 Report Viewer control:

For security reasons DTD is prohibited in this XML document. To enable DTD processing set the ProhibitDtd property on XmlReaderSettings to false and pass the settings into XmlReader.Create method.

I seem to be getting it when retrieving a large amount of data. When I run the same report for a subset of the data, the report runs fine.

Any ideas?

Thanks in advance...

Brian

|||

Same problem when using Report Builder inside of SQL Reporting Services with Service Pack. The SRS Product doesn't seem to scale well to large reports.

|||

Hello ,Krishnaswin

How do you fix the issue , can you explain more ?

How to use the DNS/Machine name ,i do not catch your meaning .

lizzy

|||

Hello,Kishnawin

I use the method as you suggested ,but still have the issue .

Hope some one can give some suggestion

|||I am having same problem. I am using DNS name.. Reports are not large but am still getting this error. Help pleasesql

Report Viewer control and ASPX

Thanks

Krishna

This happens, when you are using a IP-address for the SQL Server Reporting Server once I started using DNS/Machine name the error went away - Krishna|||

Hello,

I am also getting the following error when viewing a report through an ASP.NET 2.0 Report Viewer control:

For security reasons DTD is prohibited in this XML document. To enable DTD processing set the ProhibitDtd property on XmlReaderSettings to false and pass the settings into XmlReader.Create method.

I seem to be getting it when retrieving a large amount of data. When I run the same report for a subset of the data, the report runs fine.

Any ideas?

Thanks in advance...

Brian

|||

Same problem when using Report Builder inside of SQL Reporting Services with Service Pack. The SRS Product doesn't seem to scale well to large reports.

|||

Hello ,Krishnaswin

How do you fix the issue , can you explain more ?

How to use the DNS/Machine name ,i do not catch your meaning .

lizzy

|||

Hello,Kishnawin

I use the method as you suggested ,but still have the issue .

Hope some one can give some suggestion

|||I am having same problem. I am using DNS name.. Reports are not large but am still getting this error. Help please

Wednesday, March 21, 2012

Report to have n.. columns

Hi,

I have a table with following structure:

There can be different weeks for different activities. Depending on weeeks on weeks having data should be displayed. i.e. when activity was running.

Activitynumber Line Product Week1 Week2 Week3 .....Week52

100 Volume Product1 23 32

100 Volume Product2 11 46

102 Volume Product3 45 56 67 76

100 Revenue Product1 766 232

100 Revenue Product2 763 146

102 Revenue Product3 890 356 467 576

I want a report which should look like this

For Line=Volume Report:

Weeknumber Product1 Product2

Week1 23 11

Week2 32 46

For Line=Revenue Report:

Weeknumber Product1 Product2

Week1 766 763

Week2 232 146

Can anyone help me to suggest what should be the wayout?

A matrix will represent that for you. With a matrix, you can set row level grouping and column grouping. For both of your reports i would have the weeks as the row level grouping, and Product as the column grouping, and then either volume or revenue as the detail. The column group means that you will have a dynamic number of columns, one for each product in your dataset.

|||

Hi Sluggy,

Thanks for your answer. The problem here is that the table has got 52 columns for 52 weeks starting from week1, week2...week52.

some activities may be for 3 weeks some for 10 or some for 50. Will this display only the weeks whihc has the data?

regards

Josh

|||

In your report data, just make sure pull back either a week number or a week commencing, then you can row group on that. This means that you will have 52 rows in your matrix. Then if a product doesn't have any volume or revenue for that week you can show a zero (or empty cell) in the detail section. You could even go to the extent of hiding (set the hidden property to true) rows or columns that are only zeros or empty.

Hope that helps.

sluggy

|||

How can I hide rows which dont have any data? I mean which options do I have to select?

thanks

Josh

Tuesday, March 20, 2012

Report Subscription with Attachement

Hi there.
I have the following issue with all report subscriptions that I setup from
the Report manager that have attached the report files, regardless the format.
The e-mail is properly sent with a file of the proper name but of zero file
size.
It seems to work when I set the render format to Web Archive.( I saw this
tip from this newsgroup).
Any ideas on how to make the attachments work properly?
Thanks
MPIf you are using a Lotus email server this is a known issue and there is a
fix for it here:
http://support.microsoft.com/default.aspx?scid=kb;[LN];872774
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Minas Papageorgiou" <MinasPapageorgiou@.discussions.microsoft.com> wrote in
message news:734CF1A0-9302-4B94-A80E-D4EF5427C9CA@.microsoft.com...
> Hi there.
> I have the following issue with all report subscriptions that I setup from
> the Report manager that have attached the report files, regardless the
format.
> The e-mail is properly sent with a file of the proper name but of zero
file
> size.
> It seems to work when I set the render format to Web Archive.( I saw this
> tip from this newsgroup).
> Any ideas on how to make the attachments work properly?
> Thanks
> MP
>

Friday, March 9, 2012

Report Service failed to start

New install of the June SQL 05 Standard CTP bits, the Report Service fails to start with the following errors.

Service cannot be started. Microsoft.ReportingServices.Diagnostics.Utilities.UnknownUserNameException: The user or group name 'LocalSystem' is not recognized.
at Microsoft.ReportingServices.Library.Native.NameToSid(String name)
at Microsoft.ReportingServices.Library.ServiceAppDomainController.StartRPCServer(Boolean firstTime)
at Microsoft.ReportingServices.Library.ServiceAppDomainController.Start(Boolean firstTime)
at Microsoft.ReportingServices.NTService.ReportService.OnStart(String[] args)
at System.ServiceProcess.ServiceBase.ServiceQueuedMainCallback(Object state)

The service (and SQL server) is configured to use Local System as the account.

In RsReportServer.config change your WebServiceAccount to be the actual account the web service runs as, for instance ASPNET or Network Service. If you empty it, we will use a default for the OS.

Thanks
Tudor|||Dear Tudor,
I have similar problem. I've just installed the final version of sql 2005 (reporting services as well, side by side with the original sql 2000 + reporting services pair) and the Reporting Services (the old one) service doesn't start after the boot process. My error message is the following:

Service cannot be started. Microsoft.ReportingServices.Diagnostics.Utilities.EventLogSourceNotFound: Event source Schedule and Delivery Processor does not exist.

at Microsoft.ReportingServices.Diagnostics.Utilities.RSEventLog.Init()

at Microsoft.ReportingServices.Diagnostics.Globals.Init(RSConfigurationManager configManager, RunningApplication app)

at Microsoft.ReportingServices.Library.ServiceAppDomainController.Start()

at Microsoft.ReportingServices.NTService.ReportService.OnStart(String[] args)

at System.ServiceProcess.ServiceBase.ServiceQueuedMainCallback(Object state)

In my browser I got the following message instead of my report folders:
Unable to communicate with report server. Please verify that the report server is operational.

The RS'2005 service works fine but all my reports are on the old installation and I really need them. Each service uses Local system account except server-agents which use a domain account.
Please help me!
Thanks in advance,
marcell|||

Tudor,

Many thanks. Your pointer solved my problem also.

Regards,

Arun Philip

|||

anyone please help.... Im unable to start report server...Im not sure if this is similar with the problem posted by Dillon.....Thanks

Microsoft.ReportingServices.Diagnostics.Utilities.UnknownUserNameException: The user or group name 'ORACLE-01\ASPNET' is not recognized., ;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.UnknownUserNameException: The user or group name 'ORACLE-01\ASPNET' is not recognized.
ReportingServicesService!servicecontroller!4!4/26/2007-09:40:01:: e ERROR: Exception caught starting RPC server: Microsoft.ReportingServices.Diagnostics.Utilities.UnknownUserNameException: The user or group name 'ORACLE-01\ASPNET' is not recognized.
at Microsoft.ReportingServices.Library.Native.NameToSid(String name)
at Microsoft.ReportingServices.Library.ServiceAppDomainController.StartRPCServer(Boolean firstTime)

|||I get the Same Error RE LocalSystem account. Funny thing is, when i open the report server config file, there is NO NODE in the XML for the WebServiceIdentity. I treid to add it myself with NT AUTHORITY\System as per the MS KB Article but it is still not working... any ideas ?|||

This node doesnt exist in case you are woking on SQL 2000 Reporting services.

Hope This helps.