# Trouble connecting AWS RDS SQL Server instance \[Feb 20\]

**URL:** <https://community.nocodb.com/t/trouble-connecting-aws-rds-sql-server-instance-feb-20/200>\
**Category:** Discord-Discussions\
**Created:** [November 3, 2022, 8:00am UTC](https://community.nocodb.com/t/trouble-connecting-aws-rds-sql-server-instance-feb-20/200 "2022-11-03T08:00:09Z")\
**Posts on this page:** 13\
**Page:** 1

<div class="post-metadata">

**Author:** ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)\
**Post date:** [November 3, 2022, 8:00am UTC](https://community.nocodb.com/t/trouble-connecting-aws-rds-sql-server-instance-feb-20/200/1 "2022-11-03T08:00:10Z")

</div>

> 🙋‍♂️ **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.

---

<div class="post-metadata">

**Author:** ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)\
**Post date:** [November 3, 2022, 8:00am UTC](https://community.nocodb.com/t/trouble-connecting-aws-rds-sql-server-instance-feb-20/200/2 "2022-11-03T08:00:11Z")

</div>

> 👨‍🦲 **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.

#

---

<div class="post-metadata">

**Author:** ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)\
**Post date:** [November 3, 2022, 8:00am UTC](https://community.nocodb.com/t/trouble-connecting-aws-rds-sql-server-instance-feb-20/200/3 "2022-11-03T08:00:12Z")

</div>

> 🙋‍♂️ **CharlesC** _replied_

#### 

 ![image0](https://canada1.discourse-cdn.com/flex011/uploads/nocodb/original/1X/511bf61366a3ed6ca8b256c4a4877b4db13d1df0.png)

#

---

<div class="post-metadata">

**Author:** ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)\
**Post date:** [November 3, 2022, 8:00am UTC](https://community.nocodb.com/t/trouble-connecting-aws-rds-sql-server-instance-feb-20/200/4 "2022-11-03T08:00:13Z")

</div>

> 🙋‍♂️ **CharlesC** _replied_

#### 

 ![image0](https://canada1.discourse-cdn.com/flex011/uploads/nocodb/original/1X/b9c87a2970ad1abc8b0b0cffa09cdf534bb2470c.png)

#

---

<div class="post-metadata">

**Author:** ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)\
**Post date:** [November 3, 2022, 8:00am UTC](https://community.nocodb.com/t/trouble-connecting-aws-rds-sql-server-instance-feb-20/200/5 "2022-11-03T08:00:14Z")

</div>

> 🙋‍♂️ **CharlesC** _replied_

#### 

 ![image0](https://canada1.discourse-cdn.com/flex011/uploads/nocodb/original/1X/7e0c8d8366a5a42862e5c4bd5ae678cceea74021.png)

#

---

<div class="post-metadata">

**Author:** ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)\
**Post date:** [November 3, 2022, 8:00am UTC](https://community.nocodb.com/t/trouble-connecting-aws-rds-sql-server-instance-feb-20/200/6 "2022-11-03T08:00:16Z")

</div>

> 🙋‍♂️ **CharlesC** _replied_

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

#

---

<div class="post-metadata">

**Author:** ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)\
**Post date:** [November 3, 2022, 8:00am UTC](https://community.nocodb.com/t/trouble-connecting-aws-rds-sql-server-instance-feb-20/200/7 "2022-11-03T08:00:17Z")

</div>

> 👨‍🦲 **dstala** _replied_

#### CharlesC@discord

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

#### [Discord](https://discord.com/channels/661905455894888490/943768443172298783)

#### 

#### 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](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,

#

---

<div class="post-metadata">

**Author:** ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)\
**Post date:** [November 3, 2022, 8:00am UTC](https://community.nocodb.com/t/trouble-connecting-aws-rds-sql-server-instance-feb-20/200/8 "2022-11-03T08:00:18Z")

</div>

> 🙋‍♂️ **wkw** _replied_

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

#

---

<div class="post-metadata">

**Author:** ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)\
**Post date:** [November 3, 2022, 8:00am UTC](https://community.nocodb.com/t/trouble-connecting-aws-rds-sql-server-instance-feb-20/200/9 "2022-11-03T08:00:19Z")

</div>

> 🙋‍♂️ **CharlesC** _replied_

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

#

---

<div class="post-metadata">

**Author:** ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)\
**Post date:** [November 3, 2022, 8:00am UTC](https://community.nocodb.com/t/trouble-connecting-aws-rds-sql-server-instance-feb-20/200/10 "2022-11-03T08:00:21Z")

</div>

> 👨‍🦲 **dstala** _replied_

#### CharlesC@discord

#### What was issue? Was it Security group config?

#

---

<div class="post-metadata">

**Author:** ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)\
**Post date:** [November 3, 2022, 8:00am UTC](https://community.nocodb.com/t/trouble-connecting-aws-rds-sql-server-instance-feb-20/200/11 "2022-11-03T08:00:22Z")

</div>

> 🙋‍♂️ **CharlesC** _replied_

#### Yes, I had to add an inbound TCP rule.

#

---

<div class="post-metadata">

**Author:** ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)\
**Post date:** [November 3, 2022, 8:00am UTC](https://community.nocodb.com/t/trouble-connecting-aws-rds-sql-server-instance-feb-20/200/12 "2022-11-03T08:00:23Z")

</div>

> 👨‍🦲 **dstala** _replied_

#### Thank you CharlesC@discord

#

---

<div class="post-metadata">

**Author:** ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)\
**Post date:** [November 3, 2022, 8:00am UTC](https://community.nocodb.com/t/trouble-connecting-aws-rds-sql-server-instance-feb-20/200/13 "2022-11-03T08:00:24Z")

</div>

[Autogenerated from discord](https://discord.com/channels/661905455894888490/944143530534764545)

* * *

#### Join [NocoDB’s](http://www.nocodb.com/) community

[Discord](https://discord.gg/5RgZmkW) • [Twitter](https://twitter.com/nocodb) • [Reddit](https://www.reddit.com/r/NocoDB/) • [Docs](https://docs.nocodb.com/)