Skip to main content
Solved

Support need to Resolve Test Connection empty in SSIS IFSCloud BI

  • Mar 13, 2026 9:40 PM UTC
  • 8 replies
  • 81 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
View original

8 replies

Forum|alt.badge.img+7
  • Hero (Employee)
  • Mar 16, 2026 2:19 AM UTC

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
  • Sidekick (Partner)
  • Mar 16, 2026 10:21 AM UTC

Hi ​@subashfestus 

Yes, I have done the Setup Environment
 

 


Forum|alt.badge.img+7
  • Hero (Employee)
  • Mar 16, 2026 10:26 AM UTC

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
  • Sidekick (Partner)
  • Mar 16, 2026 10:51 AM UTC

​@subashfestus 
Scenario 1


Forum|alt.badge.img+3
  • Author
  • Sidekick (Partner)
  • Mar 16, 2026 11:03 AM UTC

​@subashfestus 
Scenario 1 and hosted on on-prem server


Forum|alt.badge.img+7
  • Hero (Employee)
  • Answer
  • Mar 16, 2026 11:42 AM UTC

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
  • Sidekick (Partner)
  • Mar 16, 2026 12:35 PM UTC

​@subashfestus 
I have checked that there is errors
 

 


Forum|alt.badge.img+3
  • Author
  • Sidekick (Partner)
  • Mar 17, 2026 9:58 AM UTC

​@subashfestus 
Do you have idea about this