Trouble connecting AWS RDS SQL Server instance [Feb 20]

[NocoDB]

CharlesC asked

Used the 1-click deployment to Heroku. Having trouble connecting to aws rds sql server instance. Anyone else run into something similar. Thanks.

[NocoDB]

dstala replied

@charles, can you help us with more details on the error that you are facing?

Error logs or Screenshots if available will help.

[NocoDB]

CharlesC replied

[NocoDB]

CharlesC replied

[NocoDB]

CharlesC replied

[NocoDB]

CharlesC replied

Should mention that I’m able to connect via Microsoft Management Studio. Thanks.

[NocoDB]

dstala replied

CharlesC@discord

The problem observed, we suspect could be similar to the one discussed here

Discord

Let us try the following & see if it helps

1. Open “Edit Connection JSON” – to update Knex timeout configurations

> 1a. New Project

> 1b. Create by connecting to External database

> 1c. SSL & Advanced Parameters

> 1d. Edit connection JSON

Video demo to access above details: https://www.youtube.com/watch?v=rS0NRwRCjx0

2. Add/ update following connection parameters :

> 2a. connectTimeout,

> 2b. requestTimeout,

> 2c. acquireConnectionTimeout

Sample here:

“connection”: {

“host”: “localhost”,

“port”: “47536”,

“user”: “MyLogin”,

“password”: “password”,

“database”: “sakila”,

“connectTimeout”: “180000”,

“requestTimeout”: 180000,

“ssl”: {

“ca”: “”,

“key”: “”,

“cert”: “”

}

},

“pool”: {

“min”: 0,

“max”: 10

},

“acquireConnectionTimeout”: 180000,

[NocoDB]

wkw replied

CharlesC@discord u may also check the security groups for RDS as well.

[NocoDB]

CharlesC replied

Got it to work! Thanks wkw@discord and dstala@discord!

[NocoDB]

dstala replied

CharlesC@discord

What was issue? Was it Security group config?

[NocoDB]

CharlesC replied

Yes, I had to add an inbound TCP rule.

[NocoDB]

dstala replied

Thank you CharlesC@discord

[NocoDB]

Autogenerated from discord

---

Join NocoDB’s community

Discord • Twitter • Reddit • Docs