After installing SQL Prompt 5, I was unable to open .aspx or .ascx files in Visual Studio 2008 - the whole app would just disappear. I tried unchecking "Use SQL Prompt", but that didn't help. I had to uninstall it to get VS working again. Back to v4.0...
Comments
20 comments
-
Hi!
I'm having the same kind of problems, after installing "SQL Prompt 5", whenever I try to preview a report that I'm building in BIDS 2008 (the "SQL Server 2008 R2" edition), the Visual Studio environment completly vanished and everything is gone.
::David
Stockholm, Sweden -
David_S wrote:Hi!
I'm having the same kind of problems, after installing "SQL Prompt 5", whenever I try to preview a report that I'm building in BIDS 2008 (the "SQL Server 2008 R2" edition), the Visual Studio environment completly vanished and everything is gone.
::David
Stockholm, Sweden
Just to add that I'm experiencing the same problem as David following an upgrade to SQL Prompt 5. I have to uninstall SQL Prompt 5 in order to be able to preview reports.
Following such a crash the Windows Application event log contains the following event:Event Type: Error
Event Source: .NET Runtime
Event Category: None
Event ID: 1023
Date: 30/12/2010
Time: 08:46:51
User: N/A
Computer: DEVDT54
Description:
.NET Runtime version 2.0.50727.3615 - Fatal Execution Engine Error (7A0360B0) (80131506)
For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
I'm looking forward to a resolution of this issue so that we can confidently upgrade the version of SQL Prompt that our dev team is currently using.
Chris -
Hi!
I found a work-around for this in another thread here in this forum.
What you need to do is go into Tools > Add-Ons in BIDS, and unchecked "SQL Prompt 5", and then restart BIDS. Then it works again.
http://www.red-gate.com/MessageBoard/vi ... hp?t=12430
What you do is disable the plugin, so after that, it will not work within BIDS (though - I don't see any reason for using it within BIDS anyways, but I just wanted to point it out). Also - even if you uncheck it in BIDS, it still works in SSMS (SQL Management Studio).
::David_S -
Thanks for the BIDS workaround, and for confirming that SQL Prompt 5 still works in SSMS afterwards!
Regards,
Paul -
I've recently upgraded SQL prompt to version 5.1 (build 5.1.4.11).
Beforehand I'd disabled SQL Prompt in BIDS and everything worked fine.
Since the upgrade, every time I load BIDS the checkbox is ticked (even if I unticked it then restarted BIDS properly) and previews still crash BIDS regardless. -
Worked out the problem. I didn't have admin rights so when I tried to update Visual Studio to remove the add-in, the settings weren't saved.
Ran VS as admin and made the changes, now it all works fine. -
Just installed SQL prompt 5.1.6.35 , and it caused same problems with VS2008 crashing out when trying to preview SQL2008R2 report.
Disabled as described above and at least I can get on with my work now!! -
To reproduce... I have VS2010 open while creating a snippet. This the from the Event Viewer:
- System
- Provider
[ Name] SSMS Integration Pack 1
- EventID 16
[ Qualifiers] 0
Level 3
Task 0
Keywords 0x80000000000000
- TimeCreated
[ SystemTime] 2011-07-07T19:04:34.000000000Z
EventRecordID 43
Channel Red Gate Software
Computer junk.junk.net
Security
- EventData
ngWrapper.LogManager #18:Unhandled Exception: Common Language Runtime detected an invalid program.. IsTerminating : False System.InvalidProgramException: Common Language Runtime detected an invalid program. at RedGate.SqlPrompt.Engine.Snippets.SnippetManager.<m_Sentinel_Changed>b__4(Object ) at System.Threading._ThreadPoolWaitCallback.WaitCallback_Context(Object state) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading._ThreadPoolWaitCallback.PerformWaitCallbackInternal(_ThreadPoolWaitCallback tpWaitCallBack) at System.Threading._ThreadPoolWaitCallback.PerformWaitCallback(Object state)
This event is not displayed correctly because the underlying XML is not well formed. Below is the raw text of the event.
32200x8000000000000044Red Gate Softwarejunk.junk.net. #1:Failed to initialize IPC System.Runtime.Remoting.RemotingException: Failed to create an IPC Port: Access is denied. at System.Runtime.Remoting.Channels.Ipc.IpcServerChannel.StartListening(Object data) at System.Runtime.Remoting.Channels.Ipc.IpcServerChannel..ctor(IDictionary properties, IServerChannelSinkProvider sinkProvider, CommonSecurityDescriptor securityDescriptor) at ..()
This event is not displayed correctly because the underlying XML is not well formed. Below is the raw text of the event.
32200x8000000000000045Red Gate Softwarejunk.junk.net. #1:Failed to acquire mutex - IPNService quitting System.Runtime.Remoting.RemotingException: Failed to create an IPC Port: Access is denied. at System.Runtime.Remoting.Channels.Ipc.IpcServerChannel.StartListening(Object data) at System.Runtime.Remoting.Channels.Ipc.IpcServerChannel..ctor(IDictionary properties, IServerChannelSinkProvider sinkProvider, CommonSecurityDescriptor securityDescriptor) at ..() at ...ctor(Timer timer, requestHandler, EventHandler exitHandler) at ...ctor() at ..() at RedGate.IPNShared.CommonUtils.DoWithMutex(MutexType mutexType, TimeSpan delay, Action action) at RedGate.IPNShared.CommonUtils.DoWithMutex(MutexType mutexType, Action action) at ..() -
I haven't installed your Integration tool... could that be the problem?
-
Hi Bill,
Thanks for the report about Visual Studio crashing when adding a snippet. I can confirm that this is an issue with SQL Prompt 5.1.6 when running inside Visual Studio (it doesn't happen on SSMS). This has been assigned issue number SP-4009 and we'll address it in the next bug-fix release.
Apologies for the inconvenience.
Regards,
Paul -
issue number SP-4009
Hi Paul,
Do you have an ETA on this fix? -
Hi rcampbellwhite,
Yes, I'm pleased to say that SP-4009 was fixed in SQL Prompt 5.1.8 and is now available. Please see my announcement.
Regards,
Paul -
I have SQL Prompt 5.1.8.2 installed, but still having the same problem in BIDS 2008. When adding an expression to define the colour of a text field, previewing the report causes BIDS to crash. I've disabled SQL Prompt in BIDS, and everything is fine.
-
Just updated to the latest version SQL Prompt 5.2.0.5 and still getting crashes in BIDS 2008 R2 when you click Previrew to view a report. Again disabling SQL Prompt in BIDS is a work around
-
I recently updated to version 5.2.4.1, now getting the VS 2008 crash, as reported by others. I have tried disabling SQL Prompt but still getting a crash when trying to preview a report. Is there any resolution, before I unistall? Been using SQL Prompt for years now, but this is a real problem for me.
-
We managed to get it sorted on one Windows XP machine by installing all Windows Updates (I think the problem was fixed by a .net update). Have another machine with the same problem, which I'll look at today to see if this corrects it.
-
Disabling in BIDS work around still working for us.
-
I have the same problem from within a VS 2008 report project where the reports are published to SSRS 2008 R2.
Currently running SQL Prompt 5.3.2.2
Disabled SQL Prompt add-in within VS 2008
From "About Microsoft Visual Studio"
Microsoft Visual Studio 2008
Version 9.0.30729.4462 QFE
Microsoft .NET Framework
Version 3.5 SP1
Installed Edition: Professional
Microsoft Visual Basic 2008
Microsoft Visual C# 2008
Microsoft Visual C++ 2008
Microsoft Visual Studio 2008 Tools for Office
Microsoft Visual Studio Tools for Applications 2.0
Microsoft Visual Web Developer 2008
Crystal Reports Basic for Visual Studio 2008
Hotfix for Microsoft Visual Studio 2008 Professional Edition - ENU (KB944899) KB944899
Hotfix for Microsoft Visual Studio 2008 Professional Edition - ENU (KB945282) KB945282
Hotfix for Microsoft Visual Studio 2008 Professional Edition - ENU (KB946040) KB946040
Hotfix for Microsoft Visual Studio 2008 Professional Edition - ENU (KB946308) KB946308
Hotfix for Microsoft Visual Studio 2008 Professional Edition - ENU (KB946344) KB946344
Hotfix for Microsoft Visual Studio 2008 Professional Edition - ENU (KB946581) KB946581
Hotfix for Microsoft Visual Studio 2008 Professional Edition - ENU (KB947171) KB947171
Hotfix for Microsoft Visual Studio 2008 Professional Edition - ENU (KB947173) KB947173
Hotfix for Microsoft Visual Studio 2008 Professional Edition - ENU (KB947180) KB947180
Hotfix for Microsoft Visual Studio 2008 Professional Edition - ENU (KB947540) KB947540
Hotfix for Microsoft Visual Studio 2008 Professional Edition - ENU (KB947789) KB947789
Hotfix for Microsoft Visual Studio 2008 Professional Edition - ENU (KB948127) KB948127
Hotfix for Microsoft Visual Studio 2008 Professional Edition - ENU (KB953256) KB953256
Hotfix for Microsoft Visual Studio 2008 Professional Edition - ENU (KB971091) KB971091
Hotfix for Microsoft Visual Studio 2008 Professional Edition - ENU (KB971092) KB971092
This hotfix is for Microsoft Visual Studio 2008 Professional Edition - ENU.
Hotfix for Microsoft Visual Studio 2008 Professional Edition - ENU (KB973674) KB973674
Hotfix for Microsoft Visual Studio 2008 Professional Edition - ENU (KB974479) KB974479
Microsoft Visual Studio 2008 Professional Edition - ENU Service Pack 1 (KB945140) KB945140
Microsoft Visual Studio 2008 Professional Edition - ENU Service Pack 1 (KB947888) KB947888
This service pack is for Microsoft Visual Studio 2008 Professional Edition - ENU.
Microsoft Visual Studio 2008 Professional Edition - ENU Service Pack 1 (KB948484) KB948484
Microsoft Visual Studio 2008 Professional Edition - ENU Service Pack 1 (KB948560) KB948560
Security Update for Microsoft Visual Studio 2008 Professional Edition - ENU (KB973675) KB973675
Security Update for Microsoft Visual Studio 2008 Shell (integrated mode) - ENU (KB972222) KB972222
SQL Server Analysis Services
Microsoft SQL Server Analysis Services Designer
Version 10.50.1600.1
SQL Server Integration Services
Microsoft SQL Server Integration Services Designer
Version 10.50.1600.1
SQL Server Reporting Services
Microsoft SQL Server Reporting Services Designers
Version 10.50.1600.1
Update for Microsoft Visual Studio 2008 Professional Edition - ENU (KB956453) KB956453
Update for Microsoft Visual Studio 2008 Professional Edition - ENU (KB967143) KB967143
Update for Microsoft Visual Studio 2008 Professional Edition - ENU (KB972221) KB972221 -
Im having the exact same problem as the person that posted this.
Just installed SQL prompt 5.1.6.35 , and it caused same problems with VS2008 crashing out when trying to preview SQL2008R2 report.
I have uninstalled it,and now I am not having problems anymore. Guess I wont be using SQL prompt. -
I've found that the work around posted by David_S on Mon Jan 03, 2011 1:31 pm works within VS 2008. Doing this allows SQL Prompt to still be used within SSMS.
Although you may have to do it again when Redgate issues an update to SQL Prompt that installs a new version that resets its use in VS. I wasted a good part of this morning until I figured that out!
I've further noticed that if a report doesn't have any user selectable parameters VS doesn't crash/vanish. Very odd.
Add comment
Please sign in to leave a comment.