Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

How to install configure SQL Server Reporting Services 2008 R2 in Standard Server Deployment

Posted on 2012-04-06
6
Medium Priority
?
781 Views
Last Modified: 2012-04-13
Hi,

Does anyone knows what are the steps to perform SQL Server 2008 R2 Reporting Services Standard Deployment a type of walk-through (Any free reference videos or links with all steps details).

As I have a requirement where I want to have it installed in organization.

Your help is appreciated.

Thanks.
0
Comment
Question by:ezkhan
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
6 Comments
 
LVL 1

Expert Comment

by:theknee
ID: 37818944
Hi,

You could start with this

Technet
msdn
0
 
LVL 14

Expert Comment

by:nishant joshi
ID: 37819929
0
 
LVL 21

Expert Comment

by:Jason Yousef, MS
ID: 37821896
Here you go...

This is a series of screen shots for details on installation, along with details about each step.
Please take some time to read and not just follow the screen shots, it's important to understand the configurations for better learning of the product.

http://www.mssqltips.com/sqlservertutorial/227/install-reporting-services/

Let me know if you need more help.
0
Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

 

Author Comment

by:ezkhan
ID: 37824100
Hi Huslayer,

The link you posted above is helpful. Let me explain my requirement in bit more detail. I want to install Report Server 2008 R2 Software on one Server machine and Report Server Databases on a different Server Machine.

The reason to do this I want to shift processing of Report Server Software to a different computer Server from our organizational transactional server holding transactional databases and ReportServer databases i.e., ReportServe Databaser and ReportServerTempDB.

Note: The computer server where I want to keep reporting server software (Service) has IIS installed on it with windows 2003 server 32 bit OS. While SQL Server 2008 R2 on transactional server where Reporting Server databases are going to be kept have installed Windows Server 2008 R2 64 bit operating system.

Your help will be greatly appreciated.

Thanks.
0
 
LVL 21

Accepted Solution

by:
Jason Yousef, MS earned 2000 total points
ID: 37825432
Hi,
Yes, just follow the steps, install only SSRS, not all the options, configure later when you install the database server.
Then on the database server, install SQL server, the engine only.

configure SSRS so it can point to the database server, and that's it...

follow the exact steps from this article, it'll show how to install only SSRS and configure it later, except you'll need to install it as a default instance, not added instance.
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/MS-SQL_Reporting/A_9498-Add-SSRS-as-a-named-instance.html

Yes, your current server setup is fine, a side note SSRS 2008 R2 or SSRS 2008 doesn't need IIS anymore, minimum hardware and software is listed here just for review also
http://searchsystemschannel.techtarget.com/feature/SQL-Server-2008-hardware-and-software-requirements


Let me know if you need more help with the install.
Thanks
Jason
0
 

Author Closing Comment

by:ezkhan
ID: 37845181
Thanks Jason.
0

Featured Post

NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!

Question has a verified solution.

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

A recent question popped up and the discussion heated up regarding updating a COMMENTS (TXT) field in a table using SSRS. http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/MS-SQL_Reporting/Q_27475269.html?cid=1572#a37227028 (htt…
In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…
We’ve all felt that sense of false security before—locking down external access to a database or component and feeling like we’ve done all we need to do to secure company data. But that feeling is fleeting. Attacks these days can happen in many w…

604 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