Refreshing a BQY File in Workspace Returns Error: "Failed to acquire access to database" (Doc ID 786714.1)

Last updated on FEBRUARY 03, 2022

Applies to:

Hyperion BI+ - Version 9.2.0.3.00 and later
z*OBSOLETE: Microsoft Windows Server 2003Symptoms

Getting the following error message when refreshing a BQY in Workspace:

"Error: Failed to acquire access to database.
SQL API: [SQLConnectW], SQL RETURN: [-1], SQL STATE: [28000], SQL NATIVE ERROR: [18452], SQL MESSAGE: [[Microsoft][ODBC SQL Server Driver][SQL Server] Login failed for user ". The user is not associated with a trusted SQL Server connection.]""

The same BQY document works fine in IR Studio.

Cause

	To view full details, sign in with your My Oracle Support account.
	Don't have a My Oracle Support account? Click to get started!

In this Document

Symptoms

Cause

Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.

Refreshing a BQY File in Workspace Returns Error: "Failed to acquire access to database" (Doc ID 786714.1)

Applies to:

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!