Hi,
I am performing the migration from oracle on premises to the azure sql database.
Scenario-1
Oracle- Connected to Self Hosted Integration Runtime
Azure sql database-Connected to Azure Managed Virtual Network Integration runtime
Firewall port open from the ADF SHIR virtual machine to the Azure sql server.
Migration happens successfully.
Question-1-Scenario-2
Oracle- Connected to Self Hosted Integration Runtime
Azure sql database-Connected to Azure Managed Virtual Network Integration runtime
Firewall port open NOT OPEN from the ADF SHIR virtual machine to the other Azure sql server.
Migration does not happens.
It is due to firewall request issues or some other issues.
With oracle on prem connected to the ADFSHIR and Azure sql database connected to Azure Managed Virtual Network Integration runtime can i do the data migration or the above firewall request from ADF SHIR VM to the azure sql server database is necessary ?
While individually i am able to connect to the azure sql database and deploy the scripts using the script activity.
Error Message-ErrorCode=SqlFailedToConnect,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=Cannot connect to SQL Database. Please contact SQL server team for further support. Server: '', Database: '', User: '*'.**
Check the linked service configuration is correct, and make sure the SQL Database firewall allows the integration runtime to access.
Source=Microsoft.DataTransfer.ClientLibrary,''Type=System.Data.SqlClient.SqlException,Message=A network-related or instance-specific error
occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is
correct and that SQL Server is configured to allow remote connections. (provider: TCP Provider, error: 0 - A connection attempt failed because
the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to
respond.),Source=.Net SqlClient Data Provider,SqlErrorNumber=10060,Class=20,ErrorCode=-2146232060,State=0,Errors=[{Class=20,Number=10060,
State=0,Message=A network-related or instance-specific error occurred while establishing a connection to SQL Server.
The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured
to allow remote connections. (provider: TCP Provider, error: 0 - A connection attempt failed because the connected party did
not properly respond after a period of time, or established connection failed because connected host has failed to respond.),},],''
Type=System.ComponentModel.Win32Exception,Message=A connection attempt failed because the connected party did not properly
respond after a period of time, or established connection failed because connected host has failed to respond,Source=,'