Refreshing a BQY File in Workspace Returns Error: "Failed to acquire access to database"
(Doc ID 786714.1)
Last updated on JULY 09, 2020
Applies to:Hyperion BI+ - Version 18.104.22.168.00 and later
z*OBSOLETE: Microsoft Windows Server 2003
***Checked for relevance on 23-Apr-2013***
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: , SQL NATIVE ERROR: , 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.
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