System.Security.SecurityException accessing MSSQL

bjovas · August 17th, 2005, 08:54 AM

When trying to access an MS SQL server from a Citrix Terminal Server account i get the following exception.:

(Im using Visual C#, visual studio 2003)

Code:

System.Security.SecurityException: Request for the permission of type System.Data.SqlClient.SqlClientPermission, System.Data, Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 failed.



   at System.Security.CodeAccessSecurityEngine.CheckHelper(PermissionSet grantedSet, PermissionSet deniedSet, CodeAccessPermission demand, PermissionToken permToken)
   at System.Security.CodeAccessSecurityEngine.Check(PermissionToken permToken, CodeAccessPermission demand, StackCrawlMark& stackMark, Int32 checkFrames, Int32 unrestrictedOverride)
   at System.Security.CodeAccessSecurityEngine.Check(CodeAccessPermission cap, StackCrawlMark& stackMark)
   at System.Security.CodeAccessPermission.Demand()
   at System.Data.SqlClient.SqlConnectionString.Demand(SqlConnectionString constr)
   at System.Data.SqlClient.SqlConnection.Open()

Locally at my computer it works without a hitch.

Im sure this has something to do with permissions in citrix, but has anyone else experienced this?

thanks

Some links ive read:
http://www.vbcity.com/forums/topic.asp?tid=61130
http://www.derkeiler.com/Newsgroups/...4-01/0035.html
http://www.groupsrv.com/dotnet/viewtopic.php?t=53876

Edit:
Possible solution:
http://blogs.msdn.com/shawnfa/archiv.../20/57023.aspx