How to add SQLCLIENT PERMISSION in security policy admin tool?

Posted on 2004-11-30
Last Modified: 2008-01-09
Dear All,

When I share the compiled file and try to access from network it gives me error and warning for Microsoft.NET security information.

I am new to this area so pls help.
Question by:zipzip
    LVL 41

    Expert Comment

    This error has nothing to do with SQL Server...   this is normal behavior for any .Net framework application.

    By default, the client PCs have their .Net Framework permissions set to "Medium Trust" for the "Local Intranet".  That means that when they try to run your program from a network share, that get a rather unintelligble error message from the CLR.

    That means you must either adjust the .Net Security settings for your application or for the entire "zone".  If you're really paranoid, you can set permissions for each application, but if you plan to deploy future applications from a network share, I'd recommend you adjust the "Local Intranet" security to "Full Trust" instead.  

    You will have to visit each client PC and go to the Control Panel, Administrative Tools, .Net Wizards.  From there you either choose "Adjust .Net Security" (for the zone) or "Trust and Assembly" (for just that one application).  
    LVL 1

    Author Comment


    My system is actually connecting to a database server, what should I do in order to build an exe file that can run independant in all pcs include windows 98, which do not have .net framework.
    LVL 41

    Accepted Solution

    The fact that your program connects to a database server really isn't relevent to the error you're getting.   It is all about running the EXE file from a network share.   (If you don't believe me, just copy the file from the network share onto the client's hard drive and it will run without error).

    All .Net applications require the client PCs to have the .Net Framework installed... there is no work-around.   There are ways to install the Framework bundled with your application's setup (but it's a bit clumbsy).  Instead, I'd suggest that make the .Net Framework available on your network somewhere and instruct you users to install it prior to running your application.

    The prerequistits (sp?) for the .Net framework are:

    Win98 +
    IE 5.01 +
    MDAC 2.6 +

    Featured Post

    Do You Know the 4 Main Threat Actor Types?

    Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

    Join & Write a Comment

    Suggested Solutions

    Title # Comments Views Activity
    Update listbox from another thread 29 74
    How to do in LINQ?? 18 46
    DataGridView 2 14
    Select datagridview rows by range or numbers 11 0
    Introduction As chip makers focus on adding processor cores over increasing clock speed, developers need to utilize the features of modern CPUs.  One of the ways we can do this is by implementing parallel algorithms in our software.   One recent…
    Creating an analog clock UserControl seems fairly straight forward.  It is, after all, essentially just a circle with several lines in it!  Two common approaches for rendering an analog clock typically involve either manually calculating points with…
    This video is in connection to the article "The case of a missing mobile phone (". It will help one to understand clearly the steps to track a lost android phone.
    Internet Business Fax to Email Made Easy - With eFax Corporate (, you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…

    754 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    17 Experts available now in Live!

    Get 1:1 Help Now