Set up Microsoft SQL Server to use client authentication.
- Ensure that the system DSN uses Windows NT authentication
and not SQL Server authentication. Or, create a new system DSN using
Windows NT authentication.
- Ensure that the database administrator user exists in the
Microsoft SQL Server Enterprise Manager. Grant at least public and db_owner database
access to the administrator for each product database. Set the default
database to the entity database.
- Ensure you have the Type-1 ODBC Bridge JDBC driver.
- Create a database user (non-operating system) who has access
to the entity database.
- Enable trusted authentication when installing the product. Use the database user (non-operating system) when asked for
database credentials in the product installer.