Unanswered

How to update Azure SQL Server Password on connector when changed in the Azure portal?

(0) Share

Report

Posted on by bryan_0226-ag

Hi everyone,

I changed the password for my Azure SQL Server in the Azure portal but when I try to edit the connector in Powerapps Connections page I get the below error. Any assistance would be greatly appreciated! My Powerapp is unable to pull any data since I changed the password. I even tried adding a "New Connection" in the app and it still wouldn't connect.

Error is:

"Credentials are missing or not valid. inner exception: The credentials provided for the SQL source are invalid. (Source at ............)."

I've triple checked the username and password. I can log into SSMS with the credentials and no issues. When I click save to update the credentials, the dev tools Console displays a bunch of errors, so maybe its a Microsoft issue.

Any help is greatly appreciated.

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (1)

Community Power Pla... on at

Like (0)

Report

Not an answer as such, but it sounds like you are doing everything right. I am assuming you didn't change the authentication method and you are just using SQL Server Credentials. If those assumptions are correct, then it should be as simple as updating the existing connection with the new credentials, like you are trying to do so.

How did you change the password out of interest, presume you did it via the Azure Portal and not within SQL itself?

Also out of interest, does it accept the details when doing it as a new connection? As if so, you really should be able to just edit the app, add in the new connection. You will then need to probably reselect the tables against the new connection.

Another trick that might work, is to export the app. Re-Import and then select the new connection when importing.

Thanks

Henry

Was this reply helpful? Yes No
bryan_0226-ag 53 on at

Like (1)

Report

Hi thanks for the reply.
I changed the password in the Azure Portal.
It does not accept the details when doing it as a new connection.
I considered the reimporting idea. Definitely frustrating!

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Oh, so at least it is consistent in its defiance of the credentials, which would mean it is the credentials but obviously it is not because you have tried.

Do the credentials work did you say if you go to access by way of SQL Server Management Studio? Just to validate that way also?

If SSMS works, I would look to what you are entering for the server name but as you are updating I am presuming that has been left untouched.

Was this reply helpful? Yes No
Verified answer

bryan_0226-ag 53 on at

Like (1)

Report

Yes, the credential worked in SSMS. Same with checking the server name.

I ended up changing the password for the database back to the old password (in Azure portal) (I had it on hand luckily) and the data started pulling again.

Definitely an unusual bug. It could have been a glitch at the time although I'm a little nervous to try again. I'll likely give it another shot late on a weekend night when users are off and see if it was just a glitch at the time.

Was this reply helpful? Yes No
PASINDA 6 on at

Like (0)

Report

Hi All

I had the same issue , I login to https://make.powerapps.com/ and from the left side pane selected ... more >> connections >> selected the connection and update my credentials user ID and PW. it works .

thank you
Pasinda

Was this reply helpful? Yes No
TheFreeMan 48 on at

Like (0)

Report

Maybe there's been an update (downgrade?), but there's nothing in the connection reference fly-out to enter user/pwd. Looks like the only option is to delete & recreate which is a MAJOR flaw for companies that require password changes every 90 days...

Was this reply helpful? Yes No