Keyword not supported: 'trust server certificate'

[cakeezer]

System Information (please complete the following information):

• Model Builder or CLI Version: 3.0.0
• Visual Studio Version (if applicable): 2022 17.9.4

Describe the bug

• On which page of the tutorial did you run into an issue (URL): Data - Connect to SQL Server
• Clear description of the problem: After selecting a SQL server in the dropdown, we use Windows Auth and Trusted Certs. Enabling Trusted Certs causes this error to be thrown.

To Reproduce
Steps to reproduce the behavior:

1. Go to Add Machine Learning from right clicking project
2. Pick your scenario
3. Pick your Environment
4. On the Data selection page, select SQL Server, then Choose your data source
5. Select your data source, and click the Trusted Certifications checkbox. Leaving this option unchecked results in a connection issue with SQL Server.
6. Click OK and the error is displayed

Expected behavior
I should connect to the SQL server without being presented with an error message

Screenshots

Log file
demomodel-7NLN9K.txt

[v-Hailishi]

I can also repro this bug on the latest main build 17.18.2.2421201.

[LittleLittleCloud]

@zewditu can you take a look?

[rkpatrick]

I have this issue as well. As a workaround, I'm exporting some of my data to CSV and building from that.

[LittleLittleCloud]

Thanks I will try reproducing this

[nmqh]

I'm having same issue.

[LittleLittleCloud]

Update

I'm able to reproduce this issue on my end, and when I disable trust server certificate on loading sql server page the error disappear. So maybe @rkpatrick @cakeezer @nmqh this can be a workaround?

[rkpatrick]

In my environment, if I uncheck that box, I can't see any databases in the dropdown

[LittleLittleCloud]

After some investigation, the root cause seems to be caused by this issue. My assumption is VS Dev17 upgrades to use Microsoft.Data.SqlClient while model builder still uses System.Data.SqlClient

• Backwards incompatibility between Microsoft.Data.SqlClient.SqlConnectionStringBuilder and System.Data.SqlClient.SqlConnectionStringBuilder SqlClient#1780

I'll push a fix on model builder side to fix this issue

[cakeezer]

Awesome! Thank you for the quick response.

…

On Tue, Apr 23, 2024, 5:15 PM Xiaoyun Zhang ***@***.***> wrote: After some investigation, the root cause seems to be caused by this issue. My assumption is VS Dev17 upgrades to use Microsoft.Data.SqlClient while model builder still uses System.Data.SqlClient - dotnet/SqlClient#1780 <dotnet/SqlClient#1780> I'll push a fix on model builder side to fix this issue — Reply to this email directly, view it on GitHub <#2899 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/AEIHZ7MS4NI4ZKYZX7LTSOLY63FQPAVCNFSM6AAAAABGCDOPXGVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDANZTGQ2TQMBRHE> . You are receiving this because you were mentioned.Message ID: ***@***.***>

[v-Hailishi]

The bug has been fixed on the latest main build 17.18.4.2422301.

[VipinVenugopal1]

17.18.4.2422301

Link to download this latest version?

[VipinVenugopal1]

The bug has been fixed on the latest main build 17.18.4.2422301.
when would this version be available for downloading ?

[LittleLittleCloud]

This version has been shipped with latest vs 2022 preview.

@JakeRadMSFT should we make another release to gallery

[ArlenLi]

hey @LittleLittleCloud , do we know when a non-preview release containing this fix would be published?