• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 313
  • Last Modified:

Share Data Source between multiple projects

Hi, is it possible to share a data source between multiple projects in the same solution? If so, how?

Thanks
0
mr_patel
Asked:
mr_patel
  • 2
  • 2
1 Solution
 
HwkrangerCommented:
No you cant.  But you can use your source control, write a script, or hand copy them to keep them in sync.
0
 
Chris LuttrellSenior Database ArchitectCommented:
As stated you can not share them, but you can import them from an existing item.  In Solution Explorer right click on the Project or Shared Data Sources > Add > Existing Item  and go find one or more data souces to include.  It will copy the rds file to this project.
SSRS-Add-Existing-DataSource.png
0
 
mr_patelAuthor Commented:
Hi CGLuttrell, I tried doing that, but it doesn't save the credentials. Is there anyway to save the credentials when I add an existing one?
Thanks.
0
 
Chris LuttrellSenior Database ArchitectCommented:
I believe that is a security consideration that MS does not maintain supplied credentials with just the .rds file.  It seems that I read that in MS documentation some where but I can not find it now.  I see references to "Credentials stored securely in the report server" though.  If it did keep username/password someone could just copy your rds file and gain access to a database.
0
 
mr_patelAuthor Commented:
I ended up "adding existing" data source for 10 projects!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now