Notifications
Announcements
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?
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/
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
When connecting through the gateway make sure the connection account you are using has permissions to access the data.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
In our never-ending quest to improve we are simplifying the forum hierarchy…
We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
David_MA 223 Super User 2025 Season 2
Expiscornovus 205 Most Valuable Professional
harshdeol 167 Moderator