cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
apetty2
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?  

 

0 REPLIES 0

Helpful resources

Announcements
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)