Shared Data Sources

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Patrick Hill - 29 Sep 2006 17:25 GMT

hi, We have multiple servers with sql server. All of the databases have the
same structure, tables etc.. just for different clients. in my RS project
I have a shared datasource that points to a local dev copy of the database.
Now if we open that project on another machine it trys to connect to my copy
of sql server. Is there a way to make the datasource genric so that no
matter what database we are looking at it will work the same way

Reply to this Message

Bruce L-C [MVP] - 29 Sep 2006 18:02 GMT

When you deploy you setup the shared datasource to point where you want. The
default when deploying is to not overwrite so you will only have to make
this change the first time you deploy.

Signature

Bruce Loehle-Conger
MVP SQL Server Reporting Services

> hi, We have multiple servers with sql server. All of the databases have
> the same structure, tables etc.. just for different clients. in my RS
[quoted text clipped - 3 lines]
> genric so that no matter what database we are looking at it will work the
> same way

Reply to this Message