Comments
6 comments
-
Hi,
This is a very confusing and vague problem. You would typically get a partially-trusted error when assemblies try to cross zones, ie when you run a .NET assembly across a network share, in which case the "Intranet" zone security kicks in and does not allow the assembly to run unless you "fully trust" the Intranet zone (NOT recommended!).
The other annoying thing is that .NET doesn't tell us what "That Assembly" is. It may be SQL Prompt, but maybe not.
I think that the best thing would be to create some fusion logs and get the faulting assembly and failure information.
Create some new keys:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Fusion\LogFailures DWORD 1
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Fusion\LogPath REG_SZ <path to logs>
Then run SSMS and look in <path to logs>\default\sqlwb.exe . The assemblies that fail to bind should have their own .htm files, listing the reason for the failure. -
I have created the fusion log dumps, and they are as follows:
C:\temp\Default\SqlWb.exe\RedGate.SQLPrompt.SSMSUI, Version=3.9.0.43, Culture=neutral, PublicKeyToken=7f465a1c156d4d57.HTM*** Assembly Binder Log Entry (12/31/2008 @ 9:57:19 AM) *** The operation failed. Bind result: hr = 0x80070002. The system cannot find the file specified. Assembly manager loaded from: C:\Windows\Microsoft.NET\Framework\v2.0.50727\mscorwks.dll Running under executable C:\Program Files\Microsoft SQL Server\90\Tools\Binn\VSShell\Common7\IDE\SqlWb.exe --- A detailed error log follows. === Pre-bind state information === LOG: User = ERXNETWORK\benjamin.hayes LOG: DisplayName = RedGate.SQLPrompt.SSMSUI, Version=3.9.0.43, Culture=neutral, PublicKeyToken=7f465a1c156d4d57 (Fully-specified) LOG: Appbase = file:///C:/Program Files/Microsoft SQL Server/90/Tools/Binn/VSShell/Common7/IDE/ LOG: Initial PrivatePath = NULL LOG: Dynamic Base = NULL LOG: Cache Base = NULL LOG: AppName = NULL Calling assembly : (Unknown). === LOG: This bind starts in default load context. LOG: Using application configuration file: C:\Program Files\Microsoft SQL Server\90\Tools\Binn\VSShell\Common7\IDE\SqlWb.exe.Config LOG: Using machine configuration file from C:\Windows\Microsoft.NET\Framework\v2.0.50727\config\machine.config. LOG: Post-policy reference: RedGate.SQLPrompt.SSMSUI, Version=3.9.0.43, Culture=neutral, PublicKeyToken=7f465a1c156d4d57 LOG: GAC Lookup was unsuccessful. LOG: Attempting download of new URL file:///C:/Program Files/Microsoft SQL Server/90/Tools/Binn/VSShell/Common7/IDE/RedGate.SQLPrompt.SSMSUI.DLL. LOG: Attempting download of new URL file:///C:/Program Files/Microsoft SQL Server/90/Tools/Binn/VSShell/Common7/IDE/RedGate.SQLPrompt.SSMSUI/RedGate.SQLPrompt.SSMSUI.DLL. LOG: Attempting download of new URL file:///C:/Program Files/Microsoft SQL Server/90/Tools/Binn/VSShell/Common7/IDE/PublicAssemblies/RedGate.SQLPrompt.SSMSUI.DLL. LOG: Attempting download of new URL file:///C:/Program Files/Microsoft SQL Server/90/Tools/Binn/VSShell/Common7/IDE/PublicAssemblies/RedGate.SQLPrompt.SSMSUI/RedGate.SQLPrompt.SSMSUI.DLL. LOG: Attempting download of new URL file:///C:/Program Files/Microsoft SQL Server/90/Tools/Binn/VSShell/Common7/IDE/PrivateAssemblies/RedGate.SQLPrompt.SSMSUI.DLL. LOG: Attempting download of new URL file:///C:/Program Files/Microsoft SQL Server/90/Tools/Binn/VSShell/Common7/IDE/PrivateAssemblies/RedGate.SQLPrompt.SSMSUI/RedGate.SQLPrompt.SSMSUI.DLL. LOG: Attempting download of new URL file:///C:/Program Files/Microsoft SQL Server/90/Tools/Binn/VSShell/Common7/IDE/RedGate.SQLPrompt.SSMSUI.EXE. LOG: Attempting download of new URL file:///C:/Program Files/Microsoft SQL Server/90/Tools/Binn/VSShell/Common7/IDE/RedGate.SQLPrompt.SSMSUI/RedGate.SQLPrompt.SSMSUI.EXE. LOG: Attempting download of new URL file:///C:/Program Files/Microsoft SQL Server/90/Tools/Binn/VSShell/Common7/IDE/PublicAssemblies/RedGate.SQLPrompt.SSMSUI.EXE. LOG: Attempting download of new URL file:///C:/Program Files/Microsoft SQL Server/90/Tools/Binn/VSShell/Common7/IDE/PublicAssemblies/RedGate.SQLPrompt.SSMSUI/RedGate.SQLPrompt.SSMSUI.EXE. LOG: Attempting download of new URL file:///C:/Program Files/Microsoft SQL Server/90/Tools/Binn/VSShell/Common7/IDE/PrivateAssemblies/RedGate.SQLPrompt.SSMSUI.EXE. LOG: Attempting download of new URL file:///C:/Program Files/Microsoft SQL Server/90/Tools/Binn/VSShell/Common7/IDE/PrivateAssemblies/RedGate.SQLPrompt.SSMSUI/RedGate.SQLPrompt.SSMSUI.EXE. LOG: All probing URLs attempted and failed.
C:\temp\Default\SqlWb.exe\RedGate.Refactoring.ComAddIn, Version=1.3.0.207, Culture=neutral, PublicKeyToken=7f465a1c156d4d57.HTM*** Assembly Binder Log Entry (12/31/2008 @ 9:57:20 AM) *** The operation failed. Bind result: hr = 0x80070002. The system cannot find the file specified. Assembly manager loaded from: C:\Windows\Microsoft.NET\Framework\v2.0.50727\mscorwks.dll Running under executable C:\Program Files\Microsoft SQL Server\90\Tools\Binn\VSShell\Common7\IDE\SqlWb.exe --- A detailed error log follows. === Pre-bind state information === LOG: User = ERXNETWORK\benjamin.hayes LOG: DisplayName = RedGate.Refactoring.ComAddIn, Version=1.3.0.207, Culture=neutral, PublicKeyToken=7f465a1c156d4d57 (Fully-specified) LOG: Appbase = file:///C:/Program Files/Microsoft SQL Server/90/Tools/Binn/VSShell/Common7/IDE/ LOG: Initial PrivatePath = NULL LOG: Dynamic Base = NULL LOG: Cache Base = NULL LOG: AppName = NULL Calling assembly : (Unknown). === LOG: This bind starts in default load context. LOG: Using application configuration file: C:\Program Files\Microsoft SQL Server\90\Tools\Binn\VSShell\Common7\IDE\SqlWb.exe.Config LOG: Using machine configuration file from C:\Windows\Microsoft.NET\Framework\v2.0.50727\config\machine.config. LOG: Post-policy reference: RedGate.Refactoring.ComAddIn, Version=1.3.0.207, Culture=neutral, PublicKeyToken=7f465a1c156d4d57 LOG: GAC Lookup was unsuccessful. LOG: Attempting download of new URL file:///C:/Program Files/Microsoft SQL Server/90/Tools/Binn/VSShell/Common7/IDE/RedGate.Refactoring.ComAddIn.DLL. LOG: Attempting download of new URL file:///C:/Program Files/Microsoft SQL Server/90/Tools/Binn/VSShell/Common7/IDE/RedGate.Refactoring.ComAddIn/RedGate.Refactoring.ComAddIn.DLL. LOG: Attempting download of new URL file:///C:/Program Files/Microsoft SQL Server/90/Tools/Binn/VSShell/Common7/IDE/PublicAssemblies/RedGate.Refactoring.ComAddIn.DLL. LOG: Attempting download of new URL file:///C:/Program Files/Microsoft SQL Server/90/Tools/Binn/VSShell/Common7/IDE/PublicAssemblies/RedGate.Refactoring.ComAddIn/RedGate.Refactoring.ComAddIn.DLL. LOG: Attempting download of new URL file:///C:/Program Files/Microsoft SQL Server/90/Tools/Binn/VSShell/Common7/IDE/PrivateAssemblies/RedGate.Refactoring.ComAddIn.DLL. LOG: Attempting download of new URL file:///C:/Program Files/Microsoft SQL Server/90/Tools/Binn/VSShell/Common7/IDE/PrivateAssemblies/RedGate.Refactoring.ComAddIn/RedGate.Refactoring.ComAddIn.DLL. LOG: Attempting download of new URL file:///C:/Program Files/Microsoft SQL Server/90/Tools/Binn/VSShell/Common7/IDE/RedGate.Refactoring.ComAddIn.EXE. LOG: Attempting download of new URL file:///C:/Program Files/Microsoft SQL Server/90/Tools/Binn/VSShell/Common7/IDE/RedGate.Refactoring.ComAddIn/RedGate.Refactoring.ComAddIn.EXE. LOG: Attempting download of new URL file:///C:/Program Files/Microsoft SQL Server/90/Tools/Binn/VSShell/Common7/IDE/PublicAssemblies/RedGate.Refactoring.ComAddIn.EXE. LOG: Attempting download of new URL file:///C:/Program Files/Microsoft SQL Server/90/Tools/Binn/VSShell/Common7/IDE/PublicAssemblies/RedGate.Refactoring.ComAddIn/RedGate.Refactoring.ComAddIn.EXE. LOG: Attempting download of new URL file:///C:/Program Files/Microsoft SQL Server/90/Tools/Binn/VSShell/Common7/IDE/PrivateAssemblies/RedGate.Refactoring.ComAddIn.EXE. LOG: Attempting download of new URL file:///C:/Program Files/Microsoft SQL Server/90/Tools/Binn/VSShell/Common7/IDE/PrivateAssemblies/RedGate.Refactoring.ComAddIn/RedGate.Refactoring.ComAddIn.EXE. LOG: All probing URLs attempted and failed.
-
I'd say the refactor and prompt components have become unregistered. .NET is not looking in the installation folders for the .dll files, only in the default assembly folders for SSMS.
Can you try re-registering the assemblies?
Here are the instructions for SQL Prompt
The same basic procedure should also work for refactor. -
I have registered both dlls with regasm, and I am still receiving the same errors as before. I don't know if these errors are even relevant to the fact that I cannot activate my SQL Prompt 3 or anything else, for that matter. Is there some other way to activate than going into SSMS 2005, and under SQL Prompt and Enter Serial Number...?
-
I would probably rule out the source of the problem as activation. The error claims that the assembly reference is violating the security settings and that's purely a dotnet error.
Maybe it world work to go into the .NET Framework wizards and grant full trust to all assemblies signed with the Red Gate key. -
well, it has been five months. I am wondering what happened to you already?
Yeah,about the issue, I agree with Brian. It would not be an activation error problem. My friend had the same issue on his assembly and thought that it was the real reason behind it. Brian Donahue's idea could be right. Just check the.NET Framework wizards.
________________________________________
make up for the engine assembly replacement that i am working out
Add comment
Please sign in to leave a comment.
After installing SQL Toolbelt 2008, I tried to start my SSMS 2005, and it would hang. I killed it, and restarted SSMS 2005. Then I received an error message from SSMS 2005
The full dump is
See the end of this message for details on invoking just-in-time (JIT) debugging instead of this dialog box. ************** Exception Text ************** System.Security.SecurityException: That assembly does not allow partially trusted callers. at System.Security.CodeAccessSecurityEngine.ThrowSecurityException(Assembly asm, PermissionSet granted, PermissionSet refused, RuntimeMethodHandle rmh, SecurityAction action, Object demand, IPermission permThatFailed) at System.RuntimeTypeHandle.CreateInstance(RuntimeType type, Boolean publicOnly, Boolean noCheck, Boolean& canBeCached, RuntimeMethodHandle& ctor, Boolean& bNeedSecurityCheck) at System.RuntimeType.CreateInstanceSlow(Boolean publicOnly, Boolean fillCache) at System.RuntimeType.CreateInstanceImpl(Boolean publicOnly, Boolean skipVisibilityChecks, Boolean fillCache) at System.Activator.InternalCreateInstanceWithNoMemberAccessCheck(Type type, Boolean nonPublic) at System.Runtime.InteropServices.Marshal.PtrToStructure(IntPtr ptr, Type structureType) at System.Windows.Forms.UnsafeNativeMethods.PtrToStructure(IntPtr lparam, Type cls) at System.Windows.Forms.Message.GetLParam(Type cls) at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.LazyTreeView.WndProc(Message& m) at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m) at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m) at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam) The action that failed was: LinkDemand ************** Loaded Assemblies ************** mscorlib Assembly Version: 2.0.0.0 Win32 Version: 2.0.50727.1434 (REDBITS.050727-1400) CodeBase: file:///C:/Windows/Microsoft.NET/Framework/v2.0.50727/mscorlib.dll ---------------------------------------- AppIDPackage Assembly Version: 9.0.242.0 Win32 Version: 9.00.3042.00 CodeBase: file:///C:/Program%20Files/Microsoft%20SQL%20Server/90/Tools/Binn/VSShell/Common7/IDE/AppIDPackage.DLL ---------------------------------------- System Assembly Version: 2.0.0.0 Win32 Version: 2.0.50727.1434 (REDBITS.050727-1400) CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll ---------------------------------------- Microsoft.SqlServer.SqlTools.VSIntegration Assembly Version: 9.0.242.0 Win32 Version: 9.00.3042.00 CodeBase: file:///C:/Program%20Files/Microsoft%20SQL%20Server/90/Tools/Binn/VSShell/Common7/IDE/Microsoft.SqlServer.SqlTools.VSIntegration.DLL ---------------------------------------- Microsoft.VisualStudio.Shell.Interop Assembly Version: 7.1.40304.0 Win32 Version: 7.10.6071 CodeBase: file:///C:/Windows/assembly/GAC/Microsoft.VisualStudio.Shell.Interop/7.1.40304.0__b03f5f7f11d50a3a/Microsoft.VisualStudio.Shell.Interop.dll ---------------------------------------- Microsoft.VisualStudio.OLE.Interop Assembly Version: 7.1.40304.0 Win32 Version: 7.10.6070 CodeBase: file:///C:/Windows/assembly/GAC/Microsoft.VisualStudio.OLE.Interop/7.1.40304.0__b03f5f7f11d50a3a/Microsoft.VisualStudio.OLE.Interop.dll ---------------------------------------- System.Windows.Forms Assembly Version: 2.0.0.0 Win32 Version: 2.0.50727.1434 (REDBITS.050727-1400) CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Windows.Forms/2.0.0.0__b77a5c561934e089/System.Windows.Forms.dll ---------------------------------------- System.Drawing Assembly Version: 2.0.0.0 Win32 Version: 2.0.50727.1434 (REDBITS.050727-1400) CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Drawing/2.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll ---------------------------------------- Microsoft.SqlServer.SqlTDiagM Assembly Version: 9.0.242.0 Win32 Version: 9.00.1399.00 CodeBase: file:///C:/Windows/assembly/GAC_MSIL/Microsoft.SqlServer.SqlTDiagM/9.0.242.0__89845dcd8080cc91/Microsoft.SqlServer.SqlTDiagM.dll ---------------------------------------- SqlWorkbench.Interfaces Assembly Version: 9.0.242.0 Win32 Version: 9.00.3042.00 CodeBase: file:///C:/Program%20Files/Microsoft%20SQL%20Server/90/Tools/Binn/VSShell/Common7/IDE/SqlWorkbench.Interfaces.DLL ---------------------------------------- Microsoft.DataWarehouse.SQM Assembly Version: 9.0.242.0 Win32 Version: 9.00.3042.00 CodeBase: file:///C:/Program%20Files/Microsoft%20SQL%20Server/90/Tools/Binn/VSShell/Common7/IDE/Microsoft.DataWarehouse.SQM.DLL ---------------------------------------- Microsoft.SqlServer.Instapi Assembly Version: 9.0.242.0 Win32 Version: 9.00.1399.00 CodeBase: file:///C:/Windows/assembly/GAC_MSIL/Microsoft.SqlServer.Instapi/9.0.242.0__89845dcd8080cc91/Microsoft.SqlServer.Instapi.dll ---------------------------------------- RedGate.SQLPrompt.SSMSUI Assembly Version: 3.9.0.43 Win32 Version: 3.9.0.43 CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Prompt%203/RedGate.SQLPrompt.SSMSUI.dll ---------------------------------------- RedGate.SQLPrompt.CommonVS Assembly Version: 3.9.0.43 Win32 Version: 3.9.0.43 CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Prompt%203/RedGate.SQLPrompt.CommonVS.DLL ---------------------------------------- Extensibility Assembly Version: 7.0.3300.0 Win32 Version: 7.00.9466 CodeBase: file:///C:/Windows/assembly/GAC/Extensibility/7.0.3300.0__b03f5f7f11d50a3a/Extensibility.dll ---------------------------------------- EnvDTE Assembly Version: 8.0.0.0 Win32 Version: 8.0.50727.1826 (QFE.050727-1800) CodeBase: file:///C:/Windows/assembly/GAC/EnvDTE/8.0.0.0__b03f5f7f11d50a3a/EnvDTE.dll ---------------------------------------- RedGate.SqlPrompt.Engine Assembly Version: 3.9.0.43 Win32 Version: 3.9.0.43 CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Prompt%203/RedGate.SqlPrompt.Engine.DLL ---------------------------------------- Microsoft.VisualStudio.TextManager.Interop Assembly Version: 7.1.40304.0 Win32 Version: 7.10.6070 CodeBase: file:///C:/Windows/assembly/GAC/Microsoft.VisualStudio.TextManager.Interop/7.1.40304.0__b03f5f7f11d50a3a/Microsoft.VisualStudio.TextManager.Interop.dll ---------------------------------------- RedGate.SQLPrompt.CommonUI Assembly Version: 3.9.0.43 Win32 Version: 3.9.0.43 CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Prompt%203/RedGate.SQLPrompt.CommonUI.DLL ---------------------------------------- log4net Assembly Version: 1.2.10.0 Win32 Version: 1.2.10.0 CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Prompt%203/log4net.DLL ---------------------------------------- System.Configuration Assembly Version: 2.0.0.0 Win32 Version: 2.0.50727.1434 (REDBITS.050727-1400) CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Configuration/2.0.0.0__b03f5f7f11d50a3a/System.Configuration.dll ---------------------------------------- System.Xml Assembly Version: 2.0.0.0 Win32 Version: 2.0.50727.1434 (REDBITS.050727-1400) CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Xml/2.0.0.0__b77a5c561934e089/System.Xml.dll ---------------------------------------- RedGate.Licensing.Client Assembly Version: 2.6.0.64 Win32 Version: 2.6.0.64 CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Prompt%203/RedGate.Licensing.Client.DLL ---------------------------------------- System.Data Assembly Version: 2.0.0.0 Win32 Version: 2.0.50727.1434 (REDBITS.050727-1400) CodeBase: file:///C:/Windows/assembly/GAC_32/System.Data/2.0.0.0__b77a5c561934e089/System.Data.dll ---------------------------------------- RedGate.Shared.Utils Assembly Version: 7.0.0.68 Win32 Version: 7.0.0.68 CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Prompt%203/RedGate.Shared.Utils.DLL ---------------------------------------- OptionsLayoutOptionsa5421d16921f4839832832b2e13df418 Assembly Version: 0.0.0.0 Win32 Version: 3.9.0.43 CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Prompt%203/RedGate.SQLPrompt.CommonUI.dll ---------------------------------------- ISymWrapper Assembly Version: 2.0.0.0 Win32 Version: 2.0.50727.1434 (REDBITS.050727-1400) CodeBase: file:///C:/Windows/assembly/GAC_32/ISymWrapper/2.0.0.0__b03f5f7f11d50a3a/ISymWrapper.dll ---------------------------------------- Microsoft.SqlServer.Management.Reports Assembly Version: 9.0.242.0 Win32 Version: 9.00.3042.00 CodeBase: file:///C:/Program%20Files/Microsoft%20SQL%20Server/90/Tools/Binn/VSShell/Common7/IDE/Microsoft.SqlServer.Management.Reports.DLL ---------------------------------------- EnvDTE80 Assembly Version: 8.0.0.0 Win32 Version: 8.0.50727.1826 (QFE.050727-1800) CodeBase: file:///C:/Windows/assembly/GAC/EnvDTE80/8.0.0.0__b03f5f7f11d50a3a/EnvDTE80.dll ---------------------------------------- RedGate.SQLPrompt.vsmso Assembly Version: 8.0.0.0 Win32 Version: 8.0.0.0 CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Prompt%203/RedGate.SQLPrompt.vsmso.DLL ---------------------------------------- CustomMarshalers Assembly Version: 2.0.0.0 Win32 Version: 2.0.50727.1434 (REDBITS.050727-1400) CodeBase: file:///C:/Windows/assembly/GAC_32/CustomMarshalers/2.0.0.0__b03f5f7f11d50a3a/CustomMarshalers.dll ---------------------------------------- RedGate.Refactoring.ComAddIn Assembly Version: 1.3.0.207 Win32 Version: 1.3.0.207 CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Refactor%201/RedGate.Refactoring.ComAddIn.dll ---------------------------------------- RedGate.Refactoring.AddIn Assembly Version: 1.3.0.207 Win32 Version: 1.3.0.207 CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Refactor%201/RedGate.Refactoring.AddIn.DLL ---------------------------------------- RedGate.Refactoring.vsmso Assembly Version: 8.0.0.0 Win32 Version: 8.0.0.0 CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Refactor%201/RedGate.Refactoring.vsmso.DLL ---------------------------------------- RedGate.SQLCompare.Rewriter Assembly Version: 7.0.1.29 Win32 Version: 7.0.1.29 CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Refactor%201/RedGate.SQLCompare.Rewriter.DLL ---------------------------------------- RedGate.SQLCompare.ASTParser Assembly Version: 7.0.1.29 Win32 Version: 7.0.1.29 CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Refactor%201/RedGate.SQLCompare.ASTParser.DLL ---------------------------------------- ActiproSoftware.Wizard.Net20 Assembly Version: 3.0.125.0 Win32 Version: 3.0.125.0 CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Refactor%201/ActiproSoftware.Wizard.Net20.DLL ---------------------------------------- RedGate.SQLCompare.Engine Assembly Version: 7.0.1.29 Win32 Version: 7.0.1.29 CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Refactor%201/RedGate.SQLCompare.Engine.DLL ---------------------------------------- RedGate.SqlPrompt.Engine.Gatekeeper Assembly Version: 3.9.0.43 Win32 Version: 3.9.0.43 CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Prompt%203/RedGate.SqlPrompt.Engine.Gatekeeper.DLL ---------------------------------------- RedGate.SQLCompare.Engine Assembly Version: 7.0.0.768 Win32 Version: 7.0.0.768 CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Prompt%203/RedGate.SQLCompare.Engine.DLL ---------------------------------------- RedGate.Shared.SQL Assembly Version: 7.0.0.68 Win32 Version: 7.0.0.68 CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Prompt%203/RedGate.Shared.SQL.DLL ---------------------------------------- RedGate.Update.Client Assembly Version: 2.1.0.4 Win32 Version: 2.1.0.4 CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Prompt%203/RedGate.Update.Client.DLL ---------------------------------------- System.Web.Services Assembly Version: 2.0.0.0 Win32 Version: 2.0.50727.1434 (REDBITS.050727-1400) CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Web.Services/2.0.0.0__b03f5f7f11d50a3a/System.Web.Services.dll ---------------------------------------- ObjectExplorer Assembly Version: 9.0.242.0 Win32 Version: 9.00.3042.00 CodeBase: file:///C:/Program%20Files/Microsoft%20SQL%20Server/90/Tools/Binn/VSShell/Common7/IDE/ObjectExplorer.DLL ---------------------------------------- SqlMgmt Assembly Version: 9.0.242.0 Win32 Version: 9.00.3042.00 CodeBase: file:///C:/Program%20Files/Microsoft%20SQL%20Server/90/Tools/Binn/VSShell/Common7/IDE/SqlMgmt.DLL ---------------------------------------- ConnectionDlg Assembly Version: 9.0.242.0 Win32 Version: 9.00.3042.00 CodeBase: file:///C:/Program%20Files/Microsoft%20SQL%20Server/90/Tools/Binn/VSShell/Common7/IDE/ConnectionDlg.DLL ---------------------------------------- Microsoft.VisualStudio Assembly Version: 2.0.0.0 Win32 Version: 2.0.50727.1826 built by: QFE CodeBase: file:///C:/Windows/assembly/GAC_MSIL/Microsoft.VisualStudio/2.0.0.0__b03f5f7f11d50a3a/Microsoft.VisualStudio.dll ---------------------------------------- Microsoft.VisualStudio.Shell Assembly Version: 2.0.0.0 Win32 Version: 2.0.50727.1826 (QFE.050727-1800) CodeBase: file:///C:/Windows/assembly/GAC_MSIL/Microsoft.VisualStudio.Shell/2.0.0.0__b03f5f7f11d50a3a/Microsoft.VisualStudio.Shell.dll ---------------------------------------- Microsoft.VisualStudio.Shell.Interop.8.0 Assembly Version: 8.0.0.0 Win32 Version: 8.0.50727.1826 (QFE.050727-1800) CodeBase: file:///C:/Windows/assembly/GAC/Microsoft.VisualStudio.Shell.Interop.8.0/8.0.0.0__b03f5f7f11d50a3a/Microsoft.VisualStudio.Shell.Interop.8.0.dll ---------------------------------------- System.Drawing.Design Assembly Version: 2.0.0.0 Win32 Version: 2.0.50727.1434 (REDBITS.050727-1400) CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Drawing.Design/2.0.0.0__b03f5f7f11d50a3a/System.Drawing.Design.dll ---------------------------------------- Microsoft.VisualStudio.Designer.Interfaces Assembly Version: 1.0.5000.0 Win32 Version: 1.1.4322.573 CodeBase: file:///C:/Windows/assembly/GAC/Microsoft.VisualStudio.Designer.Interfaces/1.0.5000.0__b03f5f7f11d50a3a/Microsoft.VisualStudio.Designer.Interfaces.dll ---------------------------------------- Microsoft.SqlServer.CustomControls Assembly Version: 9.0.242.0 Win32 Version: 9.00.3042.00 CodeBase: file:///C:/Windows/assembly/GAC_MSIL/Microsoft.SqlServer.CustomControls/9.0.242.0__89845dcd8080cc91/Microsoft.SqlServer.CustomControls.dll ---------------------------------------- Accessibility Assembly Version: 2.0.0.0 Win32 Version: 2.0.50727.1434 (REDBITS.050727-1400) CodeBase: file:///C:/Windows/assembly/GAC_MSIL/Accessibility/2.0.0.0__b03f5f7f11d50a3a/Accessibility.dll ---------------------------------------- Microsoft.SqlServer.Smo Assembly Version: 9.0.242.0 Win32 Version: 9.00.3042.00 CodeBase: file:///C:/Windows/assembly/GAC_MSIL/Microsoft.SqlServer.Smo/9.0.242.0__89845dcd8080cc91/Microsoft.SqlServer.Smo.dll ---------------------------------------- Microsoft.SqlServer.RegSvrEnum Assembly Version: 9.0.242.0 Win32 Version: 9.00.3042.00 CodeBase: file:///C:/Windows/assembly/GAC_MSIL/Microsoft.SqlServer.RegSvrEnum/9.0.242.0__89845dcd8080cc91/Microsoft.SqlServer.RegSvrEnum.dll ---------------------------------------- ufqbtbmr Assembly Version: 2.1.0.4 Win32 Version: 2.0.50727.1434 (REDBITS.050727-1400) CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll ---------------------------------------- Microsoft.JScript Assembly Version: 8.0.0.0 Win32 Version: 8.0.50727.1434 CodeBase: file:///C:/Windows/assembly/GAC_MSIL/Microsoft.JScript/8.0.0.0__b03f5f7f11d50a3a/Microsoft.JScript.dll ---------------------------------------- ************** JIT Debugging ************** To enable just-in-time (JIT) debugging, the .config file for this application or computer (machine.config) must have the jitDebugging value set in the system.windows.forms section. The application must also be compiled with debugging enabled. For example: <configuration> <system.windows.forms jitDebugging="true" /> </configuration> When JIT debugging is enabled, any unhandled exception will be sent to the JIT debugger registered on the computer rather than be handled by this dialog box.I told the error to "Continue", and went on. The trial expired, so I purchased a license, but I could not activate. Each time I put the serial number into the field, the "Activate" button does not become "un-grayed out". I uninstalled the SQL Toolbelt's components, and even went into the Registry and removed all references to SQL Prompt and redgate, and reinstalled.
After it finished installing, I tried to start up SSMS 2005, but it would hang, and never seem to finish. I would kill it, and once I started SSMS 2005 back up again, I would get the error message again. I continued past it, and once again, cannot "Activate". Is there some way to correct the error message, or to set it to trust the assembly?