How to add SQLCLIENT PERMISSION in security policy admin tool?

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.
LVL 1
zipzipAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

grayeCommented:
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).  
0
zipzipAuthor Commented:
@graye

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.
0
grayeCommented:
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 +
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Visual Basic.NET

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.