Can't create credential for Google Cloud SQL Server

[hartmanphil99]

I cannot create a usable credential in n8n cloud for my Google Cloud Platform SQL database running SQL Server 2019 Express. When I try to save the credential, it immediately executes a test and the test fails with the error message: “Failed to connect to xx.xx.xx.xx:1433 in 15000ms” where I have masked my public IP. I’ve done this successfully multiple times for SQL Server running in Azure with no issues.

I have SQL Server Management Studio v19 running on my laptop and can connect easily so I know I have the correct public IP address, SQL server port(1433), user ID, and password. I’ve enabled TLS. I do have a firewall rule set up in GCP for my laptop’s IP. I wonder if I need a firewall rule for n8n cloud to connect to my database in GCP? If so, what would be the CIDR notation I should use?

There’s no workflow to share as I can’t get a working credential

Information on your n8n setup

• n8n version: [email protected]
• Database (default: SQLite): ? using n8n cloud
• n8n EXECUTIONS_PROCESS setting (default: own, main): ?
• Running n8n via (Docker, npm, n8n cloud, desktop app): n8n cloud
• Operating system: my laptop is Windows 11

[Abdelilah_KAHAJI]

@hartmanphil99

xx.xx.xx.xx:1433

I have the same problem, in fact the issue comes from the fact that n8n places a ‘:’ between the server instance and the port whereas it should place a ‘,’
The address should be xx.xx.xx.xx,1433 and not xx.xx.xx.xx:1433
I have not yet found a solution.

[tien_ta]

Hi all,
I just changed ingoed SSL and it worked.