Let’s assume you have a Dynamics CRM 2011 farm that is configured to use Claims and IFD (Internet Facing Deployment) and that you are also using CozyRoc SSIS (excellent by the way) to extract data from your CRM platform.

Note : If you are not using Claims and IFD, this article might not apply to your problem…

You might face the following error : The request failed with HTTP status 401: Unauthorized. (System.Web.Services).

1. Enable Anonymous Authentication on MSCRMServices\2007\SPLA on every web front in your CRM farm
1. Open Internet Information Services (IIS) Manager.
2. In the Connections pane, select the Microsoft Dynamics CRM Server 2011 Web site, and then navigate to the following folder: MSCRMServices\2007\SPLA
3. In Features View, double-click Authentication.
4. On the Authentication page, select Anonymous Authentication.
5. In the Actions pane, click Enable to use Anonymous authentication with the default settings.
2. In your CozyRoc SSIS package, select a deployment type as “Hosted” instead of “Premise”.
1. Open your SSIS package and double click on your Dynamics CRM Connection Manager
2. Select “Hosted” in the deployment list :
   

That’s all you need to do. CozyRoc will then work smoothly !