Use SQL server connection not working

[julsr]

Hello Everyone!

I'm trying to connect to my SQL server database using the same connection that I have on SQL Server Management Studio, but the following error appears:

It's the first time this has happened to me, and I've tried other solutions I found on the forum to get the FDQN, but nothing works. Does anyone have suggestions about this?

[julsr · Accepted solution]

Thank you both @Greg_Deckler  and @AmiraBedh . I solved it by adding the variable PBI_SQL_TRUSTED_SERVERS and my servers into my environment variables and restarting the environment.

[AmiraBedh]

Please refer to this old thread : https://community.fabric.microsoft.com/t5/Power-Query/Certifiticate-problem-w-enterprise-gateway-imp...

[Greg_Deckler]

@julsr This generally happens when your certificate for the server has the FQDN name of the server but you supplied the NETBIOS name for the server. Since the server name doesn't match the certificate name, the certificate cannot be used to encrypt the connection. You can continue with an unencrypted connection or try specifying the FQDN of the server instead. Go review your certificat for the server and find out what name is used.