Please ensure Javascript is enabled for purposes of website accessibility
Powered by Zoomin Software. For more details please contactZoomin

AVEVA™ Manufacturing Execution System 2023 R2

Add BI Gateway database access for SQL Server 2019 or later

Add BI Gateway database access for SQL Server 2019 or later

  • Last UpdatedDec 03, 2024
  • 1 minute read

When using SQL Server 2019 or later for the BI Gateway database and the MES BI Gateway reports are being deployed on a different node than SQL Server, user access to the BI Gateway datastore database must be configured. This can be performed by doing one of the following:

  • Creating a SQL Server login for the NT Authority\Anonymous Logon Windows account and granting that login read access to the BI Gateway datastore database, as shown below.

    Login properties dialog showing how to create a SQL Server login for the NT Authority\Anonymous Logon Windows account.

  • Creating SQL Server logins for individual users and granting those logins read access to the BI Gateway datastore database.

TitleResults for “How to create a CRG?”Also Available in