I recently brought up a SQL Reporting server into my SharePoint farm that also contains a Web Frontend and database server. When I try to create a report using the BIDS application installed on the SQL server, I do not see the SharePoint list connection type as a possible connection type. I'm running SQL Server 2008 R2 on this SharePoint server and I have the enterprise features enabled on my farm. What do I need to do to get this connection type?

You need to use XML connection type to connecto Sharepoint List.

I disagree. According to MS, I should have the option for SharePoint List Connection type: http://technet.microsoft.com/en-us/library/ee633650.aspx

I stand corrected. I misread the version to 2008. Probably best to raise a MS support ticket with them or try reinstalling it one more option you can look at is in the config file if the data extension has been commented out. This was the case with SSIS data extension as well.

Which config file should I be looking at?

Hi Robbertv, Please make sure below XML code is not commented out in the <Data> section of RSReportDesigner.config file located <drive>:\Program Files\Microsoft Visual Studio 9.0\Common7\IDE\PrivateAssemblies: <Extension Name="SHAREPOINTLIST" Type="Microsoft.ReportingServices.DataExtensions.SharePointList.SPRemoteConnection,Microsoft.ReportingServices.DataExtensions"/> Make sure below XML code is not commented out in the <Designer> section of RSReportDesigner.config <Extension Name="SHAREPOINTLIST" Type="Microsoft.ReportingServices.QueryDesigners.SharePoint.SharePointQueryDesigner,Microsoft.ReportingServices.QueryDesigners.SharePoint"/> Besides this, please Make sure below XML code is not commented out in the <Data> section of RSReportserver.config located <drive>:\Program Files\Microsoft SQL Server\MSRS10.MSSQLSERVER\Reporting Services\ReportServer. <Extension Name="SHAREPOINTLIST" Type="Microsoft.ReportingServices.DataExtensions.SharePointList.SPListConnection,Microsoft.ReportingServices.DataExtensions"/> Challen Fu [MSFT] MSDN Community Support | Feedback to us Get or Request Code Sample from Microsoft Please remember to mark the replies as answers if they help and unmark them if they provide no help.

I ended up reinstalling SQL Server and that resolved the problem.