Power Platform Community Forum Thread Details

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?

Categories:

Microsoft Dataverse with Power Apps