SQL Server 2008 Reporting services

Hello, I have two questions, first I would like to know if I can use a reportserver that is install on a sql server 2008 to take out reports from a sql server 2008R2.  What I mean is the database and applications are on a sql server 2008R2 but the reportserver will be on another sql server 2008.
Question number 2 is: after I use the reporting services configuration manager to configure the reportserver, is there anything else that I have to do or install to get it to take reports.
vera2006Asked:
Who is Participating?
 
Daniel_PLConnect With a Mentor DB Expert/ArchitectCommented:
Ad1) Yes, you can.
Ad2) You need to create reports or download sample reports from codeplex website. When you need granular permissions you need to define security: http://msdn.microsoft.com/en-us/library/ms156014%28v=SQL.100%29.aspx

Some info about initial install:
http://msdn.microsoft.com/en-us/library/bb522676%28v=SQL.100%29.aspx
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.

All Courses

From novice to tech pro — start learning today.