Using IBM TRIRIGA Application Platform 3.5.0 with SQL Server, it is not made clear in the installation documentation whether the Database User Account can use Windows or Domain authentication.
As a temporary fix, allow “SQL Server Authentication” and set up a relevant user account with database owner (DBO) permissions, as this is a known working configuration. The following notes will be added to the TRIRIGA installation guide “SQL Server” sections:
- Note: Only “SQL Server Authentication” is supported. “Windows Authentication” is not supported.
- Note: The SQL Server account must have “DBO permission access” to the database.
Moving forward, the installation guide has been updated by stating the requirement for “SQL Server Authentication” and the fact that the account must be the “DBO” for the database.