Sql Server ConnectionString Builder - Security

If you launch Sql Server ConnectionString Builder (SSCB) using its URL, that is to say as a smart client, you must change the .NET security to allow SSCB to access Sql Server. To do that, launch the .NET framework configuration tool (in Administrative tools or Control Panel) and :

1. Add a new permission set

Open "Runtime Security Policy" - "Machine" - "Permission Sets", right-click on "Internet" and choose "Duplicate". A new permission set is created, change its name to "SSCB", then click on "Change permissions".
In "Assigned Permissions" double-click "Security" and check "Allow calls to unmanaged assemblies".
In "Assigned Permissions" double-click "User Interface" and check "Grant assemblies unrestricted access to user interface elements".
In "Available Permissions" double-click "SQL Client" and check "Grant assemblies unrestricted access to Microsoft SQL Servers".
Click "Finish".

2. Add a new code group

Open "Runtime Security Policy" - "Machine" - "Code Groups", right-click on "All_Code" and choose "New". A new code group is created, change its name to "SSCB", click "Next". For the condition type, choose "URL" and type http://jcmag.europe.webmatrixhosting.net/*, click "Next". For the permission set, choose SSCB. Click "Next" and "Finish".

----------

You can also use this batch file to do this configuration automatically : CaspolSSCB.bat 

previous