Configure the database connection
- Last UpdatedMar 24, 2026
- 4 minute read
Before you fetch a report, configure the database connection for the models. Only users with Admin privileges can add, edit, and delete database connections. While configuring the database connection, test it to ensure it is set up correctly.
SQL Server, MS Access, and Oracle databases are supported.
Authenticate the database connection
You can authenticate the database connection in two ways:
-
Provide a User Id and Password: The password is encrypted using the DPAPI library, allowing secure encryption without the need for a key. This means there is no need to protect the keys used for encryption. Additionally, the encryption scope is machine-specific, so the password can not be decrypted on any machine other than the one where it was originally encrypted.
-
Alternately, opt for Integrated Security: Grant the IIS App with pool identity access to the database to use integrated security. See Create SQL Logins in the AVEVA Production Accounting – Web Installation Guide for more information.
Add a database connection for SQL Server
-
Open AVEVA Production Accounting – Web.
-
Select Configurations.
-
Select Database Configuration.
The Production Accounting Configurations page appears.
-
In the Production Accounting Configurations page, select Add.
The Add New Record pop-up window appears.
-
Populate the following as required:
-
Model Name (mandatory)
-
Database Type (mandatory)
-
Server Name (mandatory)
-
Database (mandatory)
-
User Id (mandatory)
-
Password (mandatory)
-
Integrated Security (mandatory to enable Integrated Security)
-
-
Select Save.
The new connection is added.
Add a database connection for MS Access Server
For MS Access database connection, install the Microsoft Access Database Engine Redistributable installer from https://www.microsoft.com/en-us/download/details.aspx?id=54920 as a prerequisite. Depending on the version of Microsoft Office installed on your system, install either the 32-bit or 64-bit driver.
Perform the following steps to add a database connection for MS Access Server:
-
In the Production Accounting Configurations page, select Add.
The Add New Record pop-up window appears.
-
Populate the following as required:
-
Model Name (mandatory)
-
Database Type
-
Server Name (mandatory) — MDB filepath
Note: Keep the MS Access MDB file in a public folder for the server name to be accessed.
-
Database
-
User Id
-
Password
-
Integrated Security
-
-
Select Save.
The new connection is added.
Add a database connection for Oracle Server
-
In the Production Accounting Configurations page, select Add.
The Add New Record pop-up window appears.
-
Populate the following as required:
-
Model Name (mandatory)
-
Database Type
-
Server Name (mandatory)
-
Database (mandatory)
-
User Id
-
Password
-
Integrated Security
-
-
Select Save.
The new connection is added.
Edit a database connection
-
In the Production Accounting Configurations page, select a model.
-
Select Edit.
A pop-up window displaying the model details appears.
-
Edit and update the relevant information.
-
Select Save.
The connection details are updated.
Note: You cannot edit the model name. If you want to change the model name, delete the existing record and create a new connection with the desired model name.
Delete a database connection
-
In the Production Accounting Configurations page, select a model.
-
Select Delete.
The Are you sure you want to Delete Record? pop-up window appears.
-
Select OK.
The database connection is deleted.
Test a database connection
-
In the Production Accounting Configurations page, select a model.
-
Select Edit.
A pop-up window displaying the model details appears.
The password remains empty when editing the connection. If you are using SQL Server authentication, provide the password each time before testing the connection.
-
Select Test Connection.
The connection is tested and one of the following messages is displayed:
-
Connection Successfully established.
-
Login failed for user.
-
-
Select OK.