SQL Server Security with Dot Net -- visual studio .net setup

Mac Davis
8/20/2007 10:25:46 AM

I am just beginnin with C# and dot net.

I am able to understand most of what is happening and am making reat
progress.

However, all of the security stuff has me stumped.

When I issue -
this.residentsTableAdapter.Update(this.villagesDataSet1.Residents);

I get the following response and have no idea how to eliminate the problem:

Request for the permission of type
'System.Data.SqlClient.SqlClientPermission, System.Data, Version=2.0.0.0,
Culture=neutral, PublicKeyToken=b77a5c561934e089' failed.

Client is Windows Vista Ultimate
SQL Server 2005 running on Windows 2003 Server.
No active directory installed

Any help, or suggestion on a more apropos newsgroup, is appreciated.

Thanks,

Mac

Stevanich
9/1/2007 3:12:46 AM

Mac,

What does your connection string look like? (And leave out the sensitive
values.)

Thanks,

Steve - dotneticated.com

[quoted text, click to view]

visual studio .net setup : SQL Server Security with Dot Net