Settings for MS SQL

AVEVA Production Accounting interfaces with MS SQL database by using OLE-DB provider (Microsoft OLE DB Provider for SQL Server).

If you select MSSQL as the DB Provider, the Default database textbox and the Use WindowNT integrated security checkbox will appear. The provider name will change to SQLOLEDB.1.

If you select Use WindowNT integrated security, you will access the database with window authorization instead of your user name and password.

From 2026.1 version onwards, MS SQL security has been enhanced to support the Use Encryption for Data feature in the Data Link Properties window.

Check and update Use Encryption for Data

1. Select the Tools menu.

2. On the Tools menu, in the Tools group, select Option.

   The Option dialog appears.

3. In the Option dialog, select the File/Database tab.

4. In the DB Provider section, select MSSQL.

5. Select Build Connection String.

   The Data Link Properties window appears.

   

6. In the Data Link Properties window, select the All tab.

   By default, the property value for Use Encryption for Data is set to True.

   • If your MS SQL database is encrypted, keep the Use Encryption for Data value as True.

   • If the MS SQL database is not encrypted, select False.

7. Select the Connection tab.

8. Select Test Connection.

   

   Note: Ensure to check and update the Use Encryption for Data feature before you select Test Connection.

9. Select OK.

At present, there is no app-based restriction on a user to consume SysAdmin level connection string. However, if users connect to AVEVA Production Accounting with SysAdmin privileges, there is a chance of security, compliance, and operational risks. In order to secure the database environment, it is recommended to restrict users to a readonly role using the principle of least privilege. Alternatively, you can also configure user roles where the permission to create or delete any database object is disabled. See the following image for reference.