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:

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

How to document your SharePoint Projects.

Here are the essential documents you need to complete… Initiation Business Case: To justify the financial investment in your SharePoint Project, you need to write a Business Case. It lists the costs and benefits, so everyone knows what the return on investment will be. Feasibility Study: Before you kick-off your SharePoint Project, you need to determine whether your project is feasible, using a Feasibility Study. SharePoint Project Charter: You then need to document the objectives, scope, team, timeframes and deliverables in a SharePoint Project Charter. Planning SharePoint Project Plan: You need to create a Project Plan listing all of the tasks required to undertake your SharePoint Project from start to finish. Every task must be scheduled, so you know what needs to be done and when. Resource Plan: Next, you need to plan your resources by documenting the money, equipment and materials needed for your SharePoint Project. Quality Plan: You then need to set quality targets, so that the S...
4 comments
Read more

Zambia's first Copper Concentrate Logistics System on SharePoint 2007

Ok so my workmate Charles and I just finished developing a Copper Concentrate Logistics System on SharePoint 2007. Again we do something that has never been done before in Zambia, on SharePoint!!! So here is how it works: First of all, it’s mainly using SharePoint Lists, Views dependent on your log in credentials, InfoPath Forms that pull their data from the SharePoint list based on specific selection criteria. The marketing dept captures the details of the trucks expected to arrive, only after which, the Security personnel will be able to see the details of the expected trucks and authorize entry. This then allows the truck details on empty weight and on loaded weight to be captured to the same system from the Weighbridge and sealing details confirmed. Only when the weighbridge process has been confirmed, the Security to authorize exit would be able to view the truck details, which they will use for their exit authorization. This piece of a SharePoint system generates various reports...
3 comments
Read more