How deploying data source and report on SharePoint 2010 from a SSRS 2012 project inside SQL Server Data Tools
Tuesday, July 31, 2012 11:20 AM
I'm trying to deploy a SSRS 2012 data sources and reports from SQL Server Data tools. I've installed SSRS 2012 in integrated mode for my SharePoint farm, following this article:
I've also started the SSRS service in the Central Admin and I've created the related service application to enable a reporting site. I'v created some libraries adding the SSRS content types.
As the targer server url I've specified the http://reporting_site_name Url, but I cannot perform the deploy from the SSDT.
So, I need to know which changes there are respect to deploy with SSRS 2008 R2. I underline that I'm using SSRS 2012 and SSDT.
Any helps to me, please? Many thanks
Tuesday, July 31, 2012 1:54 PM
First you have to create an site collection where you will host your reports, and some libraries for reports, shared dataset, shared datesources.
Have both OverwriteDatasets and OverwriteDataSources set to true.
TargetDatasetFolder: http://reporting_site_name/sites/portal/DataSetsMake sure not to add "/" at the end of the URL.
Tuesday, July 31, 2012 2:35 PM
Hi irusul, thanks for your reply.
Reporting_site_name isn't the name of the SharePoint machine but the name of the web app and so the site collection where publishing my report.
I can access successfully to this report server url: http://reporting_site_name/_vti_bin/reportserver in the IE browser of SQL Server 2012 machine with the SQL Server Data tools.
I've specified as TargetServerURL the URL http://reporting_site_name/ (with the final slash) and, f.e., I've indicated http://reporting_site_name/reports_library_name as the URL for the document library where publishing the reports and then I've deployed successfully!
Thanks and bye
- Marked As Answer by Edward ZhuModerator Thursday, August 02, 2012 8:45 AM