Solved

SQL Server 2008 Reporting services

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

3 Use Cases for Connected Systems

Our Dev teams are like yours. They’re continually cranking out code for new features/bugs fixes, testing, deploying, testing some more, responding to production monitoring events and more. It’s complex. So, we thought you’d like to see what’s working for us.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
email about the whoisactive result 7 35
space used inside SQL data file- PerfMon counter.. 2 25
SSRS  - Dropdown with Null 3 24
convert null in sql server 12 31
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
This Micro Tutorial hows how you can integrate  Mac OSX to a Windows Active Directory Domain. Apple has made it easy to allow users to bind their macs to a windows domain with relative ease. The following video show how to bind OSX Mavericks to …
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…

786 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