Forum Discussion
Use SQL server connection not working
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?
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.
3 Replies
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.
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.
Please refer to this old thread : https://community.fabric.microsoft.com/t5/Power-Query/Certifiticate-problem-w-enterprise-gateway-import-mode-when/td-p/24611
