ssrs report  not connecting to correct datasource

Posted on 2011-05-04
Last Modified: 2012-05-11
Have an ssrs report that required a datasource change.  When I preview the report, it retuns the results from the original datasource not the new one.  It's driving me crazy...I've check and double-checked and the datasource is pointing to the correct sql server.  What else can it be?  
Question by:MariaHalt
    LVL 22

    Expert Comment

    by:Nico Bontenbal
    Could it be you changed the datasource in the development environment but not on the report server itself. By default shared datasources are not overwritten when you deploy the reports.
    You can set the OverwriteDataSources property on the solution properies dialog to True to change this behavior.

    If this doesn't solve your problem, please provide more details about your situation. What development environment are you using. Are you running the report in this environment or on report server itself etc.
    LVL 1

    Accepted Solution

    If your login account to your Report Manager has administrator access, do the following:


    Open the report


    Click on the Properties tab at the top


    Click on Date Sources to the left and note the location of your data source(s) - See my attached screen shot.View of Data Source for a given report.


    Navigate to the Data Sources and modify their connectionsHope this helps!
    LVL 21

    Expert Comment

    by:Alpesh Patel

    Featured Post

    Enabling OSINT in Activity Based Intelligence

    Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

    Join & Write a Comment

    Written by Valentino Vranken. Introduction: In a previous article ( I announced that I would writ…
    Time Corrections for Reports Working with a report, we made some interesting discoveries about the time corrections/updates We are using the following Parameters: Starting Entered Date (Date) formatted as Data type: "Date/Time" Ending Entered …
    how to add IIS SMTP to handle application/Scanner relays into office 365.
    In this sixth video of the Xpdf series, we discuss and demonstrate the PDFtoPNG utility, which converts a multi-page PDF file to separate color, grayscale, or monochrome PNG files, creating one PNG file for each page in the PDF. It does this via a c…

    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

    14 Experts available now in Live!

    Get 1:1 Help Now