SQLCompare.exe - Program Error when running remotely
Tim@NextMedium
Posts: 6
Greetings - when running our copy of SQL Compare 5 (SQL Bundle Pro) - we're running into the following issue, which did not appear immediately (this had been working for 3 days with no issue).
When executing sqlcompare.exe remotely via network share, we get the following program error:
"Application has generated an exception that could not be handled.
Process id=0x11b4 (4532), Thread id=0xfe8 (4072)"
The Stack Trace that results reads as follows:
Stack Trace:
M:\Program Files\Red Gate\SQL Bundle 5>sqlcompare
Unhandled Exception: System.Security.SecurityException: Security error.
at RedGate.SQLCompare.CommandLine.Startup._1(String[] )
The granted set of the failing assembly was:
<PermissionSet class="System.Security.PermissionSet"
version="1">
<IPermission class="System.Security.Permissions.EnvironmentPermission, mscorl
ib, Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"
version="1"
Read="USERNAME"/>
<IPermission class="System.Security.Permissions.FileDialogPermission, mscorli
b, Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"
version="1"
Unrestricted="true"/>
<IPermission class="System.Security.Permissions.FileIOPermission, mscorlib, V
ersion=1.0.5000.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"
version="1"
Read="M:\Program Files\Red Gate\SQL Bundle 5\"
PathDiscovery="M:\Program Files\Red Gate\SQL Bundle 5\"/>
<IPermission class="System.Security.Permissions.IsolatedStorageFilePermission
, mscorlib, Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b77a5c561934e089
"
version="1"
Allowed="AssemblyIsolationByUser"
UserQuota="9223372036854775807"
Expiry="9223372036854775807"
Permanent="True"/>
<IPermission class="System.Security.Permissions.ReflectionPermission, mscorli
b, Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"
version="1"
Flags="ReflectionEmit"/>
<IPermission class="System.Security.Permissions.SecurityPermission, mscorlib,
Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"
version="1"
Flags="Assertion, Execution, BindingRedirects"/>
<IPermission class="System.Security.Permissions.UIPermission, mscorlib, Versi
on=1.0.5000.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"
version="1"
Unrestricted="true"/>
<IPermission class="System.Net.DnsPermission, System, Version=1.0.5000.0, Cul
ture=neutral, PublicKeyToken=b77a5c561934e089"
version="1"
Unrestricted="true"/>
<IPermission class="System.Drawing.Printing.PrintingPermission, System.Drawin
g, Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a"
version="1"
Level="DefaultPrinting"/>
<IPermission class="System.Diagnostics.EventLogPermission, System, Version=1.
0.5000.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"
version="1">
<Machine name="."
access="Instrument"/>
</IPermission>
<IPermission class="System.Security.Permissions.StrongNameIdentityPermission,
mscorlib, Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"
version="1"
PublicKeyBlob="0024000004800000940000000602000000240000525341310
0040000010001008FC10F454406BF85568F958675567383EB344EF516BEC3937AAD9239B15EDF1EB
663E2501CE211AB47FB6C26554697B487E8CDA6B2D662B42146417D62AA9C74C4719BC5910DB2659
584ADC4F07F0687744B038085B76CC6336A7108738CCFD0AABE44760EC94C8DFD29009FC2DEF7845
5CE1920A2A5696D108734386CE04AD9"
Name="SQLCompare"
AssemblyVersion="5.3.0.81"/>
<IPermission class="System.Security.Permissions.UrlIdentityPermission, mscorl
ib, Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"
version="1"
Url="file://M:/Program Files/Red Gate/SQL Bundle 5/SQLCompare.ex
e"/>
<IPermission class="System.Security.Permissions.ZoneIdentityPermission, mscor
lib, Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"
version="1"
Zone="Intranet"/>
</PermissionSet>
After doing some research via the forum - I have set permissions via .Net Configuration as referenced in this thread: http://www.red-gate.com/MessageBoard/vi ... 9c36eda66d
but the issue remains. I am using SQLcompare.exe similarly to what the Original Poster in that thread described and would love to be able to have this scripted with our code revision software (which doesn't like executing remote script files).
Thanks,
Tim
When executing sqlcompare.exe remotely via network share, we get the following program error:
"Application has generated an exception that could not be handled.
Process id=0x11b4 (4532), Thread id=0xfe8 (4072)"
The Stack Trace that results reads as follows:
Stack Trace:
M:\Program Files\Red Gate\SQL Bundle 5>sqlcompare
Unhandled Exception: System.Security.SecurityException: Security error.
at RedGate.SQLCompare.CommandLine.Startup._1(String[] )
The granted set of the failing assembly was:
<PermissionSet class="System.Security.PermissionSet"
version="1">
<IPermission class="System.Security.Permissions.EnvironmentPermission, mscorl
ib, Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"
version="1"
Read="USERNAME"/>
<IPermission class="System.Security.Permissions.FileDialogPermission, mscorli
b, Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"
version="1"
Unrestricted="true"/>
<IPermission class="System.Security.Permissions.FileIOPermission, mscorlib, V
ersion=1.0.5000.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"
version="1"
Read="M:\Program Files\Red Gate\SQL Bundle 5\"
PathDiscovery="M:\Program Files\Red Gate\SQL Bundle 5\"/>
<IPermission class="System.Security.Permissions.IsolatedStorageFilePermission
, mscorlib, Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b77a5c561934e089
"
version="1"
Allowed="AssemblyIsolationByUser"
UserQuota="9223372036854775807"
Expiry="9223372036854775807"
Permanent="True"/>
<IPermission class="System.Security.Permissions.ReflectionPermission, mscorli
b, Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"
version="1"
Flags="ReflectionEmit"/>
<IPermission class="System.Security.Permissions.SecurityPermission, mscorlib,
Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"
version="1"
Flags="Assertion, Execution, BindingRedirects"/>
<IPermission class="System.Security.Permissions.UIPermission, mscorlib, Versi
on=1.0.5000.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"
version="1"
Unrestricted="true"/>
<IPermission class="System.Net.DnsPermission, System, Version=1.0.5000.0, Cul
ture=neutral, PublicKeyToken=b77a5c561934e089"
version="1"
Unrestricted="true"/>
<IPermission class="System.Drawing.Printing.PrintingPermission, System.Drawin
g, Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a"
version="1"
Level="DefaultPrinting"/>
<IPermission class="System.Diagnostics.EventLogPermission, System, Version=1.
0.5000.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"
version="1">
<Machine name="."
access="Instrument"/>
</IPermission>
<IPermission class="System.Security.Permissions.StrongNameIdentityPermission,
mscorlib, Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"
version="1"
PublicKeyBlob="0024000004800000940000000602000000240000525341310
0040000010001008FC10F454406BF85568F958675567383EB344EF516BEC3937AAD9239B15EDF1EB
663E2501CE211AB47FB6C26554697B487E8CDA6B2D662B42146417D62AA9C74C4719BC5910DB2659
584ADC4F07F0687744B038085B76CC6336A7108738CCFD0AABE44760EC94C8DFD29009FC2DEF7845
5CE1920A2A5696D108734386CE04AD9"
Name="SQLCompare"
AssemblyVersion="5.3.0.81"/>
<IPermission class="System.Security.Permissions.UrlIdentityPermission, mscorl
ib, Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"
version="1"
Url="file://M:/Program Files/Red Gate/SQL Bundle 5/SQLCompare.ex
e"/>
<IPermission class="System.Security.Permissions.ZoneIdentityPermission, mscor
lib, Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"
version="1"
Zone="Intranet"/>
</PermissionSet>
After doing some research via the forum - I have set permissions via .Net Configuration as referenced in this thread: http://www.red-gate.com/MessageBoard/vi ... 9c36eda66d
but the issue remains. I am using SQLcompare.exe similarly to what the Original Poster in that thread described and would love to be able to have this scripted with our code revision software (which doesn't like executing remote script files).
Thanks,
Tim
Comments
It's still the same basic problem. Maybe using the .NET wizards to adjust the security for the Intranet zone to full trust will get it working?
Brian -
Turns out our version of Red Gate was forcing us to use .Net 1.0 and we were making our config changes in 2.0. After we resolved it - all works normally. Thanks so much for your help.