How to connect external sql server in dataflow?

(1) Share

Report

Posted on by ynaing

I would like to make a dataflow which retrieve data from external (No Azure) sql server and create records in dataverse. But I cannot connect the sql server and got error "An exception occurred: DataSource.Error: Microsoft SQL: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)"

How I tried is as follow:

All responses (2)

Answers (0)

sygc601 18 on at

Like (0)

Report

How to connect external sql server in dataflow?

Check to see if a gateway was setup.
ynaing 91 on at

Like (0)

Report

Re: How to connect external sql server in dataflow?

Hi @Syndicate_Admin

I have tested as you said. It replies success.

TcpTestSucceeded : True

But cannot connect not only from data flow but also from power automate.