Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««12

CLR Integration with Third Party DLL Expand / Collapse
Author
Message
Posted Sunday, December 14, 2008 6:59 PM


Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, April 10, 2014 5:46 AM
Points: 7, Visits: 27
Thanks

That is my next step.



---
Satheesh Mohan
http://www.satheeshmohan.com
Post #619369
Posted Monday, December 15, 2008 4:51 AM


Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, April 10, 2014 5:46 AM
Points: 7, Visits: 27
Hi,

I have an issue with security.

Error Message:

System.Configuration.COnfigurationErrorException:
An error occured creating the configuration section header for securityCryptographyConfiguration: That assembly does not allow partially trussted callers(C:\program...\MSSQL.1\Binn\sqlservr.exe.config line 6) ---> System.SecurityException: That assembly does not allow partially trusted callers.

I added in assemblyinfo.cs but i does not help
My assembly is strong named

Kindly help....


---
Satheesh Mohan
http://www.satheeshmohan.com
Post #619486
Posted Friday, January 20, 2012 4:11 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Wednesday, May 21, 2014 3:56 AM
Points: 52, Visits: 223
Hi All,

I am trying to access the configuration file from sql clr sp,I am able to do that in win xp os,sql server 2005 SE.
But when i deployed the same sp on sql server 2005 EE and win2k8 os,i had a problem in reading the connection string from the configuration file.
Please let me know whether this is supported.

Appreciate your help in advance.

Thanks & Regards,
Sreelekha
Post #1239289
Posted Friday, January 20, 2012 5:28 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Monday, October 20, 2014 3:10 PM
Points: 1,683, Visits: 1,797
v.sreelekha (1/20/2012)
Hi All,

I am trying to access the configuration file from sql clr sp,I am able to do that in win xp os,sql server 2005 SE.
But when i deployed the same sp on sql server 2005 EE and win2k8 os,i had a problem in reading the connection string from the configuration file.
Please let me know whether this is supported.

Appreciate your help in advance.

Thanks & Regards,
Sreelekha


No, the use of a configuration file in SQLCLR is not a supported operation. It works, but that doesn't mean it is supported by Microsoft.

Thanks,


Jonathan Kehayias | Principal Consultant | MCM: SQL Server 2008
My Blog | Twitter | MVP Profile
Training | Consulting | Become a SQLskills Insider
Troubleshooting SQL Server: A Guide for Accidental DBAs
Post #1239347
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse