Skip to main content

Report Server in SharePoint Integrated Mode Error: Cannot create a connection to data source 'DatasSource1'

So having made my report using Business Intelligence Development studio, i successfully deployed it to my Sharepoint Reports Library.

When i tried to access the report from SharePoint, BOMB!!!

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

So after 24 hours of hitting my head against the wall, i got it right.

Try this:
1. open your http://sharepointserver/reports/data connections/
2. click to open the data connection
3. On the credentials section, click the "stored credentials" radio button, type in a domain account in the format 'MYDOMAIN\Accountname' and it password. Note that this account can be the service account of your farm, assuming that its also the account that the report server is using when connecting to the report server database (well at least that's how my farm is)
4. Check the two boxes for "Use as windows credentials" and for "Set execution context to account"
5. click ok and you should be good to go

Labels

Labels:

Comments

Anonymous said…
Thank you very much.. Its really helpful.
November 4, 2011 at 4:08 AM
Post a Comment

Popular posts from this blog

Zambia's first K2 BlackPoint roll-out

Reporting to you live from Code|Influence... My colleague and I have been managing our organization's SharePoint infrastructure for some time now and we have just rolled out the first K2 BlackPoint in the country, intended mostly for SharePoint workflow developments.
8 comments
Read more

Zambia's first Helpdesk System on SharePoint

For my 25th birthday today 3rd March, 2009, allow me to present to you another first of its kind in Zambia. Yes we have done it again, having been Project manager, I present to you Zambia's first Helpdesk System which Masialeti and I have developed on Microsoft Office SharePoint Server 2007. The system also implements SharePoint designer workflows, Infopath forms, SharePoint document library and sends email notifications to the relevant personnel. When a user logs in a call, the user automatically receives a mail from the system, telling them that their call has been received and is being attended to, IT section will also receive a notification and the helpdesk manager will assign the call to the right IT guy who will also automatically receive a mail notification from the system. When the call is resolved, the user again automatically gets notified by the system with a mail giving them description of the problem they logged and also how it has been resolved. The user also has an ...
7 comments
Read more

How to implement a SharePoint "Change Management Process"

Not so much from the technical point of view, SharePoint Change Management is the process of monitoring and controlling changes within a SharePoint project. By managing the implementation of change, you can: • Reduce the impact of changes to the SharePoint project • Identify new issues and risks as a result of changes raised • Ensure that changes do not affect the SharePoint project's ability to achieve its desired objectives • Control the cost of change within the SharePoint project Change Management is comprised of the following processes: Step 1: Identify Change: The first step in the change process is to identify the need for change. Any team member can suggest a change to the SharePoint project, if he or she believes it is needed to keep the SharePoint project producing deliverables to the customer's specified requirements. After identifying a need for change, the team member records relevant information on a Change Request Form (commonly called a CRF), describing the chan...
2 comments
Read more