Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

SqlClientPermission Failed

Status
Not open for further replies.

ssckan

Programmer
Jun 7, 2004
11
US
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.
 
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.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top