![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(176, 90%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDW%3C/text%3E%3C/svg%3E)
Hey! If you're getting an "Invalid SQL Credentials" error when setting up a connection in Power Automate via On-Prem Gateway, double-check that your SQL username and password are correct and that the account has access to the target database. Also, make sure you’re using Windows or SQL authentication—not mixed improperly. Keeping your environment up to date with a genuine version of Windows or SQL Server from the official Microsoft store or Microsoftprokey can help avoid these issues.
Unable to Create Connection in Power Automate Using On-Prem Gateway - Invalid SQL Credentials Error
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(16, 5%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAC%3C/text%3E%3C/svg%3E)
Alma Chang
0
Reputation points
Hi Microsoft Support Team,
I am encountering an issue of SQL connection in Power Automate. I created a connection to on-prem SQL server using on-prem gateway. Upon creation, it has no issue, it is saved successfully. However, when I ran the workflow, the error message popped up saying "Credentials are missing or not valid. inner exception: The credentials provided for the SQL source are invalid".
The other odd thing is that the connection worked for some SQL operations but not others, which doesn't seem to make sense to me as they are using the same connection.
This Get rows action with same connection worked
This Execute Stored Procedure worked on the first run in foreach item
However, it failed on the 2, 4, 6, 8, 10, 11 round in the foreach action with same connection
Moreover, I also noticed that when I tried to edit the connection and re-authenticate it, I failed to authenticate the connection due to the same issue, "Credentials are missing or not valid. inner exception: The credentials provided for the SQL source are invalid" when I can connect sql server in SSMS using the same credential.
Would appreciate your help and guidance and please let me know if you need more information from me, many thanks!
Regards,
Alma
SQL Server | Other
{count} votes
-
Erland Sommarskog 124.2K Reputation points MVP Volunteer Moderator2025-08-11T20:46:20.6133333+00:00 Maybe it is better to ask this question somewhere they know PowerAutomate? I know SQL server, but I have no idea what credentials PowerAutomate is sending.
I don't think PowerAutomate is covered here in Microsoft Q&A. I did a quick Googling and found https://community.powerplatform.com/?redirectedFrom=https://community.powerplatform.com/t5/Microsoft-Power-Automate/ct-p/MPACommunity/. That could be the place.
Sign in to comment