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

All responses (2)

Answers (1)

Verified answer

manojbaba100 9 on at

Like (0)

Report

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

Thank you @timl for the informaiton, It was very helpful
timl 35,103 Super User 2025 Season 1 on at

Like (0)

Report

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

@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.