Forum Discussion

julsr's avatar
julsr
Icon for Continued Contributor rankContinued Contributor
2 years ago
Solved

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 ...
Need Help
Tips and Tricks
  • julsr's avatar
    julsr
    2 years ago

    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.

     

     

Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
2 years ago

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.