.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

Cannnot load SSRS 2008R2 reports under app domain context of a web application

Posted By:      Posted Date: October 27, 2010    Points: 0   Category :.NET Framework

I'm a novice to SSRS 2008R2 and have SSRS 2008R2 reports which got upgraded from SSRS 2005. I need to load those reports from a web application. The reports use custom data processing extensions. Reports run fine from Visual Studio 2008 IDE. I'm running a Windows Server 2008R2 machine.

In order to load configuration information specific to the web application, underlying framework used as a data access layer utilizes AppDomain.CurrentDomain.FriendlyName to decide the name of the web application. The frame work is a separate assembly referenced in my web application project.

Previously, while using SSRS 2005, since IIS was used to host the report server virtual directories, the web application name was easily determined from the current application domain. With SSRS 2008R2, the virtual directories are hosted by the report server itself by making use of http.sys ( not quite sure how this works exactly yet). The friendly name I get from the app domain is not what I expect, i.e., my web application name. Instead, I get something like this: ReportServer_MSSQLSERVER2K8R2_0

Any suggestion how to resolve this issue?




View Complete Post

More Related Resource Links

Reporting: Deliver User-Friendly Reports from Your Application with SQL Server Reporting Services


SQL Server 2000 Reporting Services--a server-based reporting platform built on the .NET Framework and integrated with SQL Server 2000--lets you easily add reporting from diverse data sources. Using Visual Studio and Reporting Services you can integrate reports from any data source that has an OLE DB, ODBC, or ADO.NET provider into your Web applications. This article explains how it's done.

John C. Hancock

MSDN Magazine August 2004

Crystal Reports: Add Professional Quality Reports to Your Application with Visual Studio .NET


Crystal Reports for Visual Studio .NET provides a comprehensive reporting solution for .NET developers that is thoroughly integrated with both the Visual Studio .NET IDE and the .NET Framework. Crystal Reports supports ADO.NET, XML Web Services, and ASP.NET server controls and caching. It also integrates seamlessly with the Visual Studio .NET Server Explorer, toolbox, and design environment. It has a rich programming model and flexible options for customizing and deploying reports. These major features and others covered here take the drudge work out of data representation in your own applications.

Andrew Brust

MSDN Magazine May 2002

Share Point integrated SSRS reports rendering when access from external site


Our client has a SharePoint (moss2007) site on Windows 2008, SQL2008 R2 Enterprise, and Reporting service is integrated with SharePoint

The authentication on the share point integration is set to windows, else the authentication for the SSAS datasource gives and error

The extranet zone ( forms) and intranet (Customer Forms) and default (Windows) zones are all access from inside the firewall and the reports render in each with no issues, as the datasources are configured to pass a sql username and password.

However, report rendering is a problem from the internet (external site), the following error is displayed:

An unexpected error occurred while connecting to the report server. Verify that the report server is avai

SSRS - Where are the Sharepoint Report Usage Reports provided by Microsoft



Microsoft provided 3 example reports for Sharepoint report usage. Does anyone know where they are located? I used them about 2 years ago.




One or more types failed to load - While creating a web application as well as running psconfig wiza



I got this error while i was trying to create a web application - 'One or more types failed to load'. So i tried to run psconfig and got the same error.

My Spec

Windows Server 2008 R2 x64

SharePoint Server 2007 x64 with MOSS SP1, MOSS SP2, WSS SP1 and WSS SP2

Microsoft Office Professional 2010 x64

Microsoft SQL Server 2005


And, here is the complete error -


Log Name:      Application
Source:        SharePoint Products and Technologies Configuration Wizard
Date:          8/27/2010 3:30:28 PM
Event ID:      104
Task Category: None
Level:         Error
Keywords:      Classic
User:          N/A
Computer:      ZBDEV22.zenbridge.com
Failed to register SharePoint services.
An exception of type Microsoft.SharePoint.Upgrade.SPUpgradeException was thrown.  Additional exception information: One or more types failed to load. Please refer to the upgrade log for more details.
Microsoft.SharePoint.Upgrade.SPUpgradeException: One or more types failed to load. Pleas

SQL Server 2005 Performance Dashboard Reports user context

HI, We are planning on installing the Dashboard reports. But we'd like to know if the Dashboard is run under admin user or the login user who runs the Dashboard reports? Thanks! Kong

Linked Report Subreport- Error: Subreport could not be shown on SSRS 2008r2

I've got 2 folders: /Finance /Japan In the Finance folder I have a Sales report that has 3 subreports, and a salesregion parameter. I created a linked report in /Japan to /Finance/Sales, hide the salesregion parameter, and set the default to Japan, so they can only see their region's sales data. But when a Japan user runs the Sales report, they get Error: Subreport could not be shown because they do not have access to the /Finance folder. Any ideas?

Printing Issue in SSRS reports

Hi,   We developed around 70 ssrs reports for our new application.Its like,all the report names are mentioned in the left hand side and if we click it,.Net calls the SSRS reports and shows in the Right hand side.   The issue now is with the Printing.My client complains that they are not able to print the Reports properly.Some of the columns are moved to the next page,it seems.Reports are having different number of columns and we dont know how to resolve this issue.Should I use Landscape or Portrait?..If I give the table's width in the place of Report's width,will it work?    Your help would be greatly appreciated.

dllimport("mapi32.dll") changes the path context of application (i.e. relative paths start pointing

I have a WPF desktop application. We use mapi32.dll to show a new outlook mail window to allow user to send an email. After user sends email / just closes the new mail window without sending email, relative path starts pointing to C:\Program Files\Microsoft Office\Office12. I have office 2007 installed.  How can I restore this relative path ?   Thanks & Regards, Nadeem Ullah

Schedule reports with integrated authentication SSRS 2008

Hi All,  Having an issue with SSRS 2008 at the moment, trying to setup subscriptions. Our system is configured so that any one of 10 users can login to the SSRS website using their windows domain account, and then launch report builder to design and save reports.  This all works very well, however, they have a problem when trying to setup subscriptions - the famous "Subscriptions cannot be created because the credentials used to run the report are not stored....." What the message says is true - the credentials are not stored as they are supplied by the user when they login to report builder. Is the /any/ workaround at all that doesn't involve storing the credentials?  It seems totally crazy that they cannot be prompted for them when setting up the subscription.  For this application its 100% essential to make the user provide their credentials when running reports, because they each see a filtered subset of the data in the report model (this is controlled DB side depeding on the login account), so their domain account needs to be passed to SQL server to enable this filtering to work.  If we saved their credentials then they would see all the data..and thats nasty. The only workaround I can come up with would be to create  a separate datasource for each user and upload a separate model, but thats really nasty to be hones

SSRS Report Builder "Application cannot be started, contact application vendor"

Hi   In Report Manager, when i click on report builder its show me an error like "Application cannot be started, contact application vendor " I installed .net framework 2.0, I'm using windows 7,Sql server 2005 Can any one please help on this...   Thanks Sharon

Converting crystal reports to ssrs reports

Hi, I need a documentation which helps me to convert crystel reports to ssrs. if any one having the procedural documentation you can email to my below mentioned email address that will be helpful to me in my new starting project. naveenjustlikethat@hotmail.com

How to programmatically hide SSRS reports

I've built a process to deploy several reports to SSRS in either native mode or SharePoint integrated mode.  I'd like to programmatically hide several SSRS reports when deploying them to a sharepoint site.  I believe I need to do something like this -  http://www.mssqltips.com/tip.asp?tip=1357.  Any pointers?  I'm new to SharePoint development. Thx.

SSRS 2008 SP1 - Enabling "My Reports" allows users delete reports in folders they should not be able

Issue: Users that have “My Reports” SSRS Role assigned to them can delete reports in other “shared” folders. My understanding was that they will be able to do the tasks specified only  in the “My Reports” workspace not everywhere. I have “My Reports” enabled via SSMS. Users have “My Reports” role assigned to them at the root level. My SSRS Role “My Reports” has only the following tasks assigned: 1.       View Reports 2.       Manage reports 3.       View Folders 4.       Manage Folders To test, I'm using Development version of SQL Server 2008 SP1. Thanks in advance, Martina

Reports & Application Developemtn

Okay I need some strong advice  here.. I have 2 queires.. One query gives the list of all the reports that we have and are scheduled to be delivered we use SQl agent job... 2 Query is a View which gives the list of all users who get the reports...What i am trying to do is May be combine both queries or link them so that i can control the reports level security. Each user has a Security level and based on that level we give access. These reports are viewed on our company portal...Any ideas ?FM

The application domain in which the thread was running has been unloaded

Recently upgraded to VS 2005. With a large project, I keep getting this message when I try and build.Looked through the forums - have tried cleaning and rebuilding - no joy.Have also tried increasing size of virtual memory - no joy.Any ideas?Thanks   

Where are the 2008 SSRS sample reports?

All the CodePlex 2008 links now go to the 2008R2 examples. Are the 2008 report samples still around somewhere?
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