Solved

Share Data Source between multiple projects

Posted on 2009-05-08
5
288 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

Introduction Earlier I wrote an article about the new lookup functions (http://www.experts-exchange.com/A_3433.html) that ship with SQL Server 2008 R2.  In this article I’m going to show you another new feature of SSRS 2008 R2, this time in the vis…
It is helpful to note: This is a cosmetic update and is not required, but should help your reports look better for your boss.  This issue has manifested itself in SSRS version 3.0 is where I have seen this behavior in.  And this behavior is only see…
This Micro Tutorial will give you a basic overview how to record your screen with Microsoft Expression Encoder. This program is still free and open for the public to download. This will be demonstrated using Microsoft Expression Encoder 4.
This is used to tweak the memory usage for your computer, it is used for servers more so than workstations but just be careful editing registry settings as it may cause irreversible results. I hold no responsibility for anything you do to the regist…

911 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

Need Help in Real-Time?

Connect with top rated Experts

24 Experts available now in Live!

Get 1:1 Help Now