Forum Discussion
DMTS_DatasourceHasNoCredentialError - Credential Error
I am getting the following error code: Error code: DMTS_DatasourceHasNoCredentialError Connection error: Connection has no credentials I have an on-premises SQL Gate Way that I am unable t...
Hi VQL95 ,
First, ensure that you’re using a supported version of the on-premises data gateway.
Check whether the user of the SQL statement is valid,Grant permissions to users in SQL statements
You can see the Microsoft's official link:
Troubleshoot the on-premises data gateway | Microsoft Learn
Best Regards,
Xianda Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.