.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
david stephan
Gaurav Pal
Post New Web Links

Cannot deploy report to SharePoint

Posted By:      Posted Date: September 25, 2010    Points: 0   Category :SharePoint



I am having no luck deploying my SSRS report to SharePoint with Visual Studio. I have followed the steps to integrate with SharePoint and have created the Reports document library and Data connections library.

When I try to get my report deployed through Visual Studio, I get "The underlying connection was closed: Could not establish trust relationship for the SSL/TLS secure channel" error all the time.

The confusing thing is that I have not set up SSL and nothing is supposed to be running on it, even the SSRS Instance Web service is not SSL.

I have successfully integrated before a while ago but this is the first time I've run into this issue and cannot seem to get over it.

Any ideas?



View Complete Post

More Related Resource Links

Cannot export from a Report in SharePoint integrated mode in a server hardend environment


We have installed Reporting Services 2008 integrated with MOSS with SQL Server 2008 on a 64 bit platform.

The environment has worked fine in test (but the servers are not hardend).

With the production environment, any attempt to export from a report into another format (eg excel, tiff etc) results in an unexpected error within SharePoint requiring closing the browser and reopening.

There are no details behind the error. We can also find no traces of the error within any of the logs (SharePoint, Reporting Services, Windows event log etc)

When the report is opened directly from Reporting Services (ie http://servername:8080/reportserver) the report exports fine. Similarly, if the report is opened directly from Report Builder 2, or through opening Report Builder 2 from SharePoint there is no issue. This issue only happens when the report is invoked directly through SharePoint.


We can only assume that this issue has something to do with server hardening/UAC as we have

SSRS 2008 R2 and sharepoint 2007 report builder problems


I upgraded our enterprise sql server 2008 to sql server 2008 r2 last weekend.  Along with this i installed the report builder 3.0 on the servers as well and the updated ssrs add in for sharepoint.  The upgrade went fine, no errors that i could find.  The problem is now when i go to a library that has the report builder content type enabled and click report builder report under new it does not load report builder 3.0.

I updated the custom report builder url in central administration from /_vti_bin/ReportBuilder/ReportBuilder_2_0_0_0.application to /_vti_bin/ReportBuilder/ReportBuilder_3_0_0_0.application

however when i do click the new report builder report it kicks me over to http://company.com/ReportServer_MossEnt  which itemizes out each individual sharepoint site in the farm.

Is the integration of ssrs 2008 r2, sharepoint 2007 and report builder 3.0 work?  did i install the wrong version of the report builder add in?  The above is the only problem i am having now.

all servers are server 2008, 64 bit and moss 2007 enterprise with sp2 & april 2010 cu

Report Builder in sharepoint is not working.



We are using below Topology in production
Topology is 3 servers:
Sever1: Sharepoint Form (wss3.0 no MOSS)
Sever2: Sql server 2008
Server3: Reporting Services 2008
Operating system on 3 servers: Windows server 2008.
Authentication mode: Form based authentication.

 SSRS reports are working success fully in SharePoint using above topology, The issue is through SharePoint library when i am trying to access report builder reports the client is installing, after enter the credentials it is not connecting to server and am getting the following error "Unable to connecting server at 'http://servername/Reports/Forms/AllItems.aspx'  please use different url

The above issue on production only.

But in local development box there is no problem (in my development box SharePoint t, database (sql) and reporting service sits on my box only)

Thanks for your he

Item cannot be found.(rsItemNotFound) when executing a report from a sharepoint Website

I have managed to integrate Report server with Sharepoint .
I created a report with it's data connection with microsoft Visual Studio 2005 , tested it , than deployed it to the specified document libraries in sharepoint.
Everything works fine till now.But when i try to execute the report from the document library in sharepoint the Message :
  • The item 'Reports/Report1.rdl' cannot be found. (rsItemNotFound) '. Even though the report1.rdl is inside the website and is returned when i do the search. Regards.

  • SSRS - Where are the Sharepoint Report Usage Reports provided by Microsoft



    Microsoft provided 3 example reports for Sharepoint report usage. Does anyone know where they are located? I used them about 2 years ago.




    What is the best way to Create Ageing Report in SharePoint 2007?


    Hi Experts,

    I need your point of view about this and please advise,

    My client have made a request to generate Ageing Report thru their SharePoint 2007, FYI all invoice was scan and upload to sharepoint and save as PDF file under Document Library. During the scan, certain information will capture automatically and save it into field that we defined inside the Web Form.   

    Below is the basic input we capture:

    Vendor Code, Vendor Name, Invoice Number, Invoice Date, Currency, Invoice Amount

    Report Requirement (display list and group of:)

    - Vendor Code, Vendor Name, No. Of Invoice, Total Payable, Ageing 0-30, Ageing 30-60, Ageing 60-90, Ageing>90 

    So my question is, what is the best platform to create this Ageing Report??

    because when i try to design the report thru Visual Studio (Reporting Services), i can't identified which database should i connect and which table is store all the invoice information in SharePoint.

    Any idea guys?? anybody have implemented it before??


    Cannot add SQL Server 2008 R2 Report items to SharePoint Server 2010 document library

    Using account which is the primary parent site administrator, can upload RDS and RDL files to the document library (however, cannot open report). User is also a domain admin with SA on the database instances. Cannot add Report Data Source with "New Document" icon. The permissions granted to user '[domain]\[user]' are insufficient for performing this operation. Under "Site Settings", "Managed Shared Schedules" fails with same error. Attempting to deploy from BIDS results in the same permissions error. Sharepoint Server 2010, Report Server 2008 R2. RS and SP databases hosted on remote server (SQL Server 2008 R2). All connections (SharePoint services, RS services, users) except SQLAgent authenticating to remote SQL Server with Kerberos (all SPNs look correct). Single site, site collection "/". Document directory called "Reports". Windows Integrated Security (Negotiate). How would I troubleshoot/solve problem?

    Sharepoint Crystal Report Webpart

    Hi, I have deployed crystal report web part in live server sharepoint site.using .rpt file method. When i select the rpt file the system does not show the data and graph anything So kindly give me the idea to recover from this issue Regards S.Madeswaran    

    How to get "Current Date" on SharePoint Designer for Invoice Ageing Data View Report??

    Hi Experts, I would like to know how can i get/show "Current Date" in SharePoint Designer ?? Any good tutorial ? FYI, I need this "Current Date" for my Ageing Data View Report, Purpose To offset with "Invoice Receive Date" to get total days of payment payable for the invoice. Please assists, Thanks

    Can I deploy a custom site page from the VS2010 SharePoint project?

    Hi We're setting up some demos of our sharepoint plugins and want to easily deploy these into sharepoint so that all members of the company can easily get the demos running on their own machines. This is fine for layouts, web parts and so on - but the demo also has a customised sharepoint home page (which I edited in SP Designer) - how do I make this edited home page part of the VS2010 project so that it can be deployed easily to any site collection?   Thanks  

    SharePoint 2010 Reporting Services report on sharepoint list rsExecutionNotFound

    I cannot get SQL Reporting Services 2008 R2 to work with a datasource that is a sharepoint list.  Reporting services seems to work fine setup in SharePoint 2010 Integrated mode. When I try and run a report that is based on a sharepoint list, I immediatly get the following error: The report execution tp15sp4515l3seqqo4do3e45 has expired or cannot be found. (rsExecutionNotFound) This seems to be something I am doing wrong with the sharepoint configuration, I would guess.  I haven't tried a regular database query, but they used to work when reporting services was configured for native mode.  So I assume this is just a problem connecting to sharepoint 2010 lists, with the new SharePoint 2010 List connection type. Edit This has got to have something to do with a permission setting for the app pool account of sharepoint.  I read something once where it said you had to grant it permissions, but every guide I've found since then doesn't mention anything about it. This log entry is where the problem seems to be occuring, I just don't know what permissions to give TESTDOMAIN\spweb which is the app pool account. library!ReportServer_0-3!1bdc!09/01/2010-09:58:03:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerStorageException: , An error occurred within the report server database.  This may be due to a connection failure, tim

    Report Builder 3 report preview error in SharePoint integrated mode

    Hello folks! I've faced some strange error with RB 3.  My environment is: Win 2008R2+SQL2008R2 CU3+Sharepoint Foundation services 2010 SharePoint services integrated with Reporting Services.  When I try to run RB3 from SharePoint library and built some report I get strange error at the previw screen : Failed to preview report. The item 'http://myserver/cd6409dc-1089-4e8a..' cannot be found. Details: System.Web.Services.Protocols.SoapException: The item 'http://myserver/cd6409dc-1089-4e8a-a2a4-f231c97039aa' cannot be found. ---> Microsoft.ReportingServices.Diagnostics.Utilities.ItemNotFoundException: The item 'http://myserver/cd6409dc-1089-4e8a-a2a4-f231c97039aa' cannot be found.    at Microsoft.ReportingServices.WebServer.ReportingService2010Impl.CreateReportEditSession(String Report, String Parent, Byte[] Definition, String& EditSessionID, Warning[]& Warnings)    at Microsoft.ReportingServices.WebServer.ReportingService2010.CreateReportEditSession(String Report, String Parent, Byte[] Definition, String& EditSessionID, Warning[]& Warnings)  The most intresting thing, that my test environment with Win 2008R2 CTP+SQL2008R@ Nov CTP is working properly without any error. Could you please advise how to resole this problem? Thanks in advance, Andre.  

    Failing while trying to deploy Sharepoint Server 2010

    Hi, I am installing Sharepoint Server 2010 in [ Windows Server 2008 SP2 win SQL Server 2008 R2 installed]. Installation  fails  with message Configuration failed . The following error in the error log 23:09:10  9  INF                    Creating connection string for config db SharePoint_Config server sharepointalias 08/21/2010 23:09:10  9  INF                    Creating connection string for admin content db SharePoint_AdminContent_b6892e2d-f9c1-4c75-aac5-c7ebefb032ca server sharepointalias 08/21/2010 23:09:10  9  INF                    Using NTLM for sql connection string 08/21/2010 23:09:10  9  INF                    Creating a new farm with config db SharePoint_Config content db SharePoint_AdminContent_b6892e2d-f9c1-4c75-aac5-c7ebefb032ca server sharepointalias for farm mode 08/21/2010 23:09:10  1  INF                    Not running in high contr

    SharePoint - Report Server - Client Certificate authentication

    Hi,I have a SharePoint site collection which requires client certificates. On the server I have configured Reporting Services in integration mode.I can call reports on other site collections which don't require client certificates but not on the site which does. On the site which requires client certificates the pages fail with the following error message:'An unexpected error occurred while connecting to the report server. Verify that the report server is available and configured for SharePoint integrated mode. --> The request failed with HTTP status 403: forbidden'The error message indicates that SharePoint doesn't call the web service with a client certificate. Does anyone know how I can configure SharePoint to use a client certificate?Any help is greatly appreciated.Adam

    How to Schedule SSRS Report from SharePoint

    I don't want to use SSRS web service to schedule SSRS report rather than wants to use sharepoint jobs to schedule SSRS report. Let me know possibilty. Technology - SQL Server 2008 R2 - SharePoint 2010     

    SharePoint and SQL reporting services. Report of access?

    Hello,Can a report be created with SharePoint and SQL reporting services that shows who has accessed the document and when?Thanks in advanceSebastian  

    Use Report Builder 3.0 with SharePoint site using a port number

    We are currently working with SSRS R2 and SharePoint 2010.  SharePoint 2010 has been deployed a multitenant solution.  SharePoint and SSRS are on separate servers.  We have successfully integrated the two products but are experiencing some anomolies.  The SharePoint site we are deploying to uses a port number (e.g. http://mysharepointsvr:2222).  When you launch Report Builder from this site, it does not open connected to a Report Server.  When you try to connect to a Report Server the obvious choice is to put in http://mysharepointsvr:2222 for the Report Server service.  However, this does not work.  We are getting the following error: Connection Failed.  Unable to connect to the server that is specified in the URL, 'http://mysharepointsvr:2222'.  Make sure the server is running, the URL is correct, and you have permission to use the server. However, if we use the SharePoint address without the port number it will connect.  This does not work as the SharePoint port determines which site we are directed to for resources.  In our case, we need to be able to browse the folders on port 2222 not port 80 (default).  As far as the error above is concerned, we are able to browse to the report server (http://sql101/reportserver) and see all of the SharePoint sites.  In all cases, identical credentials are being u
    ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
    Sql Server  SharePoint  Silverlight  Others  All   

    Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend