Configure the database connection

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. Only SQL Server 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

1. Open AVEVA Production Accounting – Web.

2. Select Configurations.

3. Select Database Configuration.

   The Production Accounting Configurations page appears.

4. In the Production Accounting Configurations page, select Add.

   

   The Add New Record pop-up window appears.

   

5. Populate the following as required:

   • Model Name (mandatory)

   • Database Type (mandatory)

   • Server Name (mandatory)

   • Database (mandatory)

   • User Id (required for SQL Server authentication)

   • Password (required for SQL Server authentication)

   • Integrated Security (required to enable Integrated Security)

6. Select Save.

   The new connection is added.

Edit a database connection

7. In the Production Accounting Configurations page, select a model.

8. Select Edit.

   

   A pop-up window displaying the model details appears.

9. Edit and update the relevant information.

   

10. 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

11. In the Production Accounting Configurations page, select a model.

12. Select Delete.

    

    The Are you sure you want to Delete Record? pop-up window appears.

    

13. Select OK.

    The database connection is deleted.

Test a database connection

14. In the Production Accounting Configurations page, select a model.

15. 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.

16. Select Test Connection.

    The connection is tested and one of the following messages is displayed:

    • Connection Successfully established.

      

    • Login failed for user 'sa'.

      

17. Select OK.