search

nicholas-ross / SSMS-Schema-Folders

This an extension for SQL Server Management Studio (SSMS). It groups sql objects in Object Explorer (tables, views, etc.) into schema folders.
GNU General Public License v2.0
159 stars 34 forks source link

Error in SSMS "SQL Server Management Studio 20.1.10.0" #47

Closed binbash23 closed 5 months ago

binbash23 commented 5 months ago

Hello, I extracted the folder into: C:\Program Files (x86)\Microsoft SQL Server Management Studio 20\Common7\IDE\Extensions When I start I get the error: image

I like this tool alot and would like to use it in ssms 20, too.

Here is the detail of the logfile:

129 Information VisualStudio Begin package load [SsmsSchemaFolders.SsmsSchemaFoldersPackage, SsmsSchemaFolders, Version=1.0.0.0, Culture=neutral, PublicKeyToken=a93ca1bbf74c67b4] {A88A775F-7C86-4A09-B5A6-890C4C38261B} 130 Error VisualStudio CreateInstance failed for package [SsmsSchemaFolders.SsmsSchemaFoldersPackage, SsmsSchemaFolders, Version=1.0.0.0, Culture=neutral, PublicKeyToken=a93ca1bbf74c67b4]Source: 'mscorlib' Description: Could not load file or assembly 'file:///c:\program files (x86)\microsoft sql server management studio 20\common7\ide\extensions\ssms schema folders\SsmsSchemaFolders.dll' or one of its dependencies. Operation is not supported. (Exception from HRESULT: 0x80131515) System.IO.FileLoadException: Could not load file or assembly 'file:///c:\program files (x86)\microsoft sql server management studio 20\common7\ide\extensions\ssms schema folders\SsmsSchemaFolders.dll' or one of its dependencies. Operation is not supported. (Exception from HRESULT: 0x80131515) File name: 'file:///c:\program files (x86)\microsoft sql server management studio 20\common7\ide\extensions\ssms schema folders\SsmsSchemaFolders.dll' ---> System.NotSupportedException: An attempt was made to load an assembly from a network location which would have caused the assembly to be sandboxed in previous versions of the .NET Framework. This release of the .NET Framework does not enable CAS policy by default, so this load may be dangerous. If this load is not intended to sandbox the assembly, please enable the loadFromRemoteSources switch. See http://go.microsoft.com/fwlink/?LinkId=155569 for more information. at System.Reflection.RuntimeAssembly._nLoad(AssemblyName fileName, String codeBase, Evidence assemblySecurity, RuntimeAssembly locationHint, StackCrawlMark& stackMark, IntPtr pPrivHostBinder, Boolean throwOnFileNotFound, Boolean forIntrospection, Boolean suppressSecurityChecks) at System.Reflection.RuntimeAssembly.nLoad(AssemblyName fileName, String codeBase, Evidence assemblySecurity, RuntimeAssembly locationHint, StackCrawlMark& stackMark, IntPtr pPrivHostBinder, Boolean throwOnFileNotFound, Boolean forIntrospection, Boolean suppressSecurityChecks) at System.Reflection.RuntimeAssembly.InternalLoadAssemblyName(AssemblyName assemblyRef, Evidence assemblySecurity, RuntimeAssembly reqAssembly, StackCrawlMark& stackMark, IntPtr pPrivHostBinder, Boolean throwOnFileNotFound, Boolean forIntrospection, Boolean suppressSecurityChecks) at System.Reflection.RuntimeAssembly.InternalLoadFrom(String assemblyFile, Evidence securityEvidence, Byte[] hashValue, AssemblyHashAlgorithm hashAlgorithm, Boolean forIntrospection, Boolean suppressSecurityChecks, StackCrawlMark& stackMark) at System.Reflection.Assembly.LoadFrom(String assemblyFile, Evidence securityEvidence) at System.Activator.CreateInstanceFromInternal(String assemblyFile, String typeName, Boolean ignoreCase, BindingFlags bindingAttr, Binder binder, Object[] args, CultureInfo culture, Object[] activationAttributes, Evidence securityInfo) at System.AppDomain.CreateInstanceFrom(String assemblyFile, String typeName) System.NotSupportedException: An attempt was made to load an assembly from a network location which would have caused the assembly to be sandboxed in previous versions of the .NET Framework. This release of the .NET Framework does not enable CAS policy by default, so this load may be dangerous. If this load is not intended to sandbox the assembly, please enable the loadFromRemoteSources switch. See http://go.microsoft.com/fwlink/?LinkId=155569 for more information. {A88A775F-7C86-4A09-B5A6-890C4C38261B}
80004005 - E_FAIL Thanks alot, Jens
binbash23 commented 5 months ago

Hi,

I could fix it with the "unblock" checkbox in the propierties of the downloaded zip file. This microsoft "feature" is ridiculous stupid!!

best regards, jens