Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 681
  • Last Modified:

SSRS Report Saved In Sharepoint Libary

Hi All

I am still new to SSRS And Report Builder i have created a report and saved it onto my sharepoint Library, however if a user clicks in the .rdl report file to view it they get the following error message

An error has occurred during report processing. (rsProcessingAborted)
Cannot create a connection to data source 'DataSource1'. (rsErrorOpeningConnection)
For more information about this error navigate to the report server on the local server machine, or enable remote errors

Its probably something i have missed can anybody help?

Thank You
0
pepps11976
Asked:
pepps11976
  • 3
  • 2
1 Solution
 
AndrewSkoraroCommented:
Try setting the connection properties of the data source in SharePoint.  Do this to the actual library item in SharePoint.
0
 
pepps11976Author Commented:
Ok This might be wear i am going wrong all i did was click save as in report builder and saved to a document libary, i am not ware of any data source created, where would this be?
0
 
AndrewSkoraroCommented:
This would be in a library that has the SSRS data source content type.  It can be the same library as the report. Create a Shared Data source in report builder and save it (publish) to the document library. Once its there, you can edit its connection properties. You will need to use this data source in your report instead of an embedded one.
0
 
pepps11976Author Commented:
You only have the option to Use an Existing One Or Create an Embedded one in Report Designer.

So i have used the embedded one and i have found where it puts it in sharepoint, the only way that i can get it to work is by using The SA account where you select the radio button for stored credentials.

This cant be the right way to do this though
0
 
AndrewSkoraroCommented:
Your system may not be setup to support passing through the users credentials (I.E: kerberos). I would recommend creating an account in SQL server that has read access to the stored procs or databases that your reports require. This way you dont use the SA account.



0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now