.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

when i was deploying reporting services i got this error

Posted By:      Posted Date: September 26, 2010    Points: 0   Category :Sql Server
TITLE: Microsoft Report Designer

A connection could not be made to the report server http://localhost/ReportServer.


Client found response content type of 'text/html; charset=utf-8', but expected 'text/xml'.
The request failed with the error message:
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<title>IIS 7.0 Detailed Error - 500.23 - Internal Server Error</title>
<style type="text/css">
.config_source code{font-size:.8em;color:#000000;}
ul,ol{margin:10px 0 10px 40px;}
fieldset{padding:0 15px 10px 15px;}
.summary-container fieldset{padding-bottom:5px;margin-top:4px;}
legend.no-expand-all{padding:2px 15px 4px 10px;margin:0 0 0 -12px;}
legend{color:#333333;padding:4px 15px 4px 10px;margin:4px 0 8px -

View Complete Post

More Related Resource Links

Reporting Services Error



         This is the error I m getting. Can anyone tell me what exactly the problem is

An error occurred during local report processing.
An error has occurred during report processing.
Query execution failed for dataset "DataSet1".
ExecuteReader : CommandText property has not been initialized.


Error installing SharePointRS (Reporting Services AddIn)



I trying to install the SharePointRS AddIn on the SharePoint-Maschine. The installation runs and after the setup does something, it rollback the installation and informs me with just a message, that it was not successful. After searching for the installation log, I've found it in my temp folder. The error was:
"Install error: The 'Mapping' start tag on line 83 does not match the end tag of 'ByExtension'. Line 139, position 7.".
What means this error? How can I solve it?

Greetings, Anatoli.

The whole log file:

User: usrFarmAdmin
Installing Report Server feature.
Calling copyappbincontents command.


copyappbincontents command completed successfully.
Adding Report Server feature to farm.
Installed Report Server feature.
Activating Report Server feature to root level site collections.
Activating feature in web app 'SharePoint - 22222'
Web app 'SharePoint - 22222' does not have a root site collection.
Activating feature in web app 'SharePoint - 80'
Activating feature to root site collection: http://computername
Feature already activated in site collection http://computername
Activating feature in web app 'SharePoint - 8080'
Web app 'SharePoint - 8080' does not have a

Reporting Services Add-In for MOSS2007 : Unable to connect to the database Error at "Set Server Defa

Dear Expert, I've succesfully install the Add-In + configure the reporting services (integrated mode) + activate the features on my MOSS2007. As we know by activating this at my Central Admin, i'm able to see "Reporting Services" under my Application Management as below:   1) Manage Integration Setting   ---> My report url : http://servername:808/ReportServer (Trusted Account) 2) Grand Database Access --->  My setting : <servername> with default instance  3) Set Server Defaults ---> Area that i receive an error "Unable to connect to database" Anybody here have a same experience? please assist me, Thanks in Advanced My Note: OS : Windows Server 2008 Enterprise x64bit (SP2) SQL : SQL 2005 with latest Service Pack (SP3)  My Error Log: <Header>   <Product>Microsoft SQL Server Reporting Services Version 9.00.4035.00</Product>   <Locale>en-US</Locale>   <TimeZone>Malay Peninsula Standard Time</TimeZone>   <Path>c:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\LogFiles\ReportServer__08_04_2010_10_51_59.log</Path>   <SystemName>SEINE</SystemName>   <OSName>Microsoft Windows NT 6.0.6002 Service Pack 2</OSName>   <OSVersion>6.0.6002.131072</OS

"An error occurred during printing. (0x8000405)" eror - reporting services issue

We are getting this error: "An error occurred during printing. (0x8000405)" from time to time - 70% of the time when we are trying to use a printer button within report manager. It happens if we preview report or just print it. We noticed if we restart RS services, the error will stop for a little bit and then starts again. We don't print that much and it will come back after just a few reports printed. Let me know if you had a similar issue. thanks!

SQL Reporting Services 2008 Role in SCCM 2007 R2 has error component status message (SMS SRS web ser

SQL Reporting Services 2008 (SMS SRS web service is not running on SRS Reporting point server) with SCCM 2007 R2 -error component status message My environment is (x86) Windows Server 2008 SCCM 2007 R2 with SQL 2008.  The configuration is as follows: SCCM Configuration 1.The reporting Point role on SCCM is installed (SMSSRSRP Setup log is states the install was successful)2.DataSource Settings are SCCMSERVER\SCCM_DB  Test Connection Succeeded3.Database Authentication is set to use (Credentials Stored Securely on the Report Server) I've configured the same credentials in the Reporting Services Configuration ManagerI can access SQL Reporting Services without issue and run reports, etc; but I'm continuing to receive these error status messages..  SRSRP.log Repeats the following: Timed Out... SMS_SRS_REPORTING_POINT 4/17/2009 1:01:58 PM 2076 (0x081C)STATMSG: ID=7403 SEV=E LEV=M SOURCE="SMS Server" COMP="SMS_SRS_REPORTING_POINT" SYS=SMS Server SITE=SITE_CODE PID=2748 TID=2076 GMTDATE=Fri Apr 17 17:01:59.165 2009 ISTR0="SMS Server" ISTR1="" ISTR2="" ISTR3="" ISTR4="" ISTR5="" ISTR6="" ISTR7="" ISTR8="" ISTR9="" NUMATTRS=0 SMS_SRS_REPORTING_POINT 4/17/2009 1:01:59 PM 2076 (0x081C)Failures reported during periodic health check by the SRS Server SMS Server. Will retr

SharePoint 2010 Reporting Services Integrated-mode Error

I am running SharePoint 2010 and Reporting Services 2008 R2 SharePoint integrated-mode. I am able to browse to the reportserver site : http://DBserver/reportserver which lists my site collections and I am able to get to the document library which holds my reports. However, when I try opening a report I get the following error: Report Server has encountered a SharePoint error. (rsSharePointError) The security validation for this page is invalid. Click Back in your Web browser, refresh the page, and try your operation again. For more information about this error navigate to the report server on the local server machine, or enable remote errors I am able to resolve that issue by going to Central Admin, Application Management, General Settings and turning Web Page Security Validation Off. But if I do that I get an error when using silverlight features like site, or list creation. Any ideas?

Problem Deploying the Reporting Services Web Parts to SharePoint



I am trying to install the RSWebParts.cab file - which contains the Report Viewer and Report Explorer web parts - to my SharePoint 2010 server.  I ran the following command in PowerShell: stsadm -o addwppack -filename path/to/RSWebParts.cab -globalinstall. And received "The solution was successfully deployed" message.

However when I go into the SharePoint Server web front-end, I cannot find any trace of the new web parts.  Going back into PowerShell I ran the Get-SPWebPartPack command and the following was returned:

Name                             SolutionId                                                Deployed

rsswebparts.cab               00000000-0000-0000-0000-000000000000    False


So it appears to me that the cab file was loaded but not deployed.  But I'm not sure what I need to do next in order to get this pac

Error while Rendering Reports(Reporting Services 2005) in .Net 1.1 web Application on IIS 6.0


I developed an ASP.net 1.1 web application that is written in VS2203 and I am using Reporting Services 2005 to render some reports in PDF Format. My problem was it is working fine in local (XP) and Production environment (Windows 2003 Server).fromo long back the solution was not working for my integration Server which has windows 2003 Server (1.1) and we installed the 2.0,3.5 frameworks. It is throwing an Object refernce error while render the report. Is there any permisions or  something missing.

I have wasted so much time in a finding a solution and I appreciate any help in that.

What are issues involved with deploying a reporting Services report outside of our network?


I would like to know if it is resonable and acceptable to make reports created through SQL Server Reporting services available through our Public facing applications.


Also, what are the potential problems? Security? Impact on the SQL Server? Limit to specific types of reports?


If anyone has any info it would be greatly appreciated, I am a big fan of SQL Reporting but we are unsure if we are going to be able to use the reports on the Public side and we don't want two separate sets of reports (internal and Public).


Thanks in advance.


Reporting Services Error-The version of the report server database is either in a format that is not


 Hi,I have Configured All Reporting SErvices Through Rep Serv Configuration Wizard


When I type 


on top of Address Bar Of Browser I Am Gettin This Error

  • The version of the report server database is either in a format that is not valid, or it cannot be read. The found version is 'Unknown'. The expected version is 'C.0.8.40'. To continue, update the version of the report server database and verify access rights. (rsInvalidReportServerDatabase)
PLease Help Me


SQL Server Express 2008 Reporting Services - rsAccessDenied error


I've read through a lot of posts regarding the problem, but none of the proposed solutions have worked for me. I continue to get an error stating, "The permissions granted to user '<servername>\Rich' are insufficient for performing this operation. (rsAccessDenied)." If I am logged in as the local administrator account, entering the Reporting Services URL in IE doesn't give me that error, but it takes me to a blank page. I haven't been able to get to a SSRS home page at all.

Order of operations:

  1. I installed and patched Windows 7 Ultimate 64-bit
  2. I installed SQL Server Express 2008 with Advanced Services using the MS web installer.
  3. I downloaded and installed SP1 for SQL Server Express 2008.
  4. Opened up an instance of IE and tried to go to http://<servername>/Reports, receiving the above error. Well, technically I first tried /ReportServer_SQLExpress as reflected in the SSRS configuration manager, but that didn't work, either. I then changed the Web Service URL to use the virtual directory, "Reports" instead of the longer ReportServer_SQLExpress. It didn't work either way.

I've tried running IE as administrator, adding local machine to trusted sites, and just about every other suggestion I've found. I even ran the entire installation logged in as the loc

Error Upgrading from SQL Server 2000 - > 2008 R2 Reporting Services


Hello, I am having some trouble upgrading an existing SQL Server 2000 Reporting Services installation from an old server to a new one commissioned for this purpose, which is running SQL Server 2008 Reporting Services.  I have been following the instructions here:


but after trying to connect with reporting services 2008, i get this error:

The version of the report server database is either in a format that is not valid, or it cannot be read. The found version is 'C.0.6.54'. The expected version is '147'. (rsInvalidReportServerDatabase)

before starting the process, I ran upgrade advisor and got back the following results:


Setup can upgrade a SQL Server 2000 Reporting Services instance that uses a SQL Server 2000 Database Engine in the same instance. However, upgrade is blocked if the report server database is in a different instance, on a remote instance, or runs on a remote SQL Server 2005 instance in SQL Server 2000 compatibility mode.

*note, our reporting services IS in the same instance as the SQL Server 2000 database engine.  However, upgrade advisor still reported that this instance can not be au

Reporting Services Authorization error depending on web endpoints



I have a solution that uploads reports to a reporting server (SQL 2008 R2)

For compatibility , I have two service apps which work completely the same way, but which use different web service endpoints:

App2005 uses http://localhost:8080/reportserver/reportservice2005.asmx

App2010 uses http://localhost:8080/reportserver/reportservice2010.asmx

Both Apps work fine on a test machine.

On my developer machine (local admin) App2005 works, but App2010 does not.

Error is "The request failed with HTTP status 401: Unauthorized."

The error raises at the ListChildren method, source snippet is here:


         oRes = New ReportService2010.ReportingService2010

         oRes.Credentials = System.Net.CredentialCache.DefaultCredentials

         oRes.Url = String.Format("{0}/ReportService2010.asmx", oArgs.ReportServerUrl)


         oItems = oRes.ListChildren(oArgs.FolderSearch, False)

Any hint here ?

I upgraded from SQL Server 2008 to R2, VS2008 and VS2010 installed on WinXPSP3

In reporting services got this error "The permissions granted to user sysname\ASPNET are insufficien



i'm using sql server 2008 with advance services 

the below error is of reporting services..

"The permissions granted to user 'sysname\ASPNET' are insufficient for performing this operation. (rsAccessDenied)"

when i'm trying to host  appliction.. the above error is occured..

it works fine when i try to execute locally.. but when i try to execute through the IIS i.e host application

the above error is displayed.

please help me....

In reporting services got this error "The permissions granted to user sysname\ASPNET are insufficien



i'm using sql server 2008 with advance services 

the below error is of reporting services..

"The permissions granted to user 'sysname\ASPNET' are insufficient for performing this operation. (rsAccessDenied)"

when i'm trying to host  appliction.. the above error is occured..

it works fine when i try to execute locally.. but when i try to execute through the IIS i.e host application

the above error is displayed.

please help me....

Error in installing the Reporting services for GP




i am trying to install the reporting services for GP. when i am entering the URL for deploy its giving error as "The target server location entered is not valid".

I am using SQL Server 2008 and the URL i have given is http://<servername>/Reports

i tried all the ways but failed. Please help me to resolve this issue

thanks in advacne

Add SQL Server Reporting Services Report Viewer webpart on SitePage give error.



i have use Sharepoint Foundation 2010 with VS 2010. i have config  in Reporting Services 2008 R2 SharePoint integrated-mode. when in add  SQL Server Reporting Services Report Viewer webpart  on SitePage it give error message. "The Controls collection cannot be modified becouse the control contains code blocks(i. e. <%...%>)." How i can add this web part on my SitePage?

Navaratan Sharma
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend