LinkedSeve on-permise to azure SQL Database

Gupta, Ajay 1 Reputation point


We have on -premise SQL DB and want to connect Azure Sql Dtabase . used OLEDb driver 19 but every time getting error.
Want to user 'ActiveDirectoryIntegrated'


SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,106 questions
{count} votes

1 answer

Sort by: Most helpful
  1. Erland Sommarskog 103.9K Reputation points MVP

    How have you set up the linked server?

    What error message do you get?

    Although, I have a feeling that this will never work in SQL 2019. They have some glue for this in SQL 2022, I believe.

    0 comments No comments