deploy shared data source

I have modified a shared data source and when I deployed it, the data source
on the Report Manager page did not change. I then deleted the data source
from the Report Manager and redeployed the data source. Then the reports
errored with a data source not found error, so I redeployed the entire
project, but now, even thought the shared data source is in it's original
location all of my reports (50) say that The shared data source reference is
no longer valid. I have redeployed my project again with the same results.
Any help would be appreciatedAre you doing this with RS 2000 or RS 2005?
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Robert Willhite" <RobertWillhite@.discussions.microsoft.com> wrote in
message news:2D8DD698-0E6A-463F-92B2-86EF2BE3C2D0@.microsoft.com...
>I have modified a shared data source and when I deployed it, the data
>source
> on the Report Manager page did not change. I then deleted the data source
> from the Report Manager and redeployed the data source. Then the reports
> errored with a data source not found error, so I redeployed the entire
> project, but now, even thought the shared data source is in it's original
> location all of my reports (50) say that The shared data source reference
> is
> no longer valid. I have redeployed my project again with the same
> results.
> Any help would be appreciated
>|||I am doing this with RS 2000
"Bruce L-C [MVP]" wrote:
> Are you doing this with RS 2000 or RS 2005?
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Robert Willhite" <RobertWillhite@.discussions.microsoft.com> wrote in
> message news:2D8DD698-0E6A-463F-92B2-86EF2BE3C2D0@.microsoft.com...
> >I have modified a shared data source and when I deployed it, the data
> >source
> > on the Report Manager page did not change. I then deleted the data source
> > from the Report Manager and redeployed the data source. Then the reports
> > errored with a data source not found error, so I redeployed the entire
> > project, but now, even thought the shared data source is in it's original
> > location all of my reports (50) say that The shared data source reference
> > is
> > no longer valid. I have redeployed my project again with the same
> > results.
> >
> > Any help would be appreciated
> >
>
>|||First, so you can understand what happened along the way. When you deploy
the default is that the shared datasource does not overwrite. The reason is
so you can have a shared data source when developing that points to a
development database and then when deployed the datasource points to
production. So deleting and deploying again works (you can also force the
deploy to overwrite but I have never done that). Usually when re-deploying a
datasource the issue that comes up are the credentials. In report manager
open up the data source and make sure the credentials are correct.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Robert Willhite" <RobertWillhite@.discussions.microsoft.com> wrote in
message news:34B4224C-6043-4527-83B3-D216414B1A9B@.microsoft.com...
>I am doing this with RS 2000
> "Bruce L-C [MVP]" wrote:
>> Are you doing this with RS 2000 or RS 2005?
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "Robert Willhite" <RobertWillhite@.discussions.microsoft.com> wrote in
>> message news:2D8DD698-0E6A-463F-92B2-86EF2BE3C2D0@.microsoft.com...
>> >I have modified a shared data source and when I deployed it, the data
>> >source
>> > on the Report Manager page did not change. I then deleted the data
>> > source
>> > from the Report Manager and redeployed the data source. Then the
>> > reports
>> > errored with a data source not found error, so I redeployed the entire
>> > project, but now, even thought the shared data source is in it's
>> > original
>> > location all of my reports (50) say that The shared data source
>> > reference
>> > is
>> > no longer valid. I have redeployed my project again with the same
>> > results.
>> >
>> > Any help would be appreciated
>> >
>>