cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
bryan_0226-ag
Advocate I
Advocate I

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

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.

1 ACCEPTED SOLUTION

Accepted Solutions
bryan_0226-ag
Advocate I
Advocate I

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.

View solution in original post

4 REPLIES 4
HenryARPhillips
Continued Contributor
Continued Contributor

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

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!

HenryARPhillips
Continued Contributor
Continued Contributor

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.

bryan_0226-ag
Advocate I
Advocate I

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.

View solution in original post

Helpful resources

Announcements
PA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

secondImage

Are Your Ready?

Test your skills now with the Cloud Skill Challenge.

secondImage

Demo Extravaganza is Back!

We are excited to announce that Demo Extravaganza for 2021 has started!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

Top Solution Authors
Top Kudoed Authors
Users online (65,815)