Solved

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

Posted on 2012-04-09
4
525 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
[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
  • 2
  • 2
4 Comments
 
LVL 21

Accepted Solution

by:
Jason Yousef, MS 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:Jason Yousef, MS
Jason Yousef, MS 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

Office 365 Training for IT Pros

Learn how to provision tenants, synchronize on-premise Active Directory, implement Single Sign-On, customize Office deployment, and protect your organization with eDiscovery and DLP policies.  Only from Platform Scholar.

Question has a verified solution.

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

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…
These days socially coordinated efforts have turned into a critical requirement for enterprises.
In this video, viewers are given an introduction to using the Windows 10 Snipping Tool, how to quickly locate it when it's needed and also how make it always available with a single click of a mouse button, by pinning it to the Desktop Task Bar. Int…
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…

626 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