cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

Credentials are missing or not valid. inner exception. credentials provided for SQL invalid

 

Hi All,

I am trying to make a connection to on premise database with windows credintials with no luck. It fails with this message.

 

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

 

I set up an SQL User and used basic and was was able to connect.

Any help for why Windows account is not working with flow

Using the same windows account I did not have any issues with SSMS on premise.

the Windows account was used to create the database,  add the table and the SQL user that works with flow .

 

thanks

 

Mark.

 

1 ACCEPTED SOLUTION

Accepted Solutions
Anonymous
Not applicable

it was and I put it down to a learning experience of stuff running on the Power Bi service and connecting with your on-premise gateway

it takes a while to get it's s**t together as it eventually worked the next day.

 

Same user and password connecting to the same server.

View solution in original post

11 REPLIES 11
v-yamao-msft
Community Support
Community Support

Hi MarkMc,

 

It seems that you are not providing the correct credentials.

 

When creating the connection to SQL Server On-Premise, you will be asked to type or paste the server name, the database name, the user name, and the password for the database that you want to use, and specify the authentication type and the gateway.

 

I am using Windows authentication type on my side, I can create the connection successfully.

 

Please take this doc for a reference and try again on your side:
https://powerapps.microsoft.com/en-us/tutorials/connection-azure-sqldatabase/

 

Best regards,
Mabel Mao

Community Support Team _ Mabel Mao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Anonymous
Not applicable

the creditials are correct this is not a solution

 

Anonymous
Not applicable

was this ever resolved? i am experiencing the same issues.

Anonymous
Not applicable

it was and I put it down to a learning experience of stuff running on the Power Bi service and connecting with your on-premise gateway

it takes a while to get it's s**t together as it eventually worked the next day.

 

Same user and password connecting to the same server.

View solution in original post

I am getting the same error with the Basic authentication and can 100%, positively verify that the credentials are correct as I set up the SQL login and user myself and verified that it through SSMS.

marcoselias
Advocate I
Advocate I

I know your issue eventually got fixed by itself but I was having the same or similar issue and below is how I fixed it in case this helps someone else:

 

1. Go to the connections menu

2. On your connection, click on the ellipsis menu and select 'Edit'

3. Review and update the information there. You may need to scroll down a little to see the login/password input boxes.

My issue has not been resolved. The Gateway keeps failing to log-in to the database, even though the same credentials can be used to connect successfully through SSMS.

I was able to fix this by adding the domain before my username.  Go into Data\Connections, find your connector and edit, add your domain\user and pass.  Make sure the on-premise-gateway that you select has the right user/pass under services too.

NikitaDeshwal
New Member

Credentials are missing or not valid.
inner exception: The credentials provided for the SQL source are invalid. (Source at laptop-pop1bchs;master.)
clientRequestId: 20558ffe-7bab-493a-80bd-99330be47dde
Facing the above error while connecting to SQL Server even if the credentials are correct. And can connect to SSMS with the same credentials.

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

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

Power Apps June 2021

June Power Apps Community Call

Don't miss the call this month on June 16th - 8a PDT

Top Solution Authors
Top Kudoed Authors
Users online (79,764)