Solved

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

Posted on 2012-04-06
6
760 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
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
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.

 

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 500 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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

Introduction Earlier I wrote an article about the new lookup functions (http://www.experts-exchange.com/A_3433.html) that ship with SQL Server 2008 R2.  In this article I’m going to show you another new feature of SSRS 2008 R2, this time in the vis…
If you have heard of RFC822 date formats, they can be quite a challenge in SQL Server. RFC822 is an Internet standard format for email message headers, including all dates within those headers. The RFC822 protocols are available in detail at:   ht…
This video shows how to quickly and easily add an email signature for all users on Exchange 2016. The resulting signature is applied on a server level by Exchange Online. The email signature template has been downloaded from: www.mail-signatures…
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…

776 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