I am trying to connect to SQL server database at my workplace and I am running into issues. I have downloaded the SQL server driver from microsoft and copied the jdbc41.jar to the KNIME/plugins folder and have set the preferences option to refer to that file in FILE>Prefrences>KNIME path. I am getting the following error.
Thanks for your response , I tried to look for SQL jdbc in the software list but was not able to see any listing, do I have to select a particular option from the dropdown ?
Is there any particular reason why you downloaded this driver cause to my knowledge you do not have to add additional driver for connecting to Microsoft SQL Server. Try removing this driver and then connect to your database.
Thanks for the response. I was not aware of the help>install software>Available Sites option and was looking to install MS SQL driver. After the advice I got in this thread I am able to install SQL driver and connect to the database.