SqlClientPermission Failed

[ssckan]

I have a VB 2005 project with a DataGridView linked to a SQL2000 Server (SBS2003). When I debug the application without saving the project, it runs perfectly. After I save the project, I get the following error.

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

I am new to both VS and SQL (old dBase IV / Clipper hacker) and any help is greatly appreciated.

 

[ssckan]

Nevermind, I may have figured it out. For anyone in the future with the same problem. I first followed exactly the steps in the "Microsoft SQL Server: Programming FAQ" "using NT Authentication to login into SQL". I am not sure if that helped as I am fairly confident I had the proper permissions set originally.

I think the solution was the fact that we are using "My Document" sychronization on our workstations. This redirects the "My Documents" folder to our SBS2003 server. I could run my project with no problem until I saved it into the "My Documents" folder, then I received the error. After saving the project to another non-sycned folder on my workstations C: drive, I no longer receive the error.