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.