Forum Discussion

VQL95's avatar
VQL95
New Member
2 years ago

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 to add credentials. 

The connection type is analysis service through a data cube which is also on premise. 

I have gone into the gateway settings and the only authentication option is “Windows without impersonation”. 

Even after selecting this option, I am unable to save the settings. I will click save but nothing will happen. 

Is there another way to enter credentials or am I missing a step somewhere else. 

 

Thanks.

 
"Need Help"
"Power BI Report Server"

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    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.