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 for DB Provider, Default database textbox will show up and a checkbox (Use WindowNT integrated security) will appear. The user can recognize that the provider name changes to SQLOLEDB.1. If you check Use WindowNT integrated security, you will access the database with window authorization instead of user name and password.