Hi Ivan,
Sorry for the delay in response.
Thank you so much for taking the time to support me with this, I’m the only one in my company who uses KNIME and it makes a difference knowing I’ve got somewhere to turn to when I get stuck.
Whilst I was offsite yesterday I was able to do some further research and I’ve figured out the problem. My SQL database is an Azure SQL database. I’m sorry I didn’t mention this, I thought the Azure SQL database was basically the same as a regular SQL Server. I didn’t realise that it required a slightly different set up. Anyway, I followed the instructions linked below and have got it working:
Thanks again for your help - I really appreciate it.
Kind regards,
Kate