microsoft jdbc driver 4.0 for sql server timeout

I suspect there may be 2 problems here, I think there is a problem with how I'm trying to get Windows Authentication working but I also suspect there is a problem with how I have written my Database URL.

Ok, my server is actually operating in mixed mode, so switching back to the Microsoft driver, I have tried giving KNIME the SA account details(dangerous game). Ps Using Windows XP 32 bit, have SQL Server 20 management studios installed on client machine with the server running 2005. I've looked at a few other forum posts but haven't found one that explains the process of getting drivers. I have looked in Preferences->KNIME->Database Driver where I am presented with an empty list box and an option to add new, unfortunately I don't know where the driver would be, if the driver is already included in my KNIME installation or whether I need to download it first. This is followed by the various username/password and SQL script options.įrom what I've managed to find out, I believe I need the Microsoft JDBC driver, so my question is how do I load this driver in order to establish a connection to a SQL Server database? When I try to configure the Database Reader node I am presented with a drop down where the only option is:Īnd another dropdown for the database URL:

I'm trying to set up a connection to Microsoft SQL Server using the Database Reader node but I am running into some issues, mainly due to my lack of knowledge I think.

I'm very new to Knime so please be gentle with me!

Microsoft jdbc driver 4.0 for sql server timeout