Products | Versions |
---|---|
TIBCO iProcess Insight | - |
Not Applicable | - |
Resolution:
Description:
============
In some circumstances, when Microsoft SQL Server 2005 is used as a database, an "Authorization failure: Insufficient access privileges" error occurs when registering the database connection with TIBCO Domain.
Environment:
===========
- TIBCO iProcess™ Insight version 2.2.0 or higher
- TIBCO Runtime Agent™ (TRA) version 5.6.0 or higher
- TIBCO Administrator™ version 5.6.0 or higher
- Microsoft SQL Server 2005
Symptoms:
==========
Database connection registration aborts with Authorization failure error message.
Cause:
======
Database username and schema name not the same.
Resolution:
=========
To resolve this error, create a database schema with the same name as the database user.