Solved

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

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

Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

Question has a verified solution.

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

Suggested Solutions

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…
These days socially coordinated efforts have turned into a critical requirement for enterprises.
In a recent question (https://www.experts-exchange.com/questions/28997919/Pagination-in-Adobe-Acrobat.html) here at Experts Exchange, a member asked how to add page numbers to a PDF file using Adobe Acrobat XI Pro. This short video Micro Tutorial sh…
Microsoft Active Directory, the widely used IT infrastructure, is known for its high risk of credential theft. The best way to test your Active Directory’s vulnerabilities to pass-the-ticket, pass-the-hash, privilege escalation, and malware attacks …

770 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