Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Can two different databases share the same Report Service/Report Manager, and the same reportserver database? Expand / Collapse
Author
Message
Posted Wednesday, May 8, 2013 12:15 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, July 24, 2014 11:12 AM
Points: 2, Visits: 22
Hi,

I have a SQL 2008 R2 server which already set up a report manger. Current the report manager has a data sources and report folders for a one database1 application. Now I am planing to implement second database2 to the same SQL server. Can I use the same report server/report manger, and reportserver database to hold both of database1 and database2 reports? Of course I will create different data source folder, and different reprot folders.

If I can , is there anything specifically I should pay attentions?


Any suggestion or idea is much appreciated.

Thanks a lot.

Post #1450734
Posted Wednesday, May 8, 2013 10:16 PM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Yesterday @ 9:10 PM
Points: 2,995, Visits: 2,592
You can definitely do what you are wanting to do.

A single report services instances can be used to run reports that access databases on pretty much any server you want provided that you have the appropriate drivers installed on the server. So, multiple databases on the same database server - easy.

All you need to create the datasources for each database and the reports that use them.



Post #1450877
Posted Thursday, May 9, 2013 6:29 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, July 24, 2014 11:12 AM
Points: 2, Visits: 22
Thank you so much, HappyCat59.

You answered my question.
Post #1451070
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse