Connecting auth0 to existing database hosted on Google Cloud Platform

[wolfbrownie1995]

I am new to auth0 and I am going crazy trying utilize custom action scripts to connect to my existing sql database.
I currently have a sqlserver db hosted on Google Cloud Platform and below is my custom connection in the login action script but when i click test I keep getting the error below. Any help would be greatly appreciated!!!

const connection = new Connection({
userName: ‘usernamegoeshere’,
password: ‘passwordgoeshere’,
server: ‘34.121.229.78’,
options: {
database: ‘stutor-291218:us-central1:stutor-sql-db’
}
});

error: “Failed to connect to 34.121.229.78:1433 in 15000ms”

[art.rosnovsky]

Hey @wolfbrownie1995, welcome to the community!

I’ve seen this issue before. There might be some sort of allowList for incoming connections from external IPs. I ran a quick port scan of 34.121.229.78 and it looks like only ports 53 and 3307 are open. Could you check firewall/DB settings in Google and open port 1433?