Server Prerequisites

Gizmo Server is supported in offline mode (without Internet connectivity).

  • Windows Server 2019 recommended (Minimum OS - Windows Server 2016)

  • Minimum RAM - 8 GB (16 GB recommended if Power BI Desktop will import data from that server)

  • 4 Processors Minimum

  • 150 GB Drive Minimum

  • Windows Features enabled

  • Internet Information Server (IIS)

    • WebSocket Protocol enabled

    • IIS .Net Core Runtime 3.1 Module (Hosting Bundle)

    • IIS URL Rewrite Module

    • IIS Application Request Routing Module

  • .Net Framework 4.6.2 Full Minimum

  • Ports (inbound) TCP 5672, 80 & 443 (for HTTPS a valid certificate is required)

  • Local administrator account

  • PowerShell x86 and x64, set execution policy to RemoteSigned

Web Application

  • Full HD Screen resolution recommended (1920*1080)

  • Single Sign-On (SSO)

    • HTTPS must be enabled

    • Enterprise Azure Active Directory accounts for each user

    • Security Token Service must be accessible (https://sts.windows.net/{tenant-id})

    • Azure Sign in page must be reachable (https://login.microsoftonline.com/{tenant-id})

    • The FQDN or the host name URL submitted to GSX

  • Role-Based Access Control (RBAC)

    • Single Sign-On (SSO) must be enabled

    • The access to Directory.Read.All must be grant by an AAD admin for all users

    • MS graph API must be accessible to retrieve groups (https://graph.microsoft.com/v1.0/me/transitiveMemberOf/)

    • AAD Group “GizmoAdmins“ with users inside than can administrate the web application

SQL

The SQL Database must not be collocated on the Gizmo server, at the exception of “Proof of Value”.

  • SQL 2017 or 2019 Database - Standard, Enterprise or Azure SQL

  • User with db_owner access to create tables

  • SQL Authentication and Windows authentication supported

  • Connection access to SQL database (port 1433 by default)

  • Optional, but suggested: SQL Management software, such as Azure Data Studio, or SSMS

Search