Skip to main content
Question

Assistance Required to Resolve Test Connection Errors in SSIS IFSCloud BI

  • November 21, 2024
  • 3 replies
  • 67 views

Forum|alt.badge.img+7

I am encountering the following errors while testing connections in SSIS during the Power BI infrastructure setup in Azure for Self-Hosted BI.

  • ORA-12170: TNS timeout occurred

I have verified that there is no issue with connecting to the IFSINFO user.

  • Connection to MSOLAP failed:

Errors in the OLE DB provider. Unable to obtain an authentication token using the credentials provided.
The script returned a failure result.

I have attached a screenshot for your reference.

Could you please help me resolve these issues? Your assistance would be greatly appreciated.

 

 

3 replies

Forum|alt.badge.img+7
  • Author
  • Sidekick (Partner)
  • 39 replies
  • November 29, 2024

The issue has been resolved by implementing the correct network rules and VNETs.


jzouaoui
Sidekick (Customer)
Forum|alt.badge.img+8
  • Sidekick (Customer)
  • 36 replies
  • March 20, 2025

Hello, 

i have the same error can you provide me the steps please to resolve this issue.

Thank you


Forum|alt.badge.img+7
  • Author
  • Sidekick (Partner)
  • 39 replies
  • March 25, 2025

Hi ​@jzouaoui If you are using a firewall or network control list, you need to whitelist or allow the Oracle port between your BI resource and the IFS Cloud database server.


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings