Blog Post

Azure Database Support Blog
1 MIN READ

Lesson Learned #129:Using Data Source External from Azure SQL Database to Azure SQL Managed Instance

Jose_Manuel_Jurado's avatar
Jose_Manuel_Jurado
Icon for Microsoft rankMicrosoft
Jun 05, 2020
Today, I worked on a service request that our customer asked about how to connect from Azure SQL Database to Azure SQL Managed Instance.    Well, the first thing that I did is to enable the Publi...
Updated Mar 06, 2023
Version 6.0
LateNightDBA's avatar
LateNightDBA
Copper Contributor
Nov 25, 2020

This works well, for a single site Managed Instance. What I have is a geo-located cluster and would like to ensure the requests coming from the Azure SQL are directed to the read only secondary cluster.

I have tried various things within the CREATE EXTERNAL DATA SOURCE STATEMENT.

Examples: CONNECTION_OPTIONS = 'ApplicationIntent=ReadOnly'

Alternative adderess directly to the READ-ONLY LISTENER : tcp:XXXXXXX.secondary.ZZZZZZZ.database.windows.net,3342

 

Niether of these have been successful to date.

WorkAround is to reference the Secondary server instance directly.