Thank you for supporting the Cloud Customer Connect Community in 2024. It's a gift to work with you!

Look back
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 test connection to Azure SQL Server data asset in OCI Data Integration

in Data Integration 1 comment

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.'

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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