i've created a database in Microsoft SQL for my University Exam. And now i have to analyse it in KNIME.
I don't exactly know how to connect those two now. I've tried different things in this forum already, nothing seems to work for me.
Now I've tried to link them with a Database Connector, but i'll always get a error that my Port number isnt correct.
" jdbc:sqlserver://<127.0.0.1>:<80>/<Knime_Szenario> ". This is what i typed in. The server is running on my local pc and i've looked up the port number in the configuration menu of the server.
I dont know if "Database Connector" is even the right thing.
Thanks in advance.