Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 Analysis Server and Reporting Services (2008)
 Sharepoint list as datasource

Author  Topic 

jbphoenix
Yak Posting Veteran

68 Posts

Posted - 2012-07-05 : 16:40:00
I've been tasked with creating a report from a SharePoint list. I understand you can use an xml data source or the SharePoint List type. I have tried both and I think the issue is credentials. When I try xml I get the following error - The data extension supports Windows Integrated Security and No Credentials (anonymous request) only.

I can't use Integrated Security since it's on a different domain.

It's SharePoint 2007 and we're using SQL 2008.

Any suggestions?
   

- Advertisement -