web
You’re offline. This is a read only version of the page.
close
Skip to main content
News and Announcements icon
Community site session details

Community site session details

Session Id : /uQSBWY7DTf5s3xfm7c4JI
Power Platform Community / Forums / Power Automate - Using Connectors / Won't connect to SQL
Power Automate - Using Connectors
Unanswered

Won't connect to SQL

Like (0) ShareShare
ReportReport
Posted on 27 Sep 2019 16:32:53 by nghastings 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?

 

 

connect_error.png

I have the same question (0)
  • v-bacao-msft Profile Picture
    v-bacao-msft on 30 Sep 2019 at 04:25:16
    Re: Won't connect to SQL

     

    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,

  • Pstork1 Profile Picture
    Pstork1 67,489 Most Valuable Professional on 28 Sep 2019 at 01:57:25
    Re: Won't connect to SQL

    Are you using the Outlook.com address for Access to Flow?  If so you probably wouldn't have the premium license required to install a gateway anyway.

  • nghastings Profile Picture
    nghastings 2 on 27 Sep 2019 at 21:24:22
    Re: Won't connect to SQL

    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.

  • Pstork1 Profile Picture
    Pstork1 67,489 Most Valuable Professional on 27 Sep 2019 at 17:08:24
    Re: Won't connect to SQL

    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.

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.

Helpful resources

News and Announcements

Welcome to the Power Platform Communities
Announcing our 2025 Season 2 Super Users!
Responsible AI policies for the Community

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Telen Wang – Community Spotlight

We are honored to recognize Telen Wang as our August 2025 Community…

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Tomac Profile Picture

Tomac 986 Moderator

#2
stampcoin Profile Picture

stampcoin 699 Super User 2025 Season 2

#3
Riyaz_riz11 Profile Picture

Riyaz_riz11 577 Super User 2025 Season 2

Last month Overall leaderboard

Featured topics

Product updates

Microsoft Power Platform Community release plans