KNIME node DB Writer not showing any tables on Azure SQL DB

KNIME Analytics Platform
1

Hi everyone, this is my first post her.

I have a SQL DB on azure and I have connected to it using sqladmin id from my SQL server management studio.I can see the below tables.

Capture1
Capture1645×799 56.9 KB

When I connect to DB using DB connector node with same user, I can get connected well.

Capture2
Capture2690×585 36.1 KB

But when I click on the tables from DB writer node, I am unable to see any of the tables as shows in the picture above.

Capture3
Capture3428×597 29.6 KB

Appreciate any inputs on this issue.

Shrirama

2

worked fine when I changed the connection string from

jdbc:jtds:sqlserver://Center-explo-dc-euno-001-sqs.database.windows.net:1433;center-ex-dc-eu-001-sqd

jdbc:jtds:sqlserver://Center-explo-dc-euno-001-sqs.database.windows.net:1433/center-ex-dc-eu-001-sqd

1 Like
3

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.