AVEVA Production Accounting – Web and SQL server integrated connectivity configuration

By default, AVEVA Production Accounting – Web supports SQL server authentication. SQL server authentication requires username and password as part of the connection string. The password is encrypted while saving the credentials.

You can also use windows authentication for establishing connection with the SQL database. To establish the connection, configure access to IIS user identity under which the web process is configured to run.