Skip to main content

Notifications

Community site session details

Community site session details

Session Id : ozXC1tgGmUcQ4nF8EgVkDB
Power Apps - Building Power Apps
Answered

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

Like (0) ShareShare
ReportReport
Posted on 16 Feb 2021 14:14:27 by 53

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:
  • TheFreeMan Profile Picture
    48 on 28 Feb 2024 at 15:37:53
    Re: How to update Azure SQL Server Password on connector when changed in the Azure portal?

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

  • PASINDA Profile Picture
    6 on 25 Dec 2023 at 06:35:24
    Re: How to update Azure SQL Server Password on connector when changed in the Azure portal?

    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

  • Verified answer
    bryan_0226-ag Profile Picture
    53 on 22 Feb 2021 at 17:24:26
    Re: How to update Azure SQL Server Password on connector when changed in the Azure portal?

    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.

  • Community Power Platform Member Profile Picture
    on 17 Feb 2021 at 18:28:34
    Re: How to update Azure SQL Server Password on connector when changed in the Azure portal?

    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 Profile Picture
    53 on 17 Feb 2021 at 15:14:41
    Re: How to update Azure SQL Server Password on connector when changed in the Azure portal?

    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!

  • Community Power Platform Member Profile Picture
    on 16 Feb 2021 at 23:28:31
    Re: How to update Azure SQL Server Password on connector when changed in the Azure portal?

    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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Understanding Microsoft Agents - Introductory Session

Confused about how agents work across the Microsoft ecosystem? Register today!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Congratulations to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard > Power Apps - Building Power Apps

#1
MS.Ragavendar Profile Picture

MS.Ragavendar 32

#2
Rajkumar_M Profile Picture

Rajkumar_M 16 Super User 2025 Season 1

#2
mmbr1606 Profile Picture

mmbr1606 16 Super User 2025 Season 1

Overall leaderboard
Loading started