I am trying to change the data source of a BIRT report (e.g. rptdesign file used by assyst Report Wizard) from our on premise database to the cloud Saas Database,
I was using Database URL “jdbc:sqlserver://W-99999-D5E:1523;databaseName=PDRPSQGCG;”
and the connection was working fine.
But now I was told to use “jdbc:sqlserver://cac-99301-axios.secondary.database.windows.net:1433;database=99301;” as an example but it fails the connection. I tried various combinations but still no success.
IFS Support was not able to help other than we were able to test the connection tot he database using SSMS so all indication points to the BIST data source to be incorrectly specified.
Does anyone have the proper info to setup the the connection?
