Cannot create a connection to data source 'dataSource1'.

Posted on 2007-07-23
Last Modified: 2008-01-09

We are using SQL Server 2005 Report Services, Report Builder, and we've created a Report model and  deployed it to the server. When i run the a report builder on the network it runs fine. When I run the report from anywhere else,  I get the error below, when I press 'run report'.


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


 I don't have a datasource called 'dataSource1'. We are allowing anonymous users to the report builder, and the system automatically prompts the user for a usernm/pwd for authentication. I'm not sure what we might have setup wrong here.  Has anyone seen this error before?
Question by:ms568
    LVL 51

    Expert Comment

    Even with a anonymous connection you need a SQL source.  When you deploy a report you HAVE to deploy a data source as well.

    Author Comment

    Ah I think I didnt describe that clearly. I do have a data source defined and it is linked to the report model, but the name is not 'dataSource1'. The data source does use is an impersonated windows account to access the database (since we have our database setup to allow only windows accounts to connect)
    LVL 51

    Expert Comment

    Hmm, I would use Notepad to look at the XML source for the report.  Search it and make sure that there isn't a reference to dataSource1.

    Accepted Solution

    The XML source did not have a reference to dataSource1.

    What ended up being the problem was that in Report Manager, my user account did not rights to run a report. Two steps were necessary 1) create a system role with 'Execute Report Definitions' task rights. 2) Grant my app user rights to this system role.

    To add this system role, from the Report Manger go to 'Site Settings', then 'Configure system-level role definitions'. Select Add New and check task 'Execute Report Definitions', and save.

    To add the user to this system role, go to 'Site Settings', and 'Configure site-wide security'. Here add the app user and grant them permission to the system role created above.

    This fixed my problem of not being able to run the report.

    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    Join & Write a Comment

    This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
    I've been asked to discuss some of the UX activities that I'm using with my team. Here I will share some details about how we approach UX projects.
    The viewer will learn how to look for a specific file type in a local or remote server directory using PHP.
    Any person in technology especially those working for big companies should at least know about the basics of web accessibility. Believe it or not there are even laws in place that require businesses to provide such means for the disabled and aging p…

    745 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

    15 Experts available now in Live!

    Get 1:1 Help Now