Receiving error on SSMS 2005 startup

beenhazedbeenhazed Posts: 7
edited July 27, 2009 6:47PM in SQL Prompt Previous Versions
My OS is Vista Business.

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
Application attempted to perform an operation not allowed by the security policy.  To grant this application the required permission, contact your system administrator, or use the Microsoft .NET Framework Configuration tool.

If you click Continue, the application will ignore this error and attempt to continue.

That assembly does not allow partially trusted callers.

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?
· Share on Twitter

Comments

  • Brian DonahueBrian Donahue Posts: 6,590 Bronze 1
    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.
    · Share on Twitter
  • beenhazedbeenhazed Posts: 7
    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  &#40;12/31/2008 @ 9:57:19 AM&#41; ***

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
 &#40;Fully-specified&#41;
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 : &#40;Unknown&#41;.
===
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  &#40;12/31/2008 @ 9:57:20 AM&#41; ***

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
 &#40;Fully-specified&#41;
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 : &#40;Unknown&#41;.
===
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.
    · Share on Twitter
  • Brian DonahueBrian Donahue Posts: 6,590 Bronze 1
    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.
    · Share on Twitter
  • beenhazedbeenhazed Posts: 7
    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...?
    · Share on Twitter
  • Brian DonahueBrian Donahue Posts: 6,590 Bronze 1
    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.
    · Share on Twitter
  • emaema Posts: 1
    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
    · Share on Twitter
Sign In or Register to comment.