Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

SQL Server 2008 Reporting services

Posted on 2011-03-25
1
Medium Priority
?
233 Views
Last Modified: 2012-05-11
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.
0
Comment
Question by:vera2006
1 Comment
 
LVL 15

Accepted Solution

by:
Daniel_PL earned 2000 total points
ID: 35213734
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

Featured Post

Visualize your virtual and backup environments

Create well-organized and polished visualizations of your virtual and backup environments when planning VMware vSphere, Microsoft Hyper-V or Veeam deployments. It helps you to gain better visibility and valuable business insights.

Question has a verified solution.

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

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…
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
Integration Management Part 2
When cloud platforms entered the scene, users and companies jumped on board to take advantage of the many benefits, like the ability to work and connect with company information from various locations. What many didn't foresee was the increased risk…

580 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