NewUser
(1)
Ektron
(1)
Somepassword
(1)
Xxxxx
(1)

SSIS HTTP connection Manager - Credentials must be specified

Asked By NMahmoud
22-Jan-10 11:55 AM
Hi everyone,
I am trying to use SSIS to post SOAP messages to Ektron services.
I created a HTTP connection, with "use credentials", Nothing set in the
Proxy tab.
I used that connection in a web service task, when I run it, the task it
gives me the following error


Error: 0xC002F304 at Web Service Task, Web Service Task: An error occurred
with the following error message:
Web Service threw an error during method execution. The error is:
System.Web.Services.Protocols.SoapException: Credentials must be specified

at Ektron.Services.User.IsARoleMember(CmsRoleIds RoleId).

at
Microsoft.SqlServer.Dts.Tasks.WebServiceTask.WebMethodInvokerProxy.InvokeMethod(DTSWebMethodInfo
methodInfo, String serviceName, Object connection)

at
Microsoft.SqlServer.Dts.Tasks.WebServiceTask.WebServiceTaskUtil.Invoke(DTSWebMethodInfo
methodInfo, String serviceName, Object connection, VariableDispenser
taskVariableDispenser)

at
Microsoft.SqlServer.Dts.Tasks.WebServiceTask.WebServiceTask.executeThread()".

Task failed: Web Service Task

Warning: 0x80019002 at Package: SSIS Warning Code
DTS_W_MAXIMUMERRORCOUNTREACHED.  The Execution method succeeded, but the
number of errors raised (1) reached the maximum allowed (1); resulting in
failure. This occurs when the number of errors reaches the number specified
in MaximumErrorCount. Change the MaximumErrorCount or fix the errors.

SSIS package "Package.dtsx" finished: Failure.


the folloing is a sample of the xml messages I am trying to post.

xmlns:tem="http://tempuri.org/">



























in the web server we have "anonymous Authentication" and "Forms
Authentication" Enabled



would anyone have an idea what the problem is, I am new to SSIS and
Post Question To EggHeadCafe