An error message was seen when registering a database connection with TIBCO Domain: Authorization failure: Insufficient access privileges.

An error message was seen when registering a database connection with TIBCO Domain: Authorization failure: Insufficient access privileges.

book

Article ID: KB0085818

calendar_today

Updated On:

Products Versions
TIBCO iProcess Insight -
Not Applicable -

Description

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.

Issue/Introduction

An error message was seen when registering a database connection with TIBCO Domain: Authorization failure: Insufficient access privileges.