.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

SSRS Stopped working

Posted By:      Posted Date: April 10, 2011    Points: 0   Category :C#

SSRS 2005 SharePoint add-in has been working on my systems for 2 years. Currently the SSRS add-in is only working on 1 server. I have 5 servers in the Farm and until last week SSRS was working on both of my WFE servers. Now it only works on 1. The only change was we added .net 3.5 to our systems. I have checked the web.config on both server A and B. Server A works just fine Server B give me this error An unexpected error occurred while connecting to the report server. Verify that the report server is available and configured for SharePoint integrated mode.

I don't see any errors in the SharePoint logs, Event Logs or SSRS logs on Server B or Server D. I have repaired SSRS SharePoint add-in on Server B. No luck. I have configured the disableloopbackcheck on all my servers. I made sure all .net updates have been applied. Web.configs are the same on Server A and B. I don't know what else to check. We are not using Kerberos.

Server A WFE using Cisco ACE NLB
Server B WFE using Cisco ACE NLB

Server C Index & CA
Server D SSRS
Server F Project Server

View Complete Post

More Related Resource Links

Executing a job from a stored procedure stopped working

I've got a stored procedure in database A that calls the sp_start_job stored procedure in msdb as follows:   CREATE PROCEDURE xxxxx WITH EXECUTE AS 'domain\username'   AS   EXEC msdb.dbo.sp_start_job B'jobname' ;   RETURN   The domain\username is the in the database sysadmin role and the owner of the job.  To make this work originally, I had to change the msdb database to be trusted.   This worked for the past several months.   Now it doesn't work (perhaps after a reboot but not sure).  The error I get is "The EXECUTE permission was denied on the object 'sp_start_job', database 'msdb', schema 'dbo'   I looked to make sure that the account had grant execute rights and it does.  I tried setting it via GRANT statement and it was granted successfully yet the error still occurs.  I've tried changing accounts and anything else I can think of to no avail.   Any ideas how to troubleshoot this issue.  I've tried all the tricks I can think of.   Thanks - SM

SSRS Table Header working differently in and out of print layout

Please help. This is bizarre and seems like a bug to me. Using a table in SSRS, I have a details row, with a parent group and finally a header row.  For my header row, I am referencing a particular cell in the parent group. I am doing this so that i can have the header row repeat on each page of the group. This works fine when I'm not in Print Layout mode. However, when i switch to print layout mode, or print the report itself, the data that is presented on the screen is different then what is presented when not in print layout mode. WHAT THE F*!@!?? I've been battling this for a while now and i'm at my wits end. Has anyone else experienced different results from when you are in print layout mode as opposed to being in print layout mode?

Breakpoints stopped working during debugging in vs.net 2005

I had the strangest bug yesterday while trying to debug in vs.net 2005.... I had an '05 web application.  I clicked the "Run" button to start debugging, and the webpage popped up fine.  I could run through the pages fine.  Everything seemed fine....UNTIL!   Until I tried to start inserting breakpoints into my code.  The application ignored them.  In addition, I noticed my little green visual studio "Start Debugging" arrow (which is normally greyed out while in debug mode) was green.  It was as if visual studio completely detached itself from my website I was trying to debug. After playing around with it for a while, I realized I also had a vs.net 2008 solution open as well.  My '08 solution wasn't in debug mode or anything, it was just sitting there open.  I just happened to close it, not thinking anything of it, and presto!  My 2005 debugger started working again! So basically, I can't debug an '05 solution (or at least a web solution, as that's all I tried) while I also have an '08 solution open.  Anyone know why?  Is there anything I can do to prevent this?   Thanks.  

Integrated SSRS and kerberos working great.But one user gets An unexpected error occurred while conn

I have this one user who can access SharePoint with no problems otherwise but is getting errorAn unexpected error occurred while connecting to the report server When they try to access an SSRS reports I confirmed he has access. Client issue? AD Account issue?Thanks.

Suite Integration Toolkit executable has stopped working On Windows 2008 R2

I am not sure what else I can say about this except I seem to run into this error each time I attempt to install any .NET Related tool above 1.1. I have tried clean out all .NET installs to reinstall but I run up against this and at this point, I have a machine that is clean of .NET 2.0 through 4.0. I am unable to reinstall because I keep running up against this problem. I am not certain where to go from here Problem signature:   Problem Event Name: APPCRASH   Application Name: setup.exe_Microsoft® Visual Studio® 2008   Application Version: 9.0.30729.1   Application Timestamp: 488f1f5c   Fault Module Name: urlmon.dll   Fault Module Version: 8.0.7600.16385   Fault Module Timestamp: 4a5bdf64   Exception Code: 80000003   Exception Offset: 0008b5df   OS Version: 6.1.7600.   Locale ID: 1033   Additional Information 1: 3da0   Additional Information 2: 3da0da3513034f247aa571ff6433c6a8   Additional Information 3: efee   Additional Information 4: efee7faa0523fea9d1582687f878296e Read our privacy statement online:   http://go.microsoft.com/fwlink/?linkid=104288&clcid=0x0409 If the online privacy statement is not available, please read our privacy statement offline:   C:\Windows\system32\en-US\erofflps.txtN

webserver40.exe has stopped working

I've just upgraded a visual studio.net 2003 project (asp.net 1.1) to visual studio.net 2010 (asp.net 4.0). I'm encountering a problem with viewing Crystal reports. I'm using Visual Studio Development Server as a Web Server. When I try to create a new report (via code that worked fine previously) the line below causes the webserver40.exe to crash. Protected WithEvents MyRep As New CrystalDecisions.CrystalReports.Engine.ReportDocument I've got Crystal Reports 11 installed. Thanks in advance for your help with this matter. Lee    

SSRS custom security extension behind a router fire wall not working

I have a instance of SSRS 2008 installed (we are not using IIS) with custom security extension which accepts a application user ID and password and sends back a sql authorization cookie back to client for logging into SSRS.  The (SSRS) server is behind a router,  SSRS is configured on port 81,  Port 81 in router if forwarded to the SSRS server. Here is the problem If I am inside the router firewall (RDP'ed to the machine) I am able to access report server (http://xx.xxx.xxx.xx:81/ReportServer) and reports manager (http://xx.xxx.xxx.xx:81/Reports) without any issues. If  am outside the firewall and try to go to report server page (http://xx.xxx.xxx.xx:81/ReportServer) from browser and try to login it works (I am getting the cookie back and authentication goes through fine).   But if I try to access reports manager (http://xx.xxx.xxx.xx:81/Reports) the login page shows up when I enter user ID and password and hit enter to authenticate it comes back to the login screen (I am not gettint the cookie back from SSRS). Any help is highly appreciated on how to debug /fix this issue. Note : if I first login to Reportserver (which sends the cookie back) and in the same session I login to Reports Manager I am able to get into Reports Manager page since I got the cookie when I logged in to reports server page already.  When I

Katmai SSMS - Intellisense stopped working

HiI was wondering if anyone has had a similar problem. I have been happily using the Intellisense features of Katmai without any problems for a month now. However, a couple of days ago, it stopped working. I have tried numerous things to revive it including deleting everything under: -%appdata%\Microsoft\Microsoft SQL Server%userprofile%\Local Settings\Application Data\Microsoft\Microsoft SQL ServerHKCU\Software\Microsoft\Microsoft SQL Serverand restarting SMSS but I had no success. Tbh, I am not even sure where Intellisense cache is kept?Anyone have any suggestions?Thanks in advance.Blair

SSIS Debug Host has stopped working

The error code that's output with the SSIS Debug Host has stopped working popup is: Problem signature:   Problem Event Name:    APPCRASH   Application Name:    DtsDebugHost.exe   Application Version:    2007.100.1600.22   Application Timestamp:    48753d31   Fault Module Name:    StackHash_23cc   Fault Module Version:    6.1.7600.16559   Fault Module Timestamp:    4ba9b21e   Exception Code:    c0000374   Exception Offset:    000c2913   OS Version:    6.1.7600.   Locale ID:    1033   Additional Information 1:    23cc   Additional Information 2:    23cc9330c2de3c407e38eb60a3c201e4   Additional Information 3:    10bd   Additional Information 4:    10bdb3132e81c1ecfd041615b784b3fd In the output for the BIDS debugger: SSIS package "Package.dtsx" starting. Information: 0x4004300A at Sg Clients to NewCP stgClients, SSIS.Pipeline: Validation phase is beginning. Warning: 0x80049304 at Sg Clients to NewCP stgClients, SSIS.Pipeline: Warning: Could not open global shared memory to communicate with performance DLL; data flow performance counters are not available.  To

vs 2010 stopped working when i close website

Hi, i have installed latest vs 2010 ultimate on windows 7 it works fine but as i want to close a website  it sayas vs has stopped working restart/debug what should i do?

Windows Forms application Stopped Working message in Windows Vista



A Windows Forms application developed with VB2008 Express that has been successfully run on two Windows XP systems and a Windows 7 system fails to run on two of two Windows Vista systems tried so far.


Attempting to run the app on a Windows Vista system results in a system dialog box titled, Microsoft Windows, with the message, A problem caused the program to stop working correctly.  Windows will close the program and notify you if a solution is available.  A single button at the lower right of the dialog contains the text, Close Program.
The initial form of the application never displayed and the dialog above appeared with little delay after attempting to start the program.

The program uses an SQL Server Compact Edition 3.5 database and the program is compiled to include the following .DLL files so the user does not need to install SQL ServerCE.

The Load event of the initial form causes a DataSet to be filled from the SQL CE DB.

I have the System Informa

VS2010 has stopped working error adding new item to folders in MVC2



   I am using VS2010 Pro in 64 bit Windows 7. When I add a new item to a folder in an ASP.NET MVC2 project, VS frequently crashes with a "Visual Studio has stopped working" error and then closes down. If I re-open the project the item is not visible in the MVC project folder, (but it is visible to windows explorer although I think it's corrupted). If I then try to add the item again, it warns me that it already exists and asks to overwrite, choosing yes to overwrite usually works OK.  When adding an .edmx item it is more problematic, I can't overwrite it but because I know that there actually is a file in the folder, (although not visible and albeit corrupted), I can add it as an existing item and then choose "update model from database" to get it to work. This error is happening more and more frequently.

Format Code D0 is not working in SSRS 2008


We are trying to migrate all our RDL from SSRS 2005 to SSRS 2008.

In the rdl’s we defined format code for a  text box as “D0”  which is working fine in SQL 2005.

While migrating the rdl’s to 2008 it is not working and data is showing for that text box as “#Error”.

How to resolve this . I am having around 1000+ rdl’s to update with proper format string.

If I open the Rdl in BIDS I am getting below error.


[rsInvalidFormatString] The Format value for the textrun ‘textbox1_0_13.Paragraphs[0].TextRuns[0]’ is not valid. Format specifier was invalid.

[rsRuntimeErrorInExpression] The Value expression for

Usage Reports / Graphical User Statistics stopped working


Hi all,

our usage reports (e.g. at /_layouts/SpUsageSite.aspx ) stopped working after we migrated the database from one server to another. The "raw statistics" (_layouts/usagedetails.aspx), however, are still showing some numbers.

All services are still running, all relevant settings in Central Admin (SSP, Operations) are still active. Does anyone knoe what could be the cause for this?


My user controls stopped working in Design mode! Why?


I have a few user controls that I have been using for months but now whenever I open a page in Blend that uses one of the controls I get an invalid xaml error. The project still compiles and runs and behaves just like it's supposed to but I can't edit xaml in Design view because of this error.


In the page I have

<local:ACAVariableWidth x:Name="CIDCloseButton" HorizontalAlignment="Right" Margin="0,0,17.54,15" VerticalAlignment="Bottom" Width="174" Height="89" MouseLeftButtonDown="callerID_close" Text="Close"/>

The error is: The member "Text" is not recognized or is not accessible

In the user control xaml I have:

		<StackPanel x:Name="TopSP" Orientation="Horizontal" VerticalAlignment="Top" HorizontalAlignment="Center" Height="76" d:IsLocked="True">
			<TextBlock x:Name="ACATB" Margin="8,8,8.5,9.5" FontFamily="APHont" FontSize="32" Padding="5,0" Foreground="White" TextAlignment="Center" VerticalAlignment="Center" Text="{Binding ElementName=UserControl, Path=Text}" d:IsLocked="True">
					<DropShadowEffect Direction=&

Visual Studio WebBrowser control's PrintPreviewDialog generates "VSHost32.exe has stopped working"


I'm getting a problem with a VS 2008 application when I use the WebBrowser control's .ShowPrintPreviewDialog method and either print or close the dialog box.  I'm working on a 64-bit Windows 7 computer and using Visual Studio's default Debug option settings.  The problem happens both when running from the IDE in debug mode and after compiling in x86 mode as a stand-alone.

The control is central to as an otherwise effective report management system, so on btnPrint_Click I assign HTML code to .DocumentText and then call .ShowPrintPreviewDialog, which works fine, other than it does need 2 clicks so it seems both stages have to happen as separate events? 

Although when I go to print, the document prints okay, the print preview dialog form closes itself and whole program crashes with the above message.  I've also tried separating those stages to avoid the 2-click issue, but I still get the crash.

If I turn Project>Properties>Debug>"Enable unmanaged code debugging" ON, I get this message instead "Unhandled exception at 0x752c77df (urlmon.dll) in PMPos.exe: 0xC0000005: Access violation reading location 0x00000001."

The control's other print dialog methods work fine.   Is there a solution that I can rely on when distributing the application or am I best abondoning this particular

Dynamic compilation of aspx-files stopped working!



I recently ran into some strange problems. Changes to files that are not code-behind (and not gets compiled to a DLL) should not require you to recompile the whole website, and this has never been I problem for me. These should actually get compiled dynamically when you first access the resource, e.g. the first time when browsing an updated aspx-page in the browser. 

But yesterday, during development of a website, I noticed that even the smallest changes in html, javascript or anything in the .aspx-files doesn't get reflected when I save and reload the page in my browser. Rebuilding doesn't help either, actually I'll have to do a "Rebuild All" (in Visual Studio 2008) in order to see the changes. This applies to all aspx-files in my project.

I tried with minor changes on files in another web application project on the same server, and there it works as it should. Something must has happened to this particular application, but I cannot figure out what.
Do you have any ideas on how to solve this?

Best regards

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