473,405 Members | 2,167 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,405 software developers and data experts.

Set assembly permissions

344 100+
Hi,

I've create an assembly loaded it to SQL Server and run a sql command that uses it. Everything worked fine till I added this code to the assembly:
Expand|Select|Wrap|Line Numbers
  1. try 
  2.             {
  3.                 Process sapProcess = new Process();
  4.                 sapProcess.StartInfo = new ProcessStartInfo(ConfigurationHelper.IncomingDirectory + "\\" + "SAP.exe");
  5.                 sapProcess.StartInfo.Arguments = ConfigurationHelper.ProcessingDirectory + "\\" + xmlFileName;
  6.                 sapProcess.Start();
  7.             }
  8.             catch (Exception callSAPException)
  9.             {
  10.                 error += callSAPException.Message;            
  11.             }
An error occurred in SQL Server:
Expand|Select|Wrap|Line Numbers
  1. A .NET Framework error occurred during execution of user-defined routine or aggregate "dcm_sp_generateresultxml": 
  2. System.Security.SecurityException: Request failed.
  3. System.Security.SecurityException: 
  4.    at SQLCLRIO.Generate(String xmlFileName)
I'm trying to set the permission to the assembly so SQL Server can use it and run an exe application, but I don't know how! I searched and some techniques comes up, unfortunately no one worked.

Thanks in advanced!
Oct 11 '10 #1
0 887

Sign in to post your reply or Sign up for a free account.

Similar topics

3
by: Daylor | last post by:
hi. im loading assembly from my computer and createInstance from it. till now it worked ok. now, im changing the path from : c:\myfolder\myassembly.dll to
1
by: Jesse McGrew | last post by:
Hi, I'm trying to create an AppDomain and use it to load an assembly with reduced permissions (e.g. the "Internet" named permission set). Unfortunately, the permissions seem to be reduced *too*...
13
by: John Bowman | last post by:
Hi All, I've got a simple wrapper static test method on a class to expand the environment variables on a specified string: public static string ExpandEnvironmentStr(string Str) { return...
7
by: JerryW | last post by:
I just reinstalled .NET 2003 (after repeated attempts to get ASP.NET Web Applications to work). I first did a complete uninstall of .NET 2003, .NET Framework 1.1, and IIS. I also completely deleted...
1
by: Simon Harvey | last post by:
Hi everyone, If anyone can help me with the following - I would be VERY grateful. I need to deploy an 2 ASP.net applications that I've been creating onto one of our live servers. Both...
8
by: jporter188 | last post by:
Hello, I am working on a project to manipulate XML files. All of the files, the code, and the output are on network drives. When I run my program I get an exception (see below). I tried giving...
1
by: Fawad Ahsan | last post by:
Hi i am having problem with the microsoft enterprise library. i have uploaded the site to the hosting server and it gives the following error it works well in my server. can some one help me...
0
by: Andy | last post by:
Thanks Peter, I thought I'd give an update on this problem. My application had 2 assemblies that contained classed for the Data access and business logic layer. It was on one of them that I was...
2
by: Ares Chen | last post by:
Hi, all In .NET 1.1, I can protect my assembly by use "StrongNameIdentityPermission", so only the caller with the special StrongName Sign can call my functions in the important assembly. But how...
1
by: codefragment | last post by:
Hi (Second CAS question) At the assembly level I have: at the method level I have
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.