You’re offline. This is a read only version of the page.
2
Despite the plethora of information it gives you about the nature of the connection failure, I can't see this being any more straightforward. Any thoughts?
Hi @nghastings ,
If you want to create an On-Premises connection, you first need to install Gateway. Please refer to Online doc for more details:
https://docs.microsoft.com/en-us/flow/gateway-manage
Then check if the license currently subscribed to the account used by MS Flow meets the requirements.
Users with a Standalone Flow license subscription can create an On-Premises connection. For example, Flow plan1/plan2.
In addition, you need to click Connect via on-premises data gateway, then edit the parameters required here, such as SQL server name and Database name.
If the authentication type you use is Windows, UserName needs to be Domin\username.
Please try again.
Best Regards,
Yes, I'm testing it on a local environment, and definitely learned this today. Unfortunately our company created accounts with an outlook.com extension, so I don't have the requisite 'work' email necessary to install the gateway.
Since the name is SQLExpress I assume this is an instance of SQL running on your laptop or workstation. That means its on-premises and the only way that Flow will be able to connect to it is using an on-premises gateway. But you don't have that checked. Install a gateway and try again.
#1
Michael E. Gernaey
497
Super User 2025 Season 1
#2
David_MA
436
Super User 2025 Season 1
#3
Riyaz_riz11
244
Super User 2025 Season 1
Share
Report
All responses (
Answers (
