Skip to main content

Notifications

Power Automate - Using Connectors
Answered

Power Automate gateway to SQL - Credentials are missing or not valid

(0) ShareShare
ReportReport
Posted on by

Hi,

We have installed a data gateway in a SQL server.

However, when I try to login with credentials (that works in the server using SSMS) it shows me

Credentials are missing or not valid. inner exception: The credentials provided for the SQL source are invalid

 

Are there any extra steps need to be done in the SQL server t allow connections from Power Automate? (as opening ports?)

Screenshot 2021-10-04 113502.png

 

  • Verified answer
    eric-cheng Profile Picture
    eric-cheng 5,171 on at
    Re: Power Automate gateway to SQL - Credentials are missing or not valid

    Hi @Jorge ,

     

    So I did a bit of testing against my on prem SQL.

     

    1. I had to specify the domain in my SQL server e.g. servername.xxxx.com.au.  Not sure if this is specific to my network.

     

    2.  Database name was case sensitive.  I had a capital as the first character and it threw the same error.

     

    --------------------------------------------------------------------------
    If I have answered your question, please mark my post as a solution
    If you have found my response helpful, please give it a thumbs up

    Connect on LinkedIn

  • Jorge_ Profile Picture
    Jorge_ on at
    Re: Power Automate gateway to SQL - Credentials are missing or not valid

    Hi Eric, thanks for your reply.

    I'm using SQL Auth, as I do use in SSMS in the server.

    LO-ROPO\MTR is the server name If I remove any of two parts, I get following:

     

    • Firewall exception is not created automatically? How do I know which port uses Power Automate to access SQL on-prem?

    Thanks

    Screenshot 2021-10-05 090754.png

     

     

  • eric-cheng Profile Picture
    eric-cheng 5,171 on at
    Re: Power Automate gateway to SQL - Credentials are missing or not valid

    Hi @Jorge ,

     

    Can you try / test / clarify the below:

     

    1. Ensure the correct Authentication Type is used i.e. AAD, SQL Auth, Windows Auth

    2. Is MTR the username or servername?

    3. If servername, can you try removing the LO-ROPO\

     

    Also, please check the usual checklist:

     

    1. Please make sure your database engine is configured to accept remote connections.
    2. Please make sure that you create an exception on the firewall for the SQL Server instance and port you are using.
    3. Please check if your SQL server services is up and running properly.
    4. Please make sure that you enable TCP/IP in SQL Server Configuration

     

    --------------------------------------------------------------------------
    If I have answered your question, please mark my post as a solution
    If you have found my response helpful, please give it a thumbs up

    Connect on LinkedIn

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

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,666

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,996

Leaderboard

Featured topics