I read a lot about loading service certificate and/or setting "TrustServerCertificate" to true. However, in our case (and it sounds more cases are like this) from one day to another the user (and only "one user") was not able to connect to SQL Server from power BI anymore. Nothing ...
Once set the True (or False) the ";Trust Server Certificate=True" is append to the Connection String. Now choose EF Power Tools - Edit and an error appears in the output: System.ArgumentException: Keyword not supported: 'trust server certificate'. at NameValuePair System.Data.Common.Db...
Not all data providers or database systems support this option. If you're working with a database system that doesn't support this option, you'll need to remove theTrustServerCertificate=Truepart from your connection string. Best Regards. ...
In the CN name I´ve put the name of my Server (CN="DEVSERVER", it´s not part of a domain) and, in the application, I´ve set TrustServerCertificate=true in the connection string so everything goes right.But, when I try to connect with an ecnrypted connection from the SQL...