Showing results for 
Search instead for 
Did you mean: 
New Member

Dataverse SQL data connection, stored procedure and Linked Servers

I'd like to create a stored procedure in my on-prem db in SSMS and use that to pull data from our Dataverse instance SQL connection into our on-prem tables.


I can connect directly to our Dataverse instance from SSMS using the SQL connection just fine.

I tried to setup a link server connection in an on-prem DB but get following error:

"TITLE: Microsoft SQL Server Management Studio Failed to retrieve data for this request. (Microsoft.SqlServer.Management.Sdk.Sfc)

ADDITIONAL INFORMATION: An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo) Named Pipes Provider: Could not open a connection to SQL Server [53]. (Microsoft SQL Server, Error: 53) ".  


Is it possible to create a linked server using the Dataverse SQL connection?  



Helpful resources

UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Users online (3,086)