Pretty basic question I think, but I'm kind of at a loss.
I'm trying to do some Biztalk->Sharepoint integration. Eventually I'll be moving to dynamic ports etc. but right now all I'm trying to do is add an item to a list in sharepoint. I have a personal site on the company intranet where I have "Full control".
The list has two columns, and my schema has two elements. Very similar to this blog. I'm pretty sure it's the right structure.
I've gone to my biztalk host (BiztalkServerApplication) and made it use my Logon: "domain\username". This is the same logon that has "full permission" on my sharepoint site. When I don't use this account and try to set it in the adapter instead, I get a "System.ServiceModel.CommunicationObjectFaultedException"... I've kind of gone off of this link for help in terms of providing my credentials to this Host Instance.
Now I'm getting a "Access denied. You do not have permission..." Error when I try to send this list message! (From a file if that matters).
I'm at a loss here. My host instance has my domain credentials. I'm (nearly) positive they're identical to what's on the host site. I don't know what I'm doing wrong because it seems like I'm following everything perfectly to the letter from what I've found on the internet. Though there's hardly anything when it comes to using the BT2013 Sharepoint Adapter. What are common mistakes that people make with this adapter? I don't feel like I should have to go to our Systems guys to change something on the sharepoint site.
Any and all help appreciated!
Looks like long story short what I THOUGHT was a list was in fact not a list. I was trying to add an element to something that looked and acted exactly like every other SP list but wasn't one which is what produced the permissions error. Awesome.
I opened up InfoPath and created a new list on my "personal" sharepoint, then targeted that with my Biztalk Sharepoint adapter with hardcoded values for the columns. After dropping in a message, it worked correctly.
For more useful information see @lantrix 's reply to this question.