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

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.
ezkhanAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

thekneeCommented:
Hi,

You could start with this

Technet
msdn
0
Jason Yousef, MSSr. BI  DeveloperCommented:
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
Cloud Class® Course: Microsoft Windows 7 Basic

This introductory course to Windows 7 environment will teach you about working with the Windows operating system. You will learn about basic functions including start menu; the desktop; managing files, folders, and libraries.

ezkhanAuthor Commented:
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
Jason Yousef, MSSr. BI  DeveloperCommented:
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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
ezkhanAuthor Commented:
Thanks Jason.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
SSRS

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.