Skip to main content
Solved

Assistance Required to Resolve Test Connection Errors in SSIS IFSCloud BI

  • November 21, 2024
  • 3 replies
  • 94 views
maheshmuz
Hero (Partner)
Forum|alt.badge.img+9

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.

 

 

Best answer by maheshmuz

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

3 replies

maheshmuz
Hero (Partner)
Forum|alt.badge.img+9
  • maheshmuz
  • Author
  • Hero (Partner)
  • 105 replies
  • Answer
  • November 29, 2024

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

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

Hello, 

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

Thank you

maheshmuz
Hero (Partner)
Forum|alt.badge.img+9
  • maheshmuz
  • Author
  • Hero (Partner)
  • 105 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.


Terms & ConditionsCookie settingsAccessibility statement