• > did you use a shared data source name when the test report was built?

    > If so, does this shared data source exist in the production environment?

    > If the data source did already exist (you can check this in the Report Services Reports/Pages/Folder.aspx page), which database is it pointing to?

    reason for my questions is that, when reports are deployed using an existing shared data source, the data source is not replaced, but the existing one will automatically be used by the report.

    to check this, in the reports properties, go to the data sources tab and see which datasource it is linked to.

    ____________________________________________
    Space, the final frontier? not any more...
    All limits henceforth are self-imposed.
    “libera tute vulgaris ex”