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?
