dotnet / machinelearning-modelbuilder

Simple UI tool to build custom machine learning models.
Creative Commons Attribution 4.0 International
264 stars 56 forks source link

There is no way to connect SQL Server because of the authentication error.in MLNET. #2870

Open chanmmn opened 7 months ago

chanmmn commented 7 months ago

System Information (please complete the following information):

Describe the bug

To Reproduce Steps to reproduce the behavior:

  1. Go to '...'
  2. Click on '....'
  3. Scroll down to '....'
  4. See error' It is all recorded in this video: https://drive.google.com/file/d/19qD1rYPsZMbD1e_iPJ2vXTos2_EGOX1C/view?usp=sharing

Expected behavior Connect to SQL Server without error.

Screenshots In the video: https://drive.google.com/file/d/19qD1rYPsZMbD1e_iPJ2vXTos2_EGOX1C/view?usp=sharing

Additional context Add any other context about the problem here.

LittleLittleCloud commented 7 months ago

@chanmmn Looks like the authentication succeed when you use pwd && user name because the dataset is loading correctly

This error probably caused by another issue (data malformat). Would you mind export the sql for table coldategroup so I can reproduce it on my end, thanks

image

chanmmn commented 7 months ago

Hi @LittleLittleCloud ,

Thanks for your prompt reply. I shared the coldategroup in the link below : https://drive.google.com/drive/folders/1AOiexCUJEqbnGw4uPLG7qyZM8Jf9c2qU?usp=sharing Please note that I changed all the uco_in_kg to 1000 due to those values are the real company data.

As the same time, you can find 2 logs file I uploaded MLModel1-O6TH1G.txt and MLModel1-I5I4MS.txt.