Publishing SSRS report on Sharepoint

Posted on 2011-10-22
Last Modified: 2012-05-12
I have a Report Server that I am attempting to publish on Sharepoint, and I'm running into a roadblock. I am running in Sharepoint Integrated mode.  I have a report I built in Visual Studio, which pulls data from a SQL Server database.  

I am unclear about how to proceed.  I have a default Sharepoint account, with the internal address "http://spserver/sites/ssrs/Pages/Default.aspx".  The Visual Studio is set to deploy to "http://spserver/sites/ssrs/reports/".  It appears to find the path, but when I attempt to authenticate, the login box fails to work, even though the account has full administartive rights.

Your help is greatly appreciated, ~Peter Ferber
Question by:PeterFrb
    LVL 42

    Accepted Solution

    i could never get this to work, but in my case, we did not have kerberos.  i believe kerberos was the required element.

    since you are getting an authentication prompt, you might start troubleshooting your issue there.  Windows will log something in the Event log.  and if the authentication issue is coming from SQL, SQL will log something, too.  so, perhaps check your Event viewer and SQL logs.

    more on SSRS authentication here:
    LVL 1

    Assisted Solution

    I suggest you read this blog post :

    It's a valuable solution for deploying SSRS reports into SharePoint.

    If you have few reports and it's a one shot, you'll be able to do it free by using the 15 days trial.

    I hope this help!
    LVL 100

    Expert Comment

    This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    What Is Threat Intelligence?

    Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

    Hi, I have heard from my friends that it’s not possible to create Label Printing report using SSRS. I am amazed after hearing this words not possible in SSRS. I googled lot and found that it is possible to some of people know about the Report Bui…
    I thought I'd write this up for anyone who has a request to create an anonymous whistle-blower-type submission form created using SharePoint 2010 (this would probably work the same for 2013). It's not 100% fool-proof but it's as close as you can get…
    In this sixth video of the Xpdf series, we discuss and demonstrate the PDFtoPNG utility, which converts a multi-page PDF file to separate color, grayscale, or monochrome PNG files, creating one PNG file for each page in the PDF. It does this via a c…
    Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

    758 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

    10 Experts available now in Live!

    Get 1:1 Help Now