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?

All responses (3)

Answers (1)

Verified answer

Pstork1 64,822 on at

Like (0)

Report

Re: connection issues on local SQL db

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

Like (0)

Report

Re: connection issues on local SQL db

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
Pstork1 64,822 on at

Like (0)

Report

Re: connection issues on local SQL db

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/