Solved

Share Data Source between multiple projects

Posted on 2009-05-08
5
290 Views
Last Modified: 2012-05-06
Hi, is it possible to share a data source between multiple projects in the same solution? If so, how?

Thanks
0
Comment
Question by:mr_patel
  • 2
  • 2
5 Comments
 
LVL 9

Expert Comment

by:Hwkranger
ID: 24339109
No you cant.  But you can use your source control, write a script, or hand copy them to keep them in sync.
0
 
LVL 26

Accepted Solution

by:
Chris Luttrell earned 100 total points
ID: 24339975
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
 

Author Comment

by:mr_patel
ID: 24339989
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
 
LVL 26

Expert Comment

by:Chris Luttrell
ID: 24340984
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
 

Author Closing Comment

by:mr_patel
ID: 31579587
I ended up "adding existing" data source for 10 projects!
0

Featured Post

3 Use Cases for Connected Systems

Our Dev teams are like yours. They’re continually cranking out code for new features/bugs fixes, testing, deploying, testing some more, responding to production monitoring events and more. It’s complex. So, we thought you’d like to see what’s working for us.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This code started out as a fix for a customer that had incoming data that was hunderds of numbers and words long that was to fit in one column. The problem was that the customer did not want to split words or numbers when wrapping in the column. …
Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
Microsoft Active Directory, the widely used IT infrastructure, is known for its high risk of credential theft. The best way to test your Active Directory’s vulnerabilities to pass-the-ticket, pass-the-hash, privilege escalation, and malware attacks …
Established in 1997, Technology Architects has become one of the most reputable technology solutions companies in the country. TA have been providing businesses with cost effective state-of-the-art solutions and unparalleled service that is designed…

803 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question