Authentication to mssql database using Python node does not work

[ksrai]

Thanks, Steffen!

I had checked everything in the Python integration guide before, the thing is, I cannot install the standard conda install directly within the organization, as it is blocked. So I had to build it all up by downloading individual packages.

I finally came across this post a few minutes ago, and though it is not directly related to my issue, it worked perfectly!:

Execution failed: Could not connect to the Python process

If you are setting up a manual environment… To test this out, I installed python 3.9 into a folder as follows: c:\apps\python39 [image] and then made sure that python 3.9 was on the path: [image] In KNIME I set my python folder manually: [image] It complained about numpy and pandas so in a command prompt I executed the following: pip install numpy pip install pandas [image] I created a new workflow and on it placed an Empty Table Creator and a Python Script node. But executing t…

I had to install some more Python packages mentioned and everything fell in place!

Thanks again for your support.