DX Unified Infrastructure Management

 View Only
  • 1.  Default users in SQL DB of UIM

    Posted Oct 10, 2019 06:30 AM
    Hi Team,

    In on-prem UIM installation we are going to use MS SQL DB. Could you let me know how many users will be connected to DB once UIM server installation is over. We know at least one user will be connected which will be provided to create the database during primary hub installation. So its the  only user that will be connected to MS SQL DB or any other internal user will be connected to DB.

    Thanks
    Kamal Rath


  • 2.  RE: Default users in SQL DB of UIM

    Broadcom Employee
    Posted Oct 10, 2019 08:16 AM
    all of the connections out of the box pull the connection string from the data_engine.
    This one user is used for all connections.
    There will be multiple probes making connections but only the one user.

    ------------------------------
    Gene Howard
    Principal Support Engineer
    Broadcom
    ------------------------------



  • 3.  RE: Default users in SQL DB of UIM

    Posted Oct 11, 2019 03:17 AM
    Hi Gene,

    Thank you for the udpate. One quick query. If I have 500 servers under UIM monitoring, as the probes will make connections, the user count will be 1 or equivalent to server count.
    Please confirm, bit confused here.

    Thanks
    Kamal Rath


  • 4.  RE: Default users in SQL DB of UIM
    Best Answer

    Broadcom Employee
    Posted Oct 11, 2019 08:00 AM
    the servers under monitoring to not connect to the back end database.
    these have robots on them which collect information and send them to the primary hub.
    the primary hub is the only server that will insert information into the back end database.
    Please review the UIM reference architecture.
    http://techdocs.broadcom.com/content/dam/broadcom/techdocs/us/en/assets/docops/uim902/ca_uim_reference_architecture.pdf

    ------------------------------
    Gene Howard
    Principal Support Engineer
    Broadcom
    ------------------------------