Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 531
  • Last Modified:

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

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
ezkhan
Asked:
ezkhan
  • 2
  • 2
2 Solutions
 
Jason Yousef, MSSr. BI DeveloperCommented:
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
 
ezkhanAuthor Commented:
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
 
Jason Yousef, MSSr. BI DeveloperCommented:
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
 
ezkhanAuthor Commented:
Thanks a lot Jason. That's an excellent answer of my problem.
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now