Geeks With Blogs

Arthur Zubarev Compudicted

After some time working on another SQL CLR I am getting an error

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

This procedure needed to access a stored procedure on a remote server. Running that stored procedure within SQL Server Management Studio completed successfully. It just would not execute from my SQL CLR !

Doing online research did not lead to a solution.

Nearly completely tired I dropped by my DBA with this issue who decided to add SQL Account of the target SQL Server to the SQL Server box I was running this stored procedure on and bum no more issue !

Posted on Tuesday, June 30, 2009 3:09 PM | Back to top

Comments on this post: Request for the permission of type 'System.Data.SqlClient.SqlClientPermission failed Error

No comments posted yet.
Your comment:
 (will show your gravatar)

Copyright © Compudicted | Powered by: