Post reply

Installaing Reporting services in a separate server

  • February 5, 2010 at 3:10 pm

    #138078

    Hi,

    We have SQL Server 2005 Enterprise Edition x64 with SP3 with only database engine installed on Server A. Now are planning to install only Reporting services Standard Edition x64 with SP3 on Server B. But we want to configure to keep the ReportServer & ReportServerTempDB on Server A. Because we are NOT using Enterprise edition features for SSRS and want to save some money by installing standard edition

    Is using Standard edition for Reporting services and keeping the databases ReportServer & ReportServerTempDB on Enterprise edition supported?

    I remember that I read some different kind of Edition combination for SSRS & Database engine but currently I'm not able to find those links

    I appreciate your help

    Thanks

  • February 6, 2010 at 2:28 am

    #1114958

    Here is the link that you were looking for http://msdn.microsoft.com/en-us/library/ms157285.aspx

    --Ramesh

  • February 6, 2010 at 10:56 am

    #1115032

    This document http://www.microsoft.com/sqlserver/2005/en/us/Special-Considerations.aspx#passive describes the different configuration possibilities and how they need to be licensed.

    It also shows the various supported configurations for Reporting Services which your suggested configuration is included.

    So, yes - you can keep your reporting services databases on your Enterprise system and setup/configure reporting services on a separate system.

    Now, unless you really need a separate database engine on your reporting server I would not recommend installing it. That way, all you have to worry about on that system is IIS and Reporting Services. But, if you are going to install the DB engine on that server - then there really is no reason not to move the reporting server databases over to that new instance.

    Jeffrey Williams
    “We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”

    ― Charles R. Swindoll

    How to post questions to get better answers faster
    Managing Transaction Logs

  • February 6, 2010 at 12:04 pm

    #1115047

    thank you,

    I found the exact link...

    http://www.microsoft.com/sqlserver/2005/en/us/special-considerations.aspx#reporting

    thanks

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply