Relational database authentication

Each time a database is accessed, it requires authentication. As a result, Project Builder has two different authentication methods. Any password information provided here is encrypted.

The Use Windows Authentication option uses the log on credentials of the current user to access a database. This means that a user validating a document needs permission to access and modify a database, depending on the validation form.

Important If you are using Windows Authentication for a database that is accessed by the Server Batch Processing Service, ensure the service is logged on with a Windows user account rather than the default local system account. You can specify the account within the Service Configuration tool.

The "Use SQL Server Authentication" option uses an SQL Server user account to access a database. This means that the database can be modified no matter what user is validating a document.

Note If you provide authentication credentials to configure a database connection, they should be available to all users and scripts using this connection.