0

I am migrating on-prem sql to Azure SQL MI. In the migration, I need some tables from on-prem for development. I am trying to link SQL server installed in Azure VM. But I am getting error - enter image description here

I have added firewall rule to allow the traffic from SqlMI to Onprem VM.

I am also able to connect to Azure SQL MI from same Azure VM. still showing this error.

Rohi_Dev_1.0
  • 372
  • 1
  • 2
  • 19

1 Answers1

0

• Please check whether ‘Be made using this security context’ option is selected in the ‘Security’ tab while connecting to the on-premises SQL DB through the Azure VM and the correct credentials are used to login to the SQL Server instance.

Security login

Also, as you are facing a Transact-SQL exception error, please check the ‘Catalog’ option in the SQL connection whether it has the correct SQL DB name specified there or not as it should be there as below. Once, the DB has been mapped and linked, then please check the ‘RPC’ and ‘RPC Out’ options whether they are set to ‘True’ or not as below. Once, the said has been done, also, check the on-premises inbound firewall settings whether requests to access the SQL Server over port 1433 and HTTPS 443 are allowed or not for the said Azure SQL Managed Instance.: -

Catalog name of DB RPC option in OLE DB Link server

Please refer the below link for more details: -

https://www.sqlshack.com/create-linked-server-azure-sql-database/

Kartik Bhiwapurkar
  • 4,550
  • 2
  • 4
  • 9