cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Bill_Hand
Level 8

Connect to Azure SQL

Trying to connect to an Azure SQL database but keep getting this error:

 

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

 

I know the credentials are correct because I can connect via SSMS.  Any ideas what is causing this error?

 

Thanks

1 ACCEPTED SOLUTION

Accepted Solutions
Bill_Hand
Level 8

Re: Connect to Azure SQL

I think the issue seemed to be related to the @ symbol in the password.  I changed the password and was able to connect via PowerApps.  It's funny because it didn't affect SSMS.

 

 

4 REPLIES 4
Community Support Team
Community Support Team

Re: Connect to Azure SQL

Hi @Bill_Hand ,

Could you please share a bit more about the error message within your app?

 

Based on the error message that you mentioned, it seems to tell that there is something issue with the Azure SQL Connection you created in your app.

 

Please check if the Azure SQL connection you created within your app is invalid. Please consider re-create a new connection to your Azure SQL Server from your app with your proper credentials, then try it again, check if the issue is solved.

 

Also please consider clear cache of your browser, then sign in your PowerApps again, check if the issue is fixed.

 

More details about creating a connection to Azure SQL Table, please check the following article:

https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/connections/connection-azure-sqldatabas...

 

Best regards,

Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Bill_Hand
Level 8

Re: Connect to Azure SQL

I did follow the instructions in that article and I can connect to the Azure SQL database with the provided credentials using SSMS.  However in PowerApps, I get this error:

 

Credentials are missing or not valid.

inner exception: The credentials provided for the SQL source are invalid.

 

I am connecting using SQL credentials:

SERVER: servername.database.windows.net

DATABASE: databasename

USERNAME: sqluser

PASSWORD: samepassword that worked for ssms

 

Not sure what i am doing wrong.

 

Thanks

 

Community Support Team
Community Support Team

Re: Connect to Azure SQL

Hi @Bill_Hand ,

Currently, I could not reproduce your issue on my side. Please check if you have typed a proper Server Name (which obtained from your Azure SQL Database instance) when you created a connection to your Azure SQL Database.

 

More details about creating a connection to Azure SQL Server from PowerApps, please check the following video or blog:

https://youtu.be/CO6xfbjnYwc

 

https://baizini-it.com/blog/index.php/2017/09/26/powerapps-and-azure-sql-database-101/

 

If the issue still exists, please consider remove your Azure SQL Database instance from your Azure portal, then re-create a new one based on this article. Then create a connection to your new Azure SQL Database from your app, check if the issue is solved.

 

If the issue still exists, please consider submit an assisted support ticket for further help through the following link:

https://powerapps.microsoft.com/en-us/support/pro

 

Best regards,

Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Bill_Hand
Level 8

Re: Connect to Azure SQL

I think the issue seemed to be related to the @ symbol in the password.  I changed the password and was able to connect via PowerApps.  It's funny because it didn't affect SSMS.