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