LinkedSeve on-permise to azure SQL Database

Gupta, Ajay 1 Reputation point
2022-10-25T14:25:05.07+00:00

team

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'

Thansk
Ajay

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
    2022-10-25T21:38:49.297+00:00

    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