Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

I am currently in the process of setting up a crystal report server but before I even start I am trying to plan the best method.

Should the Crystal Report Server software be installed on the same server as the SQL server? What are the pros and cons?

Or should the crystal report server software be installed on its own virtual server?

Thanks

share|improve this question
add comment

2 Answers

up vote 1 down vote accepted

You'll typically want Crystal installed on another machine. You usually don't want anything installed on the SQL Server other than SQL Server.

This way that any load that Crystal places on the OS when running reports (which can be a lot depending on how much data is in the reports) doesn't take away from the SQL Server.

share|improve this answer
add comment

As MrDenny states -- its good form when economically feasible to segment the SQL server from any application servers, be it Crystal Reports, SharePoint, or another line of business application. That being said, you mention installing Crystal on its own Virtual Server, in which case it sounds like your SQL server shares that same virtual server (is that so?).

If that is the case -- you may not see any initial benefit from the segmentation. If you decide to install Crystal on the SQL server, consider giving it its own IP and hostname such that if you decide later to segment the services onto seperate machines (or virtual machines) it is an easy migration.

share|improve this answer
    
Thanks for the help guys. –  Thomas S Aug 19 '09 at 13:18
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.