cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Super User III
Super User III

Error on Azure SQL Connection

I am having issues on my Sql connection, I get error message:

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

clientRequestId: 209425c1-07f9-4826-ab56-d3e77cf4516e

 

Session ID: 5287f4b2-325a-4928-9e9f-6dd886967010

 

The tables connected to the Forms don’t show any error, however Galleries and dropdowns gives the error above (I think those retrieving data gives the error).

1 ACCEPTED SOLUTION

Accepted Solutions
Super User III
Super User III

@eka24 

I'm guessing that because you have gallery, forms, and dropdowns connected to your datasource, it used to work, but is no longer working now?

If you refresh the data source, does that make a difference?

If you create a new app, are you able to connect to the datasource without error?

View solution in original post

5 REPLIES 5
Super User III
Super User III

Hi @eka24 

This might be an obvious question, but have you definitely entered a correct username and password? 

>>Credentials are missing or not valid

To diagnose this further, are you able to log into your database using SQL Management Studio using your same credentials?

 

Super User III
Super User III

Yes am able to login using the username and password in both management studio and azure Portal. 

Powerapps forms with the Datasource do not show errors. But Gallery and dropdown

Thanks

 

Super User III
Super User III

@eka24 

I'm guessing that because you have gallery, forms, and dropdowns connected to your datasource, it used to work, but is no longer working now?

If you refresh the data source, does that make a difference?

If you create a new app, are you able to connect to the datasource without error?

View solution in original post

Super User III
Super User III

Thanks @timl

I created a new App and it worked. Will go back to the old one and reconnect.

Super User III
Super User III

You're welcome @eka24! Glad you got this to work.

Helpful resources

Announcements
New Badges

New Solution Badges!

Check out our new profile badges recognizing authored solutions!

New Power Super Users

Congratulations!

We are excited to announce the Power Apps Super Users!

Power Apps Community Call

Power Apps Community Call: February

Did you miss the call? Check out the Power Apps Community Call here.

Top Solution Authors
Top Kudoed Authors
Users online (93,376)