Hi,
I am trying to connect to Azure SQL instance from OCI data integration (Web). I created a Data Asset as mentioned in this documentation: https://docs.oracle.com/en-us/iaas/data-integration/using/data-assets-create-azure-sql.htm
I set the following values:
Type: Microsoft Azure SQL Database
Host : To my host IP
Port : 1433
Database : To my database Name
In Default connection
I added my user name and password.
When I test the connection I get the below Error, I enabled network flow logs and I see bidirectional connectivity between OCI through NAT gateway to my host which is on the web. I also looked at Network path analyzer and it says I can reach the host and get replies.
Connection status: (400, BadRequest, false) DICOM_CONNECTIVITY_0067 - Error while creating connection. Possible cause: IO Error: Unknown host/port specified. (opc-request-id: csidc549cb70496cafb6e1438e2fb2bb/c4423e9b0f774b8b8ebe5b52945a1763/015AA8132758DA793A014B5A2F6A6096)
I think DI is able to reach the host but the host wants DI to connect to a specific instance on Azure not just to general port 1433. I know my instance name but there is no where to enter it. Any idea how to configure Azure instance name while setting up Azure connection?
I also tried adding the instance name to the host IP (like 127.0.0.1\INSTANCENAME) because that is how you can connect to Azure instance using SQL Management Studio and I get below error in configuring the Data Asset:
Connection status: (422, UnprocessableEntity, false) DICOM_CONNECTIVITY_0067 - Error while creating connection. Possible cause: Conflicting connection information. When the instance name is specified, it is invalid to specify the port number. (opc-request-id: csidac7b78ac43388c8b0e9796cd04f6/ee28ed81be5440b0af33e1179934165b/35E61D22F3826863DE69A5A4D1BC7C69)
Any other input on how to resolve this? Also for Azure instance you don't have to specify the port number you can just instance name but that is not being allowed by DI Data Asset configuration because port number is a required field.
Thanks,
Nachi