I need #sqlhelp! BIDS shuts down unexpectedly – SOLVED

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.

Resolution: Okay, so the problem itself isn’t fixed. BUT, you can disable the SQL Prompt add-in for BIDS in the Tools menu, and this I have done. So, you know, problem solved.

4 thoughts on “I need #sqlhelp! BIDS shuts down unexpectedly – SOLVED”

  1. I’ve got this problem as well but dissabling, (turning off), SQL Prompt does not appear to resolve it at all. After right clicking the ‘Toolbox’ area and selecting choose items BIDS aborts writing an event 1023 into the event log. Any further information on this?

    Much thanks in advance,

    Paul

  2. Superb find, had same problem. Unticked Prompt 5 from the addin then “turned off” Prompt, re started and all is well…

    Cheers, saved me a lot of time!

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>