TMG SP1 SQL Report Services


  • I have a Standalone TMG (sp1) array, with 2 servers TMG1 and TMG2.
    TMG1 is "master" and on the Logs & Reports > Reporting TAB > Configure Report Settings > Report Server TAB > TMG1 is Report Server

    Now does this mean that the; SQL Server (ISARS) and SQL Reporting Services (ISARS) should only be started on TMG1 or should both services be started on both TMG servers?

    When i look on TMG2 i see that SQL Server (ISARS) and SQL Reporting Services (ISARS) services are on automatic and after a reboot are started but quickly stopped.
    Monday, September 13, 2010 9:06 AM


  • Normally on an Array only one server could be "promoted" as the Reporting server for an array.

    It's normal on the other server that the service is stopped for me.

    Follow me on Twitter http://www.twitter.com/liontux | My Blog (French/English) : http://security.sakuranohana.fr/
    • Marked as answer by dikkehaaj Monday, September 13, 2010 2:25 PM
    Monday, September 13, 2010 1:12 PM