Unable to connect to a SQL server

Hi,
I’m having trouble connecting to a SQL server.
When my project builds I get the following error: ConnectionError: Failed to connect to CWCURDCDBP01:1433 - getaddrinfo ENOTFOUND CWCURDCDBP01

My project connects to the DB fine when I run it in VsCode, but when I upload it on render I encounter the issue.

Does anyone know if you need to allow for something in order for a SQL server connection to be made?


This is my DB Config
var config = {
user: ‘MyUsername’,
password: ‘MyPassword’,
server: ‘DBP1’,
database: ‘MyDatabase’,
options: {
trustServerCertificate: true
}
};

Hi there,

port 1433 is a SQL Server port if I’m not mistaken - if that’s not being hosted on Render then you’d need to either be using an IP address or a full domain name to access the SQL server from a Render service

CWCURDCDBP01 looks suspiciously like an internal hostname

Regards,

John B
Render Support, UTC+1 :uk:

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