SQL sqlservr.exe.config <bindings> RRS feed

  • Question

  • Hello all,

    I am having a problem getting permission to run any kind of bindings in the config file. I have a assembly that consumes a local WCF resource. The config file and error are below. It looks like some kind of permission error. The dbo has external access, trustworthy is on. All assembles required are unsafe. The function is being executed as dbo. I have spent hours and hours looking through posts about this error and have came up empty. The config was made by VS2015

    <?xml version="1.0" encoding="utf-8" ?>
                    <binding name="BasicHttpBinding_IHelloWorldService" />
                <endpoint address="" binding="basicHttpBinding"
                    contract="API.IHelloWorldService" name="BasicHttpBinding_IHelloWorldService" />


    A .NET Framework error occurred during execution of user-defined routine or aggregate "test": 
    System.Configuration.ConfigurationErrorsException: An error occurred creating the configuration section handler for system.serviceModel/bindings: Request failed. (c:\Program Files\Microsoft SQL Server\MSSQL10.SQLEXPRESS\MSSQL\Binn\sqlservr.exe.Config line 4) ---> System.Security.SecurityException: Request failed.

    Saturday, December 12, 2015 12:31 AM

All replies

  • Take a look on below link:

    • Edited by Pradeep_DBA Monday, December 14, 2015 10:16 AM
    Monday, December 14, 2015 10:12 AM
  • I believe that in order to access anything in the config file outside of the ConnectionStrings and AppConfig entities, you need to mark the Assembly as "WITH PERMISSION_SET = EXTERNAL_ACCESS;". When doing this, please sign the Assembly (using a password to that you get a .pfx file), create an Asymmetric Key in [master], create a Login based on that Asymmetric Key, and then grant that Login the EXTERNAL ACCESS ASSEMBLY permission. Please do not set the database containing your Assembly to TRUSTWORTHY ON.

    Thursday, January 28, 2016 8:25 PM