You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Unable to connect to Microsoft Azure SQL Database from OIC using MS SQL Server Adapter

Accepted answer
4
Views
1
Comments
edited Apr 7, 2024 11:43AM in Integration 1 comment

Summary:

Hello Everyone, I am unable to connect to Microsoft Azure SQL Database from OIC using MS SQL Server Adapter?
Options tried:
1) to use the connectivity agent as suggested in oracle doc, but still no luck.
2) to use SSL cert in agent truststore and under OIC settings Certificates
3) to use Database name with 'CryptoProtocolVersion=TLSv1.2;' which is optional value.

The Azure SQL DB is a publicly accessible and is not within a private subnet.

Please suggest if anyone has succedded to connect or if you have any ideas…
PFB error details.

Content (please ensure you mask any confidential information):

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!