Solved

SQL Server 2008 Reporting services

Posted on 2011-03-25
1
209 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 14

Accepted Solution

by:
Daniel_PL earned 500 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

U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

Question has a verified solution.

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

Suggested Solutions

How to leverage one TLS certificate to encrypt Microsoft SQL traffic and Remote Desktop Services, versus creating multiple tickets for the same server.
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
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…
With the power of JIRA, there's an unlimited number of ways you can customize it, use it and benefit from it. With that in mind, there's bound to be things that I wasn't able to cover in this course. With this summary we'll look at some places to go…

863 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

18 Experts available now in Live!

Get 1:1 Help Now