Solved

Installing RoportServer 2008 R2 software and it's databases on different computer servers.

Posted on 2012-04-09
4
509 Views
Last Modified: 2012-04-10
Hi,

Can you please assist me to install Report Server 2008 R2 on a different computer. I want to install Report server 2008 R2 databases(ReportServer and ReportServerTempDB) on one server and Report Server 2008 R2 on a different Server machine.

Can you please help to list down the steps required to accomplish this task. I have already gone through Microsoft documentation but, it explains it in terms of scale-out deployment with more than one report servers and Network Load Balance software/hardware. I do not have requirement to implement through NBL. I just want to shift report server processing/functionality to another server and dont want to keep it on transactional server of the production environment where I want to have only ReportServer Databases only.

Note: I need this requirement don on both Native Mode and Sharepoint2010 Integrated mode but on altogether different domains.

Your suggestions and comments are appreciated.

Thanks.
0
Comment
Question by:ezkhan
  • 2
  • 2
4 Comments
 
LVL 21

Accepted Solution

by:
huslayer earned 500 total points
ID: 37825444
Hi,

That's easy...just install SQL server (the DB engine?) on your database server.
then go to the other server and install only SSRS, when you configure the SSRS service you could point to any DB server later.

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


Let me know if you need more help
Thanks
Jason
0
 

Author Comment

by:ezkhan
ID: 37825534
Hi Jason,

Thanks for answer and a detailed article to explain the process. It is really helpful. One more thing the computer server where I want to install report server 2008 R2 service has windows server 2003 32 bit operating system installed on it and IIS is also installed on it and there is no existing installation of SQL Server or reporting services. On the other  side the server where I want to have reporting databases configured has Windows Server 2008 R2 64 bit installed on it.

Now it creates two confusions in mind;

1. Operating system compatibility between two servers.
2. Existing IIS installation on server where I want to install Report Server Service will create some issues or conflicts?

Can you please help to resolve these issues.

Many Thanks.
0
 
LVL 21

Assisted Solution

by:huslayer
huslayer earned 500 total points
ID: 37825593
there won't be conflict between the 2 OSs, SQL 2008 or 2008R2 doesn't need or install IIS, so the current environment won't be intact :)
0
 

Author Closing Comment

by:ezkhan
ID: 37827476
Thanks a lot Jason. That's an excellent answer of my problem.
0

Featured Post

How to improve team productivity

Quip adds documents, spreadsheets, and tasklists to your Slack experience
- Elevate ideas to Quip docs
- Share Quip docs in Slack
- Get notified of changes to your docs
- Available on iOS/Android/Desktop/Web
- Online/Offline

Join & Write a Comment

SQL Server engine let you use a Windows account or a SQL Server account to connect to a SQL Server instance. This can be configured immediatly during the SQL Server installation or after in the Server Authentication section in the Server properties …
I thought I'd write this up for anyone who has a request to create an anonymous whistle-blower-type submission form created using SharePoint 2010 (this would probably work the same for 2013). It's not 100% fool-proof but it's as close as you can get…
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

708 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

12 Experts available now in Live!

Get 1:1 Help Now