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

Tosin
Frequent Visitor

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. 

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 ?

 

 

Tosin
Frequent Visitor

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 .

Tosin
Frequent Visitor

@eric-cheng 

 

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

 

Thank you all for the help

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

New Ideas Forum MPA.jpg

A new place to submit your Ideas for Power Automate

Announcing a new way to share your feedback with the Power Automate Team.

MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

365 EduCon 768x460.png

Microsoft 365 EduCon

Join us for two optional days of workshops and a 3-day conference, you can choose from over 130 sessions in multiple tracks and 25 workshops.

Users online (3,635)