Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
When I try to change the data source privacy setting (tried all 4 choices) I get the following error:
MTI Data Gateway: | Invalid connection credentials. |
Underlying error code: | -2146232060 |
Underlying error message: | Login failed for user '••••••••••••'. |
DM_ErrorDetailNameCode_UnderlyingHResult: | -2146232060 |
DM_ErrorDetailNameCode_UnderlyingNativeErrorCode: | 18456 |
I am connecting to SQL Server (in an Azure VM) using basic authentication. The server is set with a cert and to force encryption.
I can connect ok with PBI Desktop as long as Encryption is off. If Encryption is turned on I get the error:
Microsoft SQL: A connection was successfully established with the server, but then an error occurred during the login process. (provider: SSL Provider, error: 0 - The received certificate has expired.)
I have installed the client cert on the gateway and desktop. I checked the client and server certs and they are both valid and not expired.
Any ideas?
Hi @RonK ,
It is because you are using the encrypted connection to connect to SQL database then causes the error.
Please refer to this similar thread to troubleshoot the issue: