Unable to test connection to Azure SQL Server data asset in OCI Data Integration
Summary: Created a data asset to connect to a sql server database in MS Azure. While testing the connection getting an error related to client IP not allowed to connect to Azure
Content (required): Here is the error while testing the connection 'Failed to test the default connection for the data asset AzureSQLServer . Possible cause: DICOM_CONNECTIVITY_0134 - Error while creating jdbc connection: [SQLServer]Cannot open server '****-nc-dev-sqletl01' requested by the login. Client with IP address 'xx.xx.xx.xx' is not allowed to access the server. To enable access, use the Windows Azure Management Portal or run sp_set_firewall_rule on the master database to create a firewall rule for this IP address or address range. It may take up to five minutes for this change to take effect.. Verify the connection details and try again.'