Solved

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

Posted on 2012-04-09
4
518 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:
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

How Do You Stack Up Against Your Peers?

With today’s modern enterprise so dependent on digital infrastructures, the impact of major incidents has increased dramatically. Grab the report now to gain insight into how your organization ranks against your peers and learn best-in-class strategies to resolve incidents.

Question has a verified solution.

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

Suggested Solutions

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…
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…
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…

679 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