mofawaz181's avatar
mofawaz181
Icon for Microsoft Employee rankMicrosoft Employee
5 years ago
Status:
New

"Invalid Credentials" error creating new dataflow that uses On-Premise Data Gateway and SQL Server

Here's the issue.   1. Create a new dataflow 2. Select "Add new entities" and choose SQL Server database. 3. Enter in the server and database names, corresponding to a source defined in an on-pre...
Data Modeling
Gateways
v-lili6-msft's avatar
v-lili6-msft
Icon for Community Support rankCommunity Support
5 years ago

hi  mofawaz181 

I have tested on my side, it works well.

Could you please make sure that you have configured gateway for your database and you could check if the credential is correct in your gateway and be same with the credentials in your dataflow:

 

and also try to clear the saved password, cache and cookies in your web browser and check if it works well.

 

 

Regards,

Lin

Completed Ideas