Hey guys,
I have a webservice set up on the same box where my SSIS packages sit at. I have an ASP.net app which calls the webservice. The webservice in turn invokes the ssis package and , I run it on file system.
i keep getting this error
System.Web.Services.Protocols.SoapException was unhandled by user code
Message="Server was unable to process request. ---> That assembly does not allow partially trusted callers."
Source="System.Web.Services"
Actor=""
Lang=""
Node=""
Role=""
StackTrace:
at System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall)
at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters)
at CallDummyWebServ.com.bls.cmndev2.LaunchSSISPackageServiceCS.LaunchPackage(String sourceType, String sourceLocation, String packageName) in D:\Projects\CallDummyWebServ\CallDummyWebServ\Web References\com.bls.cmndev2\Reference.cs:line 78
at CallDummyWebServ._Default.btnSayHello_Click(Object sender, EventArgs e) in D:\Projects\CallDummyWebServ\CallDummyWebServ\Default.aspx.cs:line 26
at System.Web.UI.WebControls.Button.OnClick(EventArgs e)
at System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument)
at System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument)
at System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument)
at System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData)
at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
I tried to set up the impersonation on both the asp.net 2.0 config and web.config .. but the problem is stil haunting me .. any help or suggestions would be greatly appreciated.
Server Error : launching SSIS using a webservice and Asp.net
Hot Topic
- Replication and IP addresses
- Sql Query to update a Column when the subquery returns more than one row
- Confusion about dialog security steps.
- SSIS - Connection String Issue
- jumping to report from report within a same frame
- ReportServer Database Where is ..?
- Unable to connect to SQL server database
- TSQL Code Checker
- OLEDB Command stage error in SLOWLY CHANGING DIMENSION
- Mismatch between approaches
SQL Server
- Any hierarchical functionatility in Management Studio in 2005
- import OpenSSL certificate with private key into sql server 2005 express edtion
- sqljdbc DriverManager.getConnection Hangs after mirror failover.
- Confusion on Cube Design
- Configuration of Reporting Services
- SQL ODBC table listing is not showing - Solution
- Issues with removing replication
- sql 2005 driver for crystal report 10
- Forcing 32 bit SSIS
- Query on YTD Distinct Count
Server Error : launching SSIS using a webservice and Asp.net
BurritoSmith
Just to make sure - you do understand the difference between the Windows user account security and .NET code-based security Your code does not need to run under Windows admin to call into SSIS (unless it does any admin stuff), but the code does need "full trust" .NET permissions.
Dnieto23
sofakng
i00
"Server was unable to process request. ---> That assembly does not allow partially trusted callers." looks like some error unrelated to SSIS, or you are trying to call SSIS from partially trusted caller (if "that assembly" referenced by the error message is SSIS runtime), which is indeed not supported.