I have SharePoint 2010 Enterprise installed on server, alongside SQL Server 2008 R2 with SSRS in SharePoint integrated mode. The problem I am having is that reports do not seem to be deploying to SharePoint from SQL Server Report Builder. I'll try to explain my configuration as detailed as possible.
From Reporting Services Configuration Manager:
Virtual Directory: ReportServer
SQL Server Name: SERVERNAME
Datebase Name: ReportServer
Report Server Mode: SharePoint integrated
Report Manager URL: http://SERVERNAME:80/Reports
***NOTE*** when I go to http://SERVERNAME/ReportServer
there is a directory called http://SERVERNAME
. The directory listing inside that looks something like:
Data Connections for Perfomance POint
I am trying to deploy the reports to the Reporting directory. I have set up Report Data Source, Report Builder Report, and Report Builder Model as content types for the Reporting Library. When I currently add documents from SharePoint, Report Builder launches. I can build a report and even execute it from inside Report Builder, but when it comes time to deploy the report parts, nothing works. I've tried a few configuration options.
I set the Report Server to : http://SERVERNAME/ReportServer
, but I get error:
"Connection Failed. Unable to connect to the server that is specified in the URL, 'http://SERVERNAME/ReportServer.'
Make sure that the server is running, the URL is correct, and you have permission to use the server. "