"Invalid connection credentials" when setting up auto refresh from gateway

[rsant]

Hello,

Published reports are receiving this error when updating when they are connected to our gateway. Even manual updates give us this error. We have a gateway set up which has rights to the servers on the report which we are automating updates on. However, we receive the error: 

"Invalid connection credentials."

Here is the gateway's connection to the server:

Has anyone else experienced this issue? Thanks.

[FarhanAhmed]

Try to check your data source is mapped to a valid Connection.

You can view it by going to "Schedule Refresh" of the dataset

- Expand "Gateway Connection"

- Under it you will see data sources that are being used by your data set and they are mapped with Gateway data source. Check if they are mapped correctly

[v-deddai1-msft]

Hi @rsant ,

What's the detailed error message? Would you please check if the windows account have enough permission on sql server? Would you please try to use administrator account for instead?

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Best Regards,

Dedmon Dai

[lbendlin]

Needs more details. Where are you receiving that error message?  During scheduled refreshes?