First, Visual Studio 2008 is in beta so its stability is not guaranteed.
Next, I think it would help to step through the whitepaper on getting
connected that details many of the steps to configure the security settings
required to connect over a network. See
http://betav.com/blog/billva/2006/06/getting_and_staying_connected_1.html --
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant, Dad, Grandpa
Microsoft MVP
INETA Speaker
www.betav.com www.betav.com/blog/billva Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
Visit
www.hitchhikerguides.net to get more information on my latest book:
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)
-----------------------------------------------------------------------------------------------------------------------
[quoted text, click to view] "ali" <ali01online@gmail.com> wrote in message
news:1191007152.573532.115040@y42g2000hsy.googlegroups.com...
>I have a program that has hand written database connections and
> DataGridView that connects to my database on sql server
> using computer's name .this works fine locally BUT problem occures
> when running my app on local area network
> causes this exception
> " Application attempted to perform an operation not allowed by the
> security policy. to grant this application the required
> permission,
> contact your system administrator, or use the Microsoft .net
> framework
> configuration tool
> ...
> Request for the permission of type
> system.Data.SqlClient."
> I tried to granting permission using Microsoft .net configuration
> tool on control panel
> I set full trust for local interanet and then unchecking publisher
> policy for some key assemblies including
> System.Data
>
> I set my application's security to full trust on visual studio env and
> this also has no effect
> so anyone can help me to connect my sql server through my application
> on local area network .
> any suggest appreciated
>
> I use "Visual studio 2008" and "Sql server 2005 professional edition "
> thanks
>