cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Tosin
Frequent Visitor

Power Automate error 'credentials are missing or not valid'

 

Picture1.jpg

Any ideas on why it shows Unauthorized at the top also? 

9 REPLIES 9
eric-cheng
Solution Sage
Solution Sage

Hi @Tosin ,

 

Looks to be an on premise SQL server based on server name?

 

1. Do you have a data gateway up?

2. What authentication type are you using and is it correct?

3. Does the account have the relevant access?

4. Can it connect via SQL management studio with the same credentials?

5. Is you connection in a connected state or error state?

6. Are there rules in place?

--------------------------------------------------------------------------
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

Hi Eric, 

 

Is it possible to have a skype / zoom session. we are having issues with the whole power platform system trying to switch admin privileges and fix things. I am a junior analyst and the senior left upon 2weeks of me joining. so now i am really stuck. would love to get your insights. Thank you. 

Anonymous
Not applicable

1. Yes we have a data gateway up.

2. Windows Authentication

3. Yes the account is the admin of our power platform.

4. Yes it can

5. it is in a connected state

4. It is set up as a trigger i am not too sure about rules.

Tosin
Frequent Visitor

Sorry wrong acc.

@eric-cheng 

To your questions above:

1. Yes we have a data gateway up.

2. Windows Authentication

3. Yes the account is the admin of our power platform.

4. Yes it can

5. it is in a connected state

4. It is set up as a trigger i am not too sure about rules.

rakadakaka
Helper II
Helper II

Did you try recreating the connection ?

Did you try with some other account , connecting to SQL DB ?

Do the user which you are trying has required access dbo schema , employee DB which you are trying to connect ?

 

 

I tried to recreate the connection via power automate but it didn't work. I am trying to use my account now as opposed to the original owner who left. I get an error "Some of the connections are not authorized yet. If you just created a workflow from a template, please add the authorized connections to your workflow before saving."

 

The user is an admin who left but i recovered her account and now trying to fix the flows and everything else 😞 . she has access to the entire office e5 license etc

Hi @Tosin ,

 

So the connector is working with the re-enabled account? 

 

Is the data gateway linked to the deactivated account?  Please refer to step 3 onwards here.

 

--------------------------------------------------------------------------
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

rakadakaka
Helper II
Helper II

As a best practice please do not use personal accounts for connecting to On Premise Data Gateway , DB etc. please use service accounts to connect to DB

 

Service Accounts : https://docs.microsoft.com/en-us/azure/active-directory/fundamentals/service-accounts-introduction-a...

 

This will prevent the issue if anyone leaves the Organization .

@eric-cheng 

 

Yes I re-enabled the account and that fixed the issue.

 

Thank you all for the help

Helpful resources

Announcements
Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Difinity Conference 2022

Difinity Conference 2022

Register today for two amazing days of learning, featuring intensive learning sessions across multiple tracks, led by engaging and dynamic experts.

European SharePoint Conference

European SharePoint Conference

The European SharePoint Conference returns live and in-person November 28-December 1 with 4 Microsoft Keynotes, 9 Tutorials, and 120 Sessions.

Users online (4,011)