I am trying to move my reports (and data sources) from one server to another.
I can move everything fine, but when I go to execute a report, it says
invalid data source, even though the data source exists with the same name as
it did on the original server. I can manually go through each report and
point them to the data source and it works fine, but I need to get this
working with little or no intervention.
--
JasonMake sure you create the shared datasource first before deploying any
reports that reference it, it should get picked up fine then.
--
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"JasonDWilson" <JasonDWilson@.discussions.microsoft.com> wrote in message
news:8005DE7C-15C1-4AAC-82C4-83F1C3FFDB75@.microsoft.com...
>I am trying to move my reports (and data sources) from one server to
>another.
> I can move everything fine, but when I go to execute a report, it says
> invalid data source, even though the data source exists with the same name
> as
> it did on the original server. I can manually go through each report and
> point them to the data source and it works fine, but I need to get this
> working with little or no intervention.
> --
> Jason
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment