Major Problem in Saleslogix v8.1 Cloud Instances

I have been working with a new client who is on the hosted cloud solution for Saleslogix version 8.1.  They have been having a strange issue with the Saleslogix Application Architect I have not seen before.

When doing a build of the web platform, if any build errors occur you normally see red errors in the output window and then receive a message box popup like so:

In the cloud system, the Application Architect would instead flash the red messages in the output window, but when the message box would normally pop, application Architect would just crash and disappear.

The Application Architect would log the following to the event log:

.NET Runtime 1026:

Application: AppArchitect.exe
Framework Version: v4.0.30319
Description: The process was terminated due to an unhandled exception.
Exception Info: System.IO.FileNotFoundException
Stack:
   at Sage.Platform.Application.UI.WinForms.MsgBoxExceptionHandler.HandleException(System.Exception, Boolean)
   at Sage.Platform.Application.ExceptionManagerService.HandleException(System.Exception, Boolean)
   at Sage.Platform.Client.Windows.Program.CurrentDomain_UnhandledException(System.UnhandledExceptionEventArgs)
   at Sage.Platform.Client.Windows.Program.Main(System.String[])

Application Error: 1000(100)

Faulting application name: AppArchitect.exe, version: 8.1.0.1146, time stamp: 0x52b2a24c
Faulting module name: KERNELBASE.dll, version: 6.1.7601.18229, time stamp: 0x51fb1116
Exception code: 0xe0434352
Fault offset: 0x0000c41f
Faulting process id: 0x149c
Faulting application start time: 0x01cf42c4cf556130
Faulting application path: C:Program Files (x86)SaleslogixAppArchitect.exe
Faulting module path: C:Windowssyswow64KERNELBASE.dll
Report Id: c43e6990-aebc-11e3-8957-a3f4cfe6120b

if you built the web platform with no build errors, everything worked fine.  It was just when errors were encountered and the error message should display that the Application Architect crashed.

I finally got lucky and was doing a build with another Application Architect dialog open in the foreground.  When the build error hit, the Application Architect did not crash, instead I received the following:

 OK, finally we are getting some details.

The Micorosft.ExceptionMessageBox is a component installed with SQL Server components.  Specifically the version 9.0.242.0 is the message box component shipped with SQL 2005.

What?

Turns out that normally this file is installed to C:Program Files (x86)Microsoft SQL Server90SDKAssemblies and is a part of the SQL 2005 Server installation.

Well on the version 8.1 cloud instances, there is no  C:Program Files (x86)Microsoft SQL Server90SDK folder.

Luckily Microsoft actually has a redistributable for just this component.

You can find it from this download location:

http://www.microsoft.com/en-us/download/details.aspx?id=17943

 Choose the file  SQLServer2005_EMB_x64.msi

 Once installed then the Application Architect no longer crashes.