Newbie Question

I'm new to Reporting Services 2005. My question is this. Say I create a
report that retrieves data from database "xyz". Assume also that identical
copies of database "xyz" (identical in schema, not in the data it contains)
might be sitting on many different servers, servicing different clients. Is
it a simple matter to simply change the connection string of the report and
have it retrieve data from a different server the database is sitting on?
I guess what I'm really wondering is what sort of data sits in the
'ReportServer' database and does this data need to get moved to the same
ReportServer database on each server I want to run the report against? If
this is not the case, and I'm hoping it's not, what data actually gets
stored in the 'ReportServer' database.
Thanks.
Amos.The ReportServer database stores the metadata and the catalog.
I does not stores the data used by your reports
I your case, changing the connection string should be enough
Med Bouchenafa
"Amos Soma" <amos_j_soma@.yahoo.com> a écrit dans le message de news:
eehPKcEJGHA.984@.tk2msftngp13.phx.gbl...
> I'm new to Reporting Services 2005. My question is this. Say I create a
> report that retrieves data from database "xyz". Assume also that identical
> copies of database "xyz" (identical in schema, not in the data it
> contains) might be sitting on many different servers, servicing different
> clients. Is it a simple matter to simply change the connection string of
> the report and have it retrieve data from a different server the database
> is sitting on?
> I guess what I'm really wondering is what sort of data sits in the
> 'ReportServer' database and does this data need to get moved to the same
> ReportServer database on each server I want to run the report against? If
> this is not the case, and I'm hoping it's not, what data actually gets
> stored in the 'ReportServer' database.
> Thanks.
> Amos.
>