You’re offline. This is a read only version of the page.
Announcements
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?
Share
Report
All responses (
Answers (
721
