locked
did I understand Management and Reporting DBs and services separation correctly? RRS feed

  • Question

  • please confirm that I understood correctly Management and Reporting DBs and Services separation.

    EDIT: Sorry I removed my "understanding" :) here because it was confusing...

    see please my reply to Tim.


    • Edited by pob579 Monday, June 9, 2014 2:45 AM
    Saturday, June 7, 2014 9:08 PM

Answers

  • The description of that article asumes that all components are installed on the same box.

    For a 'distributed' environment, first run the setup wizard on your SQL server machine, let it create the Management and Reporting databse

    Then, run the setup wizard on your App-V Server and point to the the remote DB. Note that the App-V installation wizard does not in any way install a SQL server, it justs creates databases.


    Falko

    Twitter @kirk_tn   |   Blog kirxblog   |   Web kirx.org   |   Fireside appvbook.com

    • Marked as answer by pob579 Tuesday, June 10, 2014 6:05 PM
    Tuesday, June 10, 2014 11:18 AM
    Moderator

All replies

  • Yes, for a pilot test.

    But best practice for production tends to be to keep the DB on a separate machine.


    Tim Mangan MVP for App-V and Citrix CTP Author of AppV books: "The Client Book" and "OSD Reference Book" (http://www.tmurgent.com/Books )

    Sunday, June 8, 2014 3:53 PM
    Moderator
  • Tim,

    my goal is to have a dedicated SQL server and an other server for Management and Reporting Services.

    And after looking again into the guide (http://blog.itvce.com/?p=4158) that looks absolutely clear I messed up with one thing. The Paragraph #1 shows deployment of Standalone SQL. Server. Then I thought that paragraph #2 shows installation of Management and Reporting services on a separate machine.

    But closely looking at screen shots it actually uses the same SQL server. Because there for DB installation "USE THIS LOCAL COMPUTER" is selected.

    I guess that "USE A REMOTE COMPUTER" should be used for deploying a DB on a previously installed standalone SQL server.

    Please see the attached pic from the instruction or to the link to clarify if I finally got it right this time.


    "When you hit a wrong note it's the next note that makes it good or bad". Miles Davis


    • Edited by pob579 Sunday, June 8, 2014 4:34 PM
    Sunday, June 8, 2014 4:33 PM
  • The description of that article asumes that all components are installed on the same box.

    For a 'distributed' environment, first run the setup wizard on your SQL server machine, let it create the Management and Reporting databse

    Then, run the setup wizard on your App-V Server and point to the the remote DB. Note that the App-V installation wizard does not in any way install a SQL server, it justs creates databases.


    Falko

    Twitter @kirk_tn   |   Blog kirxblog   |   Web kirx.org   |   Fireside appvbook.com

    • Marked as answer by pob579 Tuesday, June 10, 2014 6:05 PM
    Tuesday, June 10, 2014 11:18 AM
    Moderator
  • Thanks Falko!

    "When you hit a wrong note it's the next note that makes it good or bad". Miles Davis

    Tuesday, June 10, 2014 6:06 PM