Skip to main content
Solved

Support need to Resolve Test Connection empty in SSIS IFSCloud BI

  • March 13, 2026
  • 8 replies
  • 30 views

Forum|alt.badge.img+3

I am facing errors while testing connections in SSIS during the Power BI infrastructure setup in Azure for self-hosted BI. It shows empty once the test connection is completed.

 

Best answer by subashfestus

Hi,

I suspect this due to a access/connection issue. To identify the issue need more info. Can you check the SSIS execution logs as below?

  1. Connect to the SQL server
  2. Go to Integration Service Catalogs
  3. Select the catalog folder configured in the setup
  4. Get the “All Executions” report for the ConnectionTest.dtsx package

8 replies

Forum|alt.badge.img+7
  • Hero (Employee)
  • March 16, 2026

Hi ​@mihiran 
Were you able to run the “Setup Environment” assistant all the steps successfully before running the “Test Connections”?


Forum|alt.badge.img+3
  • Author
  • Do Gooder (Partner)
  • March 16, 2026

Hi ​@subashfestus 

Yes, I have done the Setup Environment
 

 


Forum|alt.badge.img+7
  • Hero (Employee)
  • March 16, 2026

Hi ​@mihiran https://docs.ifs.com/techdocs/25r2/050_reporting/010_analytics/010_analysis_models/000_am_tabular/000_biinfrasetup/#deployment_scenarios
As per the deployment scenarios mentioned in the document, what is your scenario?
Where is the IFS application and SQL server hosted?


Forum|alt.badge.img+3
  • Author
  • Do Gooder (Partner)
  • March 16, 2026

@subashfestus 
Scenario 1


Forum|alt.badge.img+3
  • Author
  • Do Gooder (Partner)
  • March 16, 2026

@subashfestus 
Scenario 1 and hosted on on-prem server


Forum|alt.badge.img+7
  • Hero (Employee)
  • Answer
  • March 16, 2026

Hi,

I suspect this due to a access/connection issue. To identify the issue need more info. Can you check the SSIS execution logs as below?

  1. Connect to the SQL server
  2. Go to Integration Service Catalogs
  3. Select the catalog folder configured in the setup
  4. Get the “All Executions” report for the ConnectionTest.dtsx package

Forum|alt.badge.img+3
  • Author
  • Do Gooder (Partner)
  • March 16, 2026

@subashfestus 
I have checked that there is errors
 

 


Forum|alt.badge.img+3
  • Author
  • Do Gooder (Partner)
  • March 17, 2026

@subashfestus 
Do you have idea about this