Data Insight Fails to add SharePoint Web Application with "ERROR: System.Net.WebException: The request failed with HTTP status 401: Unauthorized."
Problem
Data Insight GUI fails to add SharePoint Web Application with "ERROR: System.Net.WebException: The request failed with HTTP status 401: Unauthorized."
Error Message
2011-11-01 02:00:32 INFO: Discover all sitecollections from webapp http://foo-shareweb/sites/FOO/SiteDirectory/RM
2011-11-01 02:00:35 INFO: It took 2.921875 secs to complete the last operation
2011-11-01 02:00:35 INFO: Exitcode : 0
2011-11-01 10:22:41 INFO: Discover all sitecollections from webapp foo-shareweb:16765
2011-11-01 10:22:41 ERROR: Unable to get sitecollections for webapp foo-shareweb:16765
2011-11-01 10:22:41 ERROR: System.NotSupportedException: The URI prefix is not recognized.
at System.Net.WebRequest.Create(Uri requestUri, Boolean useUriBase)
at System.Web.Services.Protocols.WebClientProtocol.GetWebRequest(Uri uri)
at System.Web.Services.Protocols.HttpWebClientProtocol.GetWebRequest(Uri uri)
at System.Web.Services.Protocols.SoapHttpClientProtocol.GetWebRequest(Uri uri)
at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters)
at sharepoint_utilclient.SDIWebSvc.SDIWebService.getSiteCollections(String url)
at sharepoint_utilclient.sharepoint_utilclient.discoverSiteCollections(Cmdline cmd)
2011-11-01 10:22:42 INFO: It took 0.421875 secs to complete the last operation
2011-11-01 10:22:42 ERROR: Exitcode : 200
2011-11-01 10:22:56 INFO: Discover all sitecollections from webapp http://foo-shareweb:16765
2011-11-01 10:22:59 ERROR: Unable to get sitecollections for webapp http://foo-shareweb:16765
2011-11-01 10:22:59 ERROR: System.Net.WebException: The request failed with HTTP status 401: Unauthorized.
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 sharepoint_utilclient.SDIWebSvc.SDIWebService.getSiteCollections(String url)
at sharepoint_utilclient.sharepoint_utilclient.discoverSiteCollections(Cmdline cmd)
2011-11-01 10:23:00 INFO: It took 3.5 secs to complete the last operation
2011-11-01 10:23:00 ERROR: Exitcode : 200
Cause
The user configured for Data Insight to access the SharePoint, in this case FOO\foosharepoint, was not granted FULL CONTROL permissions. Data Insight will then successfully discover SharePoint Web Application.
Solution
The user configured for DI to access the SharePoint, in this case FOO\foosharepoint, needs to be granted FULL CONTROL permissions.