HI,
With the help of people on this forum I have managed to create a WCF service, when I run it through visual studio a Internet explorer page opens altering the URL to include my query it returns data as expected.
I've then created a webresource in dynamics crm and if I run the webresource locally and enter my query in CRM it returns data to CRM as expected - so all good so far.
We are now looking to host the service, it appears to host correctly as I can call URL and I can see it exists, however, if I enter some query information it crashes, looking at the log file created it is due to the fact the hosted server isn't a recognised user for our SQL server to authenticate, so how do I get my service to use the credentials of the user calling the service?
I've tried adding impersonation to the code but usually end up with a The contract operation requires windows indentity for automatic impersonation...
To be fair I am lost if honest.
Matt
*This post is locked for comments
I have the same question (0)
