Question about connecting client programs to Sql server 2005 running on local area network

[ali]

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

 

[Cor Ligthert[MVP]]

Ali,

It seems more and more for me that "Application attempted to perform an
operation not allowed by the security policy" is a Microsoft term for:
"There is something wrong", as they are to lazy to give proper answers.

Are you sure that you have the proper rights as a user on the Server you are
connecting to and that you are registrated with the right rights on that
Server (And correct connection to that)?

Cor

 

[William Vaughn]

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)