http://www.sqlservercentral.com/blogs/sql_awesomesauce/2011/09/08/i-need-_2300_sqlhelp_2100_--bids-shuts-down-unexpectedly-_1320_-solved/

Printed 2014/12/21 02:02PM

I need #sqlhelp! BIDS shuts down unexpectedly – SOLVED

By Jen McCown, 2011/09/08

Edit: See end of blog for solution.

I have MS Visual Studio 2008 (BIDS) x86 with SP1.  Recently it’s started shutting down without warning whenever I hit “preview” on a SSRS report. Google hasn’t helped, and I didn’t get much love on #sqlhelp (the Twitter hashtag for SQL help), so I thought I’d ask my adoring public: WTH??

This problem DOES NOT appear to be limited to a particular solution, nor to a particular report. However, I have narrowed it down to only reports that use parameters.

If and when I find a resolution, I’ll post it here for posterity and for all time.

Error from App log:

Event Type: Error
Event Source: .NET Runtime
Event Category: None
Event ID: 1023
Date:  9/8/2011
Time:  10:25:43 AM
User:  N/A
Computer: KKW10006
Description:
.NET Runtime version 2.0.50727.3623 – Fatal Execution Engine Error (7A05ADE0) (80131506)

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

A grateful MidnightDBA thanks you,
Jen

Solution: Well, that was fast. I posted this before trying my very-last-ditch effort, which was to uninstall Redgate’s SQL Prompt 5. Sure enough, this was the problem. Here’s a Redgate forum conversation that describes the same behavior. I’ll reinstall and apply the fix mentioned, and update here to let you know if that works.


Copyright © 2002-2014 Simple Talk Publishing. All Rights Reserved. Privacy Policy. Terms of Use. Report Abuse.