Cant connect to SQL(SSMS) via n8n

Questions
1

Hello everybody, i have a problem. I tried to set up credentials for localhost of by DB. I set up user, tcp port but it still cant connect… What am i doing wrong?
Running n8n in cloud

image
image843×1234 27.1 KB

image
image1318×1133 41 KB

image
image1337×1135 39.6 KB

2

It looks like your topic is missing some important information. Could you provide the following if applicable.

  • n8n version:
  • Database (default: SQLite):
  • n8n EXECUTIONS_PROCESS setting (default: own, main):
  • Running n8n via (Docker, npm, n8n cloud, desktop app):
  • Operating system:
3

oh…

If you have n8n in the cloud, then there is no localhost. Probably you have installed the DB on your PC and it won’t be accessible from the internet.

You have to expose the DB to the internet (via port forwarding), so the n8n could access it.

1 Like
4

Thanks, i set up n8n via npm and it worked <3

5

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