Authentication

We recommend using Windows Authentication as the authentication mode for SQL Server as per the recommendation from Microsoft. Windows Authentication uses Kerberos security protocol, provides password policy enforcement with regard to complexity validation for strong passwords, provides support for account lockout, and supports password expiration.

By using Windows Authentication, Windows groups can be created at the domain level, and a login can be created on SQL Server for the entire group. Managing access from at the domain level can simplify account administration.

For more information, refer to Types of authentication in AVEVA Production Management in the Administrator (Studio) online help.