Deploying SSRS reports to SharePoint 2010 in Integrated Mode

Posted on 2012-09-10
Last Modified: 2012-10-10
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
URLs:  http://SERVERNAME:80/ReportServer
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. "
Question by:VAMS1
    LVL 11

    Expert Comment

    by:Ved Prakash Agrawal
    Could you check the data source used in the report are able to connect database?

    When you access report directly using report server link, are you able to run report?

    Please check the report server config file which is available on report server and see what authentication used in that.

    Author Comment

    I have to embed a data source into my report -- but nothing will deploy so I can't even see the report on the report server.

    How do I check the report server config file to see which authentication is used?
    LVL 21

    Accepted Solution

    Program Files\Microsoft SQL Server\MSRS10_50.MSSQLSERVER\Reporting Services\ReportServer\rsreportserver.config

    check file is available here.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Why You Should Analyze Threat Actor TTPs

    After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

    Suggested Solutions

    Microsoft SharePoint Foundation 2010 and Microsoft SharePoint Server 2010 do not offer the option to configure the location of the SharePoint diagnostic trace log files during installation.  This can, however, be configured through Central Administr…
    Pimping Sharepoint 2007 without Server-Side Code Part 1 One of my biggest frustrations with Sharepoint 2007 in the corporate world is that while good-intentioned managers lock down the more interesting capabilities of Sharepoint programming in…
    To add imagery to an HTML email signature, you have two options available to you. You can either add a logo/image by embedding it directly into the signature or hosting it externally and linking to it. The vast majority of email clients display l…
    Illustrator's Shape Builder tool will let you combine shapes visually and interactively. This video shows the Mac version, but the tool works the same way in Windows. To follow along with this video, you can draw your own shapes or download the file…

    737 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    22 Experts available now in Live!

    Get 1:1 Help Now