all groups > sql server reporting services > august 2005 >
You're in the

sql server reporting services

group:

deploy shared data source


deploy shared data source Robert Willhite
8/6/2005 5:24:01 PM
sql server reporting services:
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
Re: deploy shared data source Bruce L-C [MVP]
8/6/2005 9:37:04 PM
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...
[quoted text, click to view]

Re: deploy shared data source Robert Willhite
8/6/2005 11:40:21 PM
I am doing this with RS 2000

[quoted text, click to view]
Re: deploy shared data source Bruce L-C [MVP]
8/7/2005 10:36:51 AM
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...
[quoted text, click to view]

AddThis Social Bookmark Button