dotnet / dotnet/machinelearning-modelbuilder

Keyword not supported: 'trust server certificate'

Open
#2,899 14 comments 0 reactions 0 assignees View on GitHub
GS Tutorial Priority:0
Dominant language
Dockerfile
Stars
285
Forks
66
PR merge metrics
No merged PRs in 30d

Description

**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**
![image](https://github.com/dotnet/machinelearning-modelbuilder/assets/17857789/eb4c490e-567a-401d-ae23-381dab99eab7)
![image](https://github.com/dotnet/machinelearning-modelbuilder/assets/17857789/71522215-4b1c-4be8-b597-8d2eec384297)

**Log file**
[demomodel-7NLN9K.txt](https://github.com/dotnet/machinelearning-modelbuilder/files/14945447/demomodel-7NLN9K.txt)

Contributor guide

No contributing guide indexed for this repository

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.