Answered

Linked server connection from on premise SSMS to Read only Dynamic SQL Database https://xxx.xx.dynamics.com without third party software?

(0) Share

Report

Posted on by manojbaba100

Is it possible to create a linked server from on premise SQL instance to a read-only SQL Server database used by Data verse ( https: xxx.xx.dynamics.com) without any third-party software?

If so, can you provide some instruction?

What option do we need to select while creating linked server ?

The firewall port has already been opened in between.

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (2)

Answers (1)

timl 36,411 Super User 2025 Season 2 on at

Like (0)

Report

@manojbaba100

Unfortunately, I don't think this is possible.

In the past, I tried to create a linked server to the TDS Dataverse endpoint.

This wasn't possible because the linked server setup doesn't support AAD authentication, and unless things have changed, I imagine that this is still not possible.

Was this reply helpful? Yes No
Verified answer

manojbaba100 9 on at

Like (0)

Report

Thank you @timl for the informaiton, It was very helpful

Was this reply helpful? Yes No