Post reply

Installation of Reporting services on separate machine

  • November 10, 2017 at 3:14 am

    #333632

    Hi,
    Thanks to everyone contributing to the solutions here. 

    Here is the scenario:

    I have fresh DW setup going on. We have 1 SQL server Licence. A proposed solution was to have Reporting services entirely on different machine.

    Is this possible to move Reporting services (its databases ReportServer and ReportServerTempDb to different location say Machine2) and  fetch data from Machine1 where  SQL Server is installed. 

    I googled over and had mixed answers. Forums seems to suggest that if you go for ReportServer on different Machine it would need additional SQL server licence for it i.e Machine2 in this case.

    Please clarify if we need additional licence  or  there any work around.

    Thanks,
    SQLSniffer

  • November 10, 2017 at 3:41 am

    #1967499

    You would need an additional licence.

  • November 10, 2017 at 4:02 am

    #1967501

    Thanks SSChampion

  • November 16, 2017 at 10:12 am

    #1968400

    Hi All,

    Here is additional question:

    Would I need an additional sql server licence if  I just want to host the virtual portal on some other server say my "webServerxx" . I can keep the report server db 's in my licenced version of SQLServer. 
    Would  the  Reporting services configuration services wizard  be available on the "webserverxx".

    Thanks,
    SQL Sniffer

  • November 16, 2017 at 12:17 pm

    #1968413

    You'll need licences for the Server that is hosting the databases (and running the data engine) AND licences for the Server that is running the Reporting Services Service. The Web Portal is part of the SSRS service, so that other Server would need to be licensed.

    So, for example, you have a single 8 Core CPU Server, which is hosting your Data Engine, SSIS and SSAS services. That's 8 licences for that server (unless you're on 2008, but let's not talk about that), as it's 1 licence per core. Now, you have another server, that's hosting your web services (your external and internal websites for example), but you also put SSRS on there. That Server also has a Single CPU with 6 cores. That's another 6 licences you'll need to buy, as you are hosting SSRS on that server.

    That comes to 6 + 8 = 14 licences in total that you'd need to purchase.

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

  • November 17, 2017 at 2:53 am

    #1968471

    Thanks Thom, Well explained.

Viewing 6 posts - 1 through 5 (of 5 total)

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