SSIS ODATA Connection issue

0
votes

I am able to get into SharePoint site using browser but not able to connect it using SSIS ODATA Connector. I have admin rights in that site. We have multiple imports successfully running using same SharePoint Server right now. Using SSDT2012. I tried another site successfully to confirm I don't have issue with SSDT. Any idea what I am missing. Error msg:

TITLE: OData Connection Manager Editor

Test connection failed

ADDITIONAL INFORMATION:

The remote server returned an error: (401) Unauthorized. (System)

The logon attempt failed (System)

BUTTONS:

OK

2
ssisodatasharepoint-2013sql-server-data-tools

2 Answers

0
votes

What is the Service Document Location URL, you are giving in your case? Here is mine which works well.

enter image description here

0
votes

Are you using basic authentication or Windows authentication?

If the former, double and triple-check that your userid and password are correct, and that the credentials have the proper access.

If the latter, check to see what user the package is running as. Also, I've found that when using Windows Authentication, you have to go back and double check what the Basic Authentication settings are, and zero them out before going back to Windows Authentication. It sounds crazy, but sometimes it works.