Answered

connection issues on local SQL db

(0) Share

Report

Posted on by MeToo_

I have installed a gateway to access my local SQL db but when entering connection details I keep getting test failed. Are there any screenshots of how this should look?

Categories:

Using connectors

I have the same question (0)

All responses (3)

Answers (1)

Pstork1 68,858 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Here's a Blog on how to setup SQL to work with an on-premises gateway. Lots of screenshots.

https://flow.microsoft.com/en-us/blog/on-premises-data-gateway/

Was this reply helpful? Yes No
MeToo_ 31 on at

Like (0)

Report
Copy link

Link copied!

Found my answer to this on another blog. But I have one more question. Seems like I cannot connect to my on-premise SQL Server is that correct? I have installed the gateway on my PC and the connection is succesful but I am not getting any tables listed on my flow. And I have added the IDENTITY and ROWSOURCE column as directed

Was this reply helpful? Yes No
Verified answer

Pstork1 68,858 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

When connecting through the gateway make sure the connection account you are using has permissions to access the data.

Was this reply helpful? Yes No